Page 1 of 1

interface ps with db2 table

PostPosted: Thu Dec 17, 2009 10:13 am
by sswethajain
How to fetch records from ps and insert it into db2 table?

Re: interface ps with db2 table

PostPosted: Thu Dec 17, 2009 6:37 pm
by swd
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.

Re: interface ps with db2 table

PostPosted: Tue Jan 05, 2010 7:04 pm
by Anuj Dhawan
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!