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 Converting Variable block file to Fix... bhavana yalavarthi DFSORT/ICETOOL 10 Tue May 16, 2017 2:20 pm
No new posts Getting error while opening a variabl... apandey1 COBOL Programming 5 Fri May 05, 2017 12:22 pm
No new posts Issue with NDM process to transmit ES... chetanambi All Other Mainframe Topics 6 Wed May 03, 2017 10:52 am
No new posts File processing vishwakotin Mainframe Interview Questions 9 Fri Apr 28, 2017 11:38 am
No new posts Occurrence of various strings within ... TS70363 JCL & VSAM 1 Thu Apr 27, 2017 8:18 pm


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