MVSFORUMS.com Forum Index MVSFORUMS.com
A Community of and for MVS Professionals
 
 FAQFAQ   SearchSearch   Quick Manuals   RegisterRegister 
 ProfileProfile   Log in to check your private messagesLog in to check your private messages   Log inLog in 

Read a sequential file with SQL

 
Post new topic   Reply to topic   printer-friendly view    MVSFORUMS.com Forum Index -> Application Programming
View previous topic :: View next topic  
Author Message
Gerd Hofmans
Beginner


Joined: 15 Jan 2016
Posts: 20
Topics: 7

PostPosted: Mon Nov 28, 2016 5:32 am    Post subject: Read a sequential file with SQL Reply with quote

Hi,
I need to read a sequential file on z/OS with SQL, but cannot find a decent manual how to do this, nor the JCL to use for this.
Do you have any suggestion where to look?
Kind Regards, Gerd.
Back to top
View user's profile Send private message
CZerfas
Intermediate


Joined: 31 Jan 2003
Posts: 211
Topics: 8

PostPosted: Mon Nov 28, 2016 9:57 am    Post subject: Reply with quote

SQL is the front-end to work with the contents of DB2 databases. You cannot read sequential files with SQL.

regards
Christian
Back to top
View user's profile Send private message
kolusu
Site Admin
Site Admin


Joined: 26 Nov 2002
Posts: 12358
Topics: 75
Location: San Jose

PostPosted: Mon Nov 28, 2016 10:37 am    Post subject: Reply with quote

Gerd Hofmans,

AS/400 (Application System/400) lets you read a file as SQL and lets you query the file.

on z/OS you can read the file and access a DB2 table using a cursor/stand-alone sql and perform your reporting/calculations/data manipulation.

Let us know if you need examples of that.
_________________
Kolusu - DFSORT Development Team (IBM)
DFSORT is on the Web at:
www.ibm.com/storage/dfsort

www.linkedin.com/in/kolusu
Back to top
View user's profile Send private message Send e-mail Visit poster's website
Display posts from previous:   
Post new topic   Reply to topic   printer-friendly view    MVSFORUMS.com Forum Index -> Application Programming All times are GMT - 5 Hours
Page 1 of 1

 
Jump to:  
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


MVSFORUMS
Powered by phpBB © 2001, 2005 phpBB Group