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
 

 

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: 4648
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 Cobol upgrade - source code missing f... gthmrj IBM Tools 1 Wed Apr 26, 2017 6:04 pm
No new posts unload data from table with lob columns farhad_evan DB2 0 Sat Apr 22, 2017 1:32 pm
No new posts Copy load modules and alias vasanthz IBM Tools 5 Thu Apr 20, 2017 6:31 am
No new posts Data replication from multiple Db2 ta... kishpra DB2 9 Mon Mar 27, 2017 9:58 pm
No new posts TSO or command line utility to genera... kishpra JCL & VSAM 3 Thu Mar 09, 2017 1:11 am


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