MVSFORUMS.com

Gerd Hofmans · Beginner Joined: 15 Jan 2016 Posts: 20 Topics: 7

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.

CZerfas · Intermediate Joined: 31 Jan 2003 Posts: 211 Topics: 8

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

regards
Christian

kolusu · Posted: Mon Nov 28, 2016 10:37 am Post subject:

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
www.linkedin.com/in/kolusu