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 TSO or command line utility to genera... kishpra JCL & VSAM 3 Thu Mar 09, 2017 1:11 am
No new posts Customizing the ISPF HILITE Command Pedro TSO/ISPF 3 Fri Mar 03, 2017 11:49 pm
No new posts how to send just 10 rows in a CICS sc... Megha Gupta CICS 5 Thu Feb 23, 2017 6:57 pm
No new posts Join of more than one table dibyendumandal11111 DB2 6 Mon Feb 13, 2017 11:36 pm
No new posts Can DFSPARM override SORTKEYS paramet... ashek15 DB2 2 Tue Jan 31, 2017 11:36 pm


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