TSO command to load the DB2 table into normal PS

vicharapusrinu · New User Joined: 04 Dec 2006 Posts: 63 Location: Hyderabad

Hi,

Could some one help me out here please?

What is TSO command to load the DB2 table into normal PS?

Regards,
Srini

dick scherrer · Posted: Fri Feb 19, 2010 8:53 pm

Hello,

There is no such "tso command" that i'm aware of. . .

What is a "normal PS? Typically, to get data from a database table into a sequential file, one uses UNLOAD or some bit of code to select the needed info.

superk · Posted: Fri Feb 19, 2010 9:03 pm

Dick, we don't have DB2 where I work, but, if I remember correctly, isn't the SPUFI command available in TSO?

Anuj Dhawan · Posted: Fri Feb 19, 2010 9:05 pm

Unfotunately, you've explained your probelm in a very poor manner - "normal PS" does not make any sense, did you mean QSAM (flat file)? If yes, what are your options - QMF? dsntiaul? or..?

If you have QMF, may be "import/export" are the commands which you might be referring as "TSO commands" but they are not TSO commands, they are QMF specific commands.

DB2 runs as just other sub-system on z/OS, but there is no native TSO/ISPF command to talk it directly...AFAIK.

dick scherrer · Posted: Fri Feb 19, 2010 9:08 pm

Hi Kevin,

Yup, SPUFI is usually available on db2 systems, but i'd probably not call it a command

It is usually an entire sub-Menu from the main tso/ispf primary menu: