#1: Read a sequential file with SQL Author: Gerd Hofmans, Posted: Mon Nov 28, 2016 5:32 am — 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.
#2: Author: CZerfas, Posted: Mon Nov 28, 2016 9:57 am — SQL is the front-end to work with the contents of DB2 databases. You cannot read sequential files with SQL.
regards
Christian
#3: Author: kolusu, Location: San JosePosted: Mon Nov 28, 2016 10:37 am — 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.
