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



IBM's flagship relational database management system

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

Postby shivam » Wed Aug 26, 2009 9:28 pm

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...
shivam
 
Posts: 1
Joined: Thu May 21, 2009 6:39 pm
Has thanked: 0 time
Been thanked: 0 time

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

Postby dick scherrer » Thu Aug 27, 2009 12:27 am

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 . . .
Hope this helps,
d.sch.
User avatar
dick scherrer
Global moderator
 
Posts: 6268
Joined: Sat Jun 09, 2007 8:58 am
Has thanked: 3 times
Been thanked: 93 times

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

Postby jitender_2004bhiwani » Fri Nov 20, 2009 12:14 pm

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
jitender_2004bhiwani
 
Posts: 10
Joined: Fri Nov 20, 2009 8:42 am
Has thanked: 0 time
Been thanked: 0 time


Return to DB2

 


  • Related topics
    Replies
    Views
    Last post