interface ps with db2 table



IBM's flagship relational database management system

interface ps with db2 table

Postby sswethajain » Thu Dec 17, 2009 10:13 am

How to fetch records from ps and insert it into db2 table?
sswethajain
 
Posts: 1
Joined: Thu Dec 17, 2009 10:04 am
Has thanked: 0 time
Been thanked: 0 time

Re: interface ps with db2 table

 

Re: interface ps with db2 table

Postby swd » Thu Dec 17, 2009 6:37 pm

If your ps file is not a DB2 unload file, then you could write a program to read the file and insert into the DB2 table. If your ps file is a DB2 unload file, then you can use the DB2 Load utility to load the data back into the DB2 table.
User avatar
swd
 
Posts: 109
Joined: Wed Feb 18, 2009 9:18 pm
Location: UK
Has thanked: 0 time
Been thanked: 0 time

Re: interface ps with db2 table

Postby Anuj Dhawan » Tue Jan 05, 2010 7:04 pm

sswethajain wrote:fetch records from ps
Just a terminology note, "fetch" sounds appropriate when talking about DB2/tables - COBOL READs a QSAM-files it does not fetch!
Anuj
Anuj Dhawan
 
Posts: 274
Joined: Mon Feb 25, 2008 3:53 am
Location: Mumbai, India
Has thanked: 6 times
Been thanked: 4 times


Return to DB2

 


  • Related topics
    Replies
    Views
    Last post