Portal | Manuals | References | Downloads | Info | Programs | JCLs | Mainframe wiki | Quick Ref
IBM Mainframe Computers Forums Index
 
Register
 
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist Profile Log in to check your private messages Log in
 
TSO command to load the DB2 table into normal PS

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> DB2
View previous topic :: :: View next topic  
Author Message
vicharapusrinu
Warnings : 1

New User


Joined: 04 Dec 2006
Posts: 63
Location: Hyderabad

PostPosted: Fri Feb 19, 2010 7:17 pm    Post subject: TSO command to load the DB2 table into normal PS
Reply with quote

Hi,

Could some one help me out here please?

What is TSO command to load the DB2 table into normal PS?

Regards,
Srini
Back to top
View user's profile Send private message

dick scherrer

Site Director


Joined: 23 Nov 2006
Posts: 19270
Location: Inside the Matrix

PostPosted: Fri Feb 19, 2010 8:53 pm    Post subject:
Reply with quote

Hello,

There is no such "tso command" that i'm aware of. . .

What is a "normal PS? Typically, to get data from a database table into a sequential file, one uses UNLOAD or some bit of code to select the needed info.
Back to top
View user's profile Send private message
superk

Moderator Team Head


Joined: 26 Apr 2004
Posts: 4650
Location: Raleigh, NC, USA

PostPosted: Fri Feb 19, 2010 9:03 pm    Post subject: Reply to: TSO command to load the DB2 table into normal PS
Reply with quote

Dick, we don't have DB2 where I work, but, if I remember correctly, isn't the SPUFI command available in TSO?
Back to top
View user's profile Send private message
Anuj Dhawan

Senior Member


Joined: 22 Apr 2006
Posts: 6258
Location: Mumbai, India

PostPosted: Fri Feb 19, 2010 9:05 pm    Post subject:
Reply with quote

Unfotunately, you've explained your probelm in a very poor manner - "normal PS" does not make any sense, did you mean QSAM (flat file)? If yes, what are your options - QMF? dsntiaul? or..?

If you have QMF, may be "import/export" are the commands which you might be referring as "TSO commands" but they are not TSO commands, they are QMF specific commands.

DB2 runs as just other sub-system on z/OS, but there is no native TSO/ISPF command to talk it directly...AFAIK.
Back to top
View user's profile Send private message
dick scherrer

Site Director


Joined: 23 Nov 2006
Posts: 19270
Location: Inside the Matrix

PostPosted: Fri Feb 19, 2010 9:08 pm    Post subject:
Reply with quote

Hi Kevin,

Yup, SPUFI is usually available on db2 systems, but i'd probably not call it a command icon_smile.gif

It is usually an entire sub-Menu from the main tso/ispf primary menu:
Code:
                            DB2Q  PRIMARY OPTION MENU          SSID: DSNQ     
COMMAND ===>                                                                 
                                                                             
Select one of the following DB2 functions and press ENTER.                   
                                                                             
 1  SPUFI                  (Process SQL statements)                         
 2  DCLGEN                 (Generate SQL and source language declarations)   
 3  PROGRAM PREPARATION    (Prepare a DB2 application program to run)       
 4  PRECOMPILE             (Invoke DB2 precompiler)                         
 5  BIND/REBIND/FREE       (BIND, REBIND, or FREE plans or packages)         
 6  RUN                    (RUN an SQL program)                             
 7  DB2 COMMANDS           (Issue DB2 commands)                             
 8  UTILITIES              (Invoke DB2 utilities)                           
 D  DB2I DEFAULTS          (Set global parameters)                           
 X  EXIT                   (Leave DB2I)                                     
                                                       
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 -> DB2 All times are GMT + 6 Hours
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
No new posts Update table without cursor Ron Klop DB2 3 Wed Oct 11, 2017 1:06 pm
No new posts Table(Unicode(Graphic) table) loading... muralikrishnan_new DB2 0 Thu Oct 05, 2017 5:10 pm
No new posts MQ command in option 6 of ISPF! Vignesh Sid All Other Mainframe Topics 3 Tue Sep 26, 2017 6:01 pm
No new posts Insert a Row_number into table useit DB2 2 Tue Sep 19, 2017 1:07 pm
No new posts how to see when the last read access ... Mike 1304 DB2 1 Tue Sep 12, 2017 7:52 pm

Facebook
Back to Top
 
Job Vacancies | Forum Rules | Bookmarks | Subscriptions | FAQ | Polls | Contact Us