IBM Mainframe Forum

How to fetch records from ps and insert it into db2 table?

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.

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!