Page 1 of 1

How to copy Records from a DB2 table to a ps file

PostPosted: Wed Aug 26, 2009 9:28 pm
by shivam
Is it possible to copy records from a DB2 table to a ps file using SQL queries??? if so, pls post the details about how to handle this situation...

Re: How to copy Records from a DB2 table to a ps file

PostPosted: Thu Aug 27, 2009 12:27 am
by dick scherrer
Hello and welcome to the forum,

There are no records in a db2 table. . .

If you provide a better descriptoin of what you want to do, someone will be able to help.

Show an example of the table structure, a few sample rows, and what the ps output should contain when the sample rows are processed.

Use the "Code" tag for readability and to preserve alignment. Use the "Preview" to see the post as the forum will see it rather than the way it appears in the reply editor. When the appearance is as desired, Submit. Do not forget to Submit - the post will be lost . . .

Re: How to copy Records from a DB2 table to a ps file

PostPosted: Fri Nov 20, 2009 12:14 pm
by jitender_2004bhiwani
You can copy records from a DB2 table to a data set by using any of the below methods:
1) using DB2 fileaid
2) by using export command in QMF
3) by using UNLOAD utility