Portal | Manuals | References | Downloads | Info | Programs | JCLs | Master the Mainframes
IBM Mainframe Computers Forums Index
 
Register
 
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist Usergroups Profile Log in to check your private messages Log in
 

 

Move the content of ps file to db2 table & Vise versa

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> Mainframe Interview Questions
View previous topic :: :: View next topic  
Author Message
nandakumar
Warnings : 2

New User


Joined: 05 May 2005
Posts: 50

PostPosted: Tue Jun 07, 2005 7:49 pm    Post subject: Move the content of ps file to db2 table & Vise versa
Reply with quote

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
View user's profile Send private message

priya

Moderator


Joined: 24 Jul 2003
Posts: 568
Location: Bangalore

PostPosted: Tue Jun 07, 2005 8:37 pm    Post subject:
Reply with quote

Use UPLOAD utility
Back to top
View user's profile Send private message
nandakumar
Warnings : 2

New User


Joined: 05 May 2005
Posts: 50

PostPosted: Wed Jun 08, 2005 5:06 pm    Post subject:
Reply with quote

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
View user's profile Send private message
sudheer648

New User


Joined: 23 May 2005
Posts: 97
Location: Chennai

PostPosted: Thu Jun 16, 2005 3:09 pm    Post subject: Re: Move the content of ps file to db2 table & Vise vers
Reply with quote

Hi Priya,

Quote:
Use UPLOAD utility


Please could elaborate something about this utility am not aware of this utility.
Back to top
View user's profile Send private message
MGIndaco

Active User


Joined: 10 Mar 2005
Posts: 432
Location: Milan, Italy

PostPosted: Thu Jun 16, 2005 9:06 pm    Post subject:
Reply with quote

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
View user's profile Send private message
sudheer648

New User


Joined: 23 May 2005
Posts: 97
Location: Chennai

PostPosted: Fri Jun 17, 2005 4:11 pm    Post subject: Re: Move the content of ps file to db2 table & Vise vers
Reply with quote

MGIndaco,

Its too good.Hats off for your search.
Back to top
View user's profile Send private message
View previous topic :: :: View next topic  
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> Mainframe Interview Questions All times are GMT + 6 Hours
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
No new posts SSH - known_hosts file configuration vasanthz All Other Mainframe Topics 0 Wed Jul 26, 2017 2:10 am
This topic is locked: you cannot edit posts or make replies. Fetching data from BAI File arunsoods JCL & VSAM 1 Wed Jul 19, 2017 4:28 pm
No new posts Write out NODUPS but just from one file Jay Villaverde DFSORT/ICETOOL 8 Fri Jul 14, 2017 12:44 am
No new posts Loading data to table gives wrong for... Raghu navaikulam DB2 19 Thu Jul 13, 2017 2:11 pm
No new posts How to add header with Date(YYMMDD) i... Rajan Moorthy DFSORT/ICETOOL 2 Thu Jul 06, 2017 11:44 pm


Facebook
Back to Top
 
Mainframe Wiki | Forum Rules | Bookmarks | Subscriptions | FAQ | Tutorials | Contact Us