How to move/ transfer the data from a ps file to db2 table

nandakumar · New User Joined: 05 May 2005 Posts: 49

hi,

How to move (or) transfer the data from a ps file to db2 table.

priya · Posted: Tue Jun 07, 2005 8:29 pm Post subject:

use LOAD utility

radhakrishnan82 · Posted: Wed Jun 08, 2005 1:54 pm Post subject:

You can extract data from a table or load data to a table using the Load utility.Use option P;B;3;3.7(Extract and Load Tables)

raj_usb4u · New User Joined: 08 Jun 2005 Posts: 1

[quote="nandakumar"]hi,

How to move (or) transfer the data from a ps file to db2 table.[/quote]

You can load data into Db2 tables from sequencial table by using utility called 'DSNUPROC' where you have to mention

//DSNUPROC.SYSREC00 DD DSN='Your sequential file name'
//DSNUPROC.SYSIN DD DSN='Load card of your table'

nandakumar · New User Joined: 05 May 2005 Posts: 49

hi,

i need a clear example program,to load data into Db2 tables from sequencial table by using utility 'DSNUPROC'

thanking u.