View previous topic :: View next topic
|
Author |
Message |
nandakumar Warnings : 2 New User
Joined: 05 May 2005 Posts: 50
|
|
|
|
hi,
how to move the content of ps file to db2 table.
how to move the content of db2 table to ps file
thanks in advance. |
|
Back to top |
|
|
priya
Moderator
Joined: 24 Jul 2003 Posts: 568 Location: Bangalore
|
|
|
|
Use UPLOAD utility |
|
Back to top |
|
|
nandakumar Warnings : 2 New User
Joined: 05 May 2005 Posts: 50
|
|
|
|
hi,
i want screen shot example for:
1) To move the content of ps file to db2 table.
2) To move the content of db2 table to ps file
Iam undergoing mainframe training now only,there we are not using load utility at all ,so can u plz give me some other method.
thanking u. |
|
Back to top |
|
|
sudheer648
New User
Joined: 23 May 2005 Posts: 97 Location: Chennai
|
|
|
|
Hi Priya,
Quote: |
Use UPLOAD utility |
Please could elaborate something about this utility am not aware of this utility. |
|
Back to top |
|
|
MGIndaco
Active User
Joined: 10 Mar 2005 Posts: 432 Location: Milan, Italy
|
|
|
|
To load data to DB2 from a PS(in UNLOAD format) you must have the SYSPUCH appropriate and adapt the PS layout to syspunch to be loaded.
If you want to load to DB2 a content of PS that is in IMAGECOPY format then the process is different.
This is the link to IBM Information Management Software to retrieve all the answers to your questions:
Load:
http://publib.boulder.ibm.com/infocenter/dzichelp/index.jsp?topic=/com.ibm.db2.doc.ugref/bjnbmstr35.htm
Samples of Load from IBM Manuals:
http://publibz.boulder.ibm.com/cgi-bin/bookmgr_OS390/handheld/Connected/BOOKS/DSNUG0F6/2.8.4.1?SHELF=&DT=20000421183700&CASE=
To unload data from DB2 to a PS you can use a simple UNLOAD that can extracts all the data of the table in its original dataformat or readapt, fields, format and other to your personal need.
These are two samples of unload:
1)Unload all:
Code: |
//STEP010U EXEC PGM=DSNTIAUL
//STEPLIB DD DISP=SHR,DSN=...steplib
//WFH.... DD DUMMY
//SYSTSPRT DD SYSOUT=*
//SYSPRINT DD SYSOUT=*
//SYSUDUMP DD SYSOUT=*
//SYSPUNCH DD SYSOUT=*
//SYSREC00 DD DSN=myoutput,
// DISP=(,CATLG,),SPACE=(CYL,(20,10),RLSE),
// UNIT=SYSDA
//SYSIN DD *
mytable |
2)Unload with select:
Code: |
//STEP010U EXEC PGM=DSNTIAUL,PARM='SQL'
//STEPLIB DD DISP=SHR,DSN=...steplib
//WFH.... DD DUMMY
//SYSTSPRT DD SYSOUT=*
//SYSPRINT DD SYSOUT=*
//SYSUDUMP DD SYSOUT=*
//SYSPUNCH DD SYSOUT=*
//SYSREC00 DD DSN=myoutput,
// DISP=(,CATLG,),SPACE=(CYL,(20,10),RLSE),
// UNIT=SYSDA
//SYSIN DD *
SELECT * FROM mytable; |
This is the link to IBM to retrieve all the parameters and informations:
http://publib.boulder.ibm.com/infocenter/dzichelp/index.jsp?topic=/com.ibm.db2.doc.ugref/bjnbmstr35.htm |
|
Back to top |
|
|
sudheer648
New User
Joined: 23 May 2005 Posts: 97 Location: Chennai
|
|
|
|
MGIndaco,
Its too good.Hats off for your search. |
|
Back to top |
|
|
|