How to copy the content of table to a ps file

nandakumar · New User Joined: 05 May 2005 Posts: 50

hi,

1)how to copy the content of table to a ps file, with example?

thanking u.

priyesh.agrawal · Posted: Mon Jul 04, 2005 12:28 am

You can use UNLOAD UTILITY to copy data from table to PS Files.

Regards,

Priyesh.

nandakumar · New User Joined: 05 May 2005 Posts: 50

hi,

i never used unload utilituy,i need an example for copiying the content of db2 table to ps file.

thanking u.

sivamf · New User Joined: 28 May 2005 Posts: 6

Why Cant you select the content of a table move it to variables and update the PS file it can be done using COBOL program.
Siva

Mamata · New User Joined: 01 Aug 2005 Posts: 4 Location: hyderabad

Hi,

To have the data of a table in a PS, use SPUFI to execute the query.
Here, u write the query in an input file and also specify the output file. So, it will directly store the data in the output PS file you have specified.

Regards,
Mamata.

Sangita · New User Joined: 02 Jun 2005 Posts: 17

Use DB2DSNUT Utility to download the table .
Give the data set name where u want the data of the table to be in SYSREC and give SELECT * FROM Table in the SYSIN DD *

Prasanthhere · Active User Joined: 03 Aug 2005 Posts: 306

To select the UNLOAD utility, enter 7 in the DB2 utility input field on the DB2 Utilities panel.

If you selected "Tables" in the Object Type section of the DB2 Utilities panel, the UNLOAD Utility (Tables) panel is displayed.

If you selected "Table spaces" in the Object Type section of the DB2 Utilities panel, the UNLOAD Utility (Table Spaces) panel is displayed.

Sample JCL generated for UNLOAD (Tables)