|
View previous topic :: View next topic
|
| Author |
Message |
nandakumar
Warnings : 2
New User
Joined: 05 May 2005
Posts: 50
|
|
|
|
hi,
How to move (or) transfer the data from a ps file to db2 table. |
|
| Back to top |
|
 |
priya
Moderator
Joined: 24 Jul 2003
Posts: 568
Location: Bangalore
|
|
|
|
| use LOAD utility |
|
| Back to top |
|
|
radhakrishnan82
Active User
Joined: 31 Mar 2005
Posts: 435
Location: chennai, India
|
|
|
|
| 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) |
|
| Back to top |
|
|
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' |
|
| Back to top |
|
|
nandakumar
Warnings : 2
New User
Joined: 05 May 2005
Posts: 50
|
|
|
|
hi,
i need a clear example program,to load data into Db2 tables from sequencial table by using utility 'DSNUPROC'
thanking u. |
|
| Back to top |
|
|
|
|
