SQL Query using REXX

Ask/Clarify the questions on TSO, CLIST & REXX

Moderators: Veera, Moderator Group

DikDude
Moderator
Posts: 1001
Joined: Fri Jul 22, 2011 8:39 am
Location: usa

Post by DikDude » Sun Aug 14, 2011 7:10 pm

You need to talk with whoever installed or supports db2.

The process should be here:
DSNTIJRX
| is included in the target library if you have ordered DB2 REXX
| Language Support.

Whatever this is named on your system will only be known by someone who supports/uses your system. It is possible that it is not even available. . .
Have a good one

jasdeep.ja
Member
Posts: 11
Joined: Thu Aug 04, 2011 8:20 pm
Location: bangalore

Post by jasdeep.ja » Wed Aug 17, 2011 7:24 pm

jasdeep.ja wrote:

2.5.17 Installation step 17: Bind the packages for DB2 REXX Language Support: DSNTIJRX (optional)


Before you can use DB2 REXX Language Support, you must bind DB2 packages that DB2 REXX Language Support uses. Run job DSNTIJRX to do this. Before you run DSNTIJRX, make the following changes:

Add a job statement.
Change DSN SYSTEM(DSN) to DSN SYSTEM(ssid), where ssid is the name of the DB2 subsystem on which you will use DB2 REXX Language Support.
Change all instances of DSN!!0 to your DB2 data set name prefix.
Change all instances of DSNTIA!! to the plan name for the DSNTIAD program.

| Note: This job is not edited by the CLIST and will not be found in the
| SAMPLE LIBRARY from panel DSNTIPT (prefix.NEW.SDSNSAMP). DSNTIJRX
| is included in the target library if you have ordered DB2 REXX
| Language Support.




Now, where i can find this "DSNTIJRX" job.??/help


Hi Dikdude


I Checked with my DBADMIN and he confimerd that we have the supporting enviroment for DB2 REXX.
T & R
Jasdeep Singh

DikDude
Moderator
Posts: 1001
Joined: Fri Jul 22, 2011 8:39 am
Location: usa

Post by DikDude » Wed Aug 17, 2011 11:27 pm

I Checked with my DBADMIN and he confimerd that we have the supporting enviroment for DB2 REXX.
Have the entries you need also been made?

Suggest you work with the dba to get a prototype running and then go from there.
Have a good one

jasdeep.ja
Member
Posts: 11
Joined: Thu Aug 04, 2011 8:20 pm
Location: bangalore

Post by jasdeep.ja » Thu Aug 18, 2011 8:49 am

DikDude wrote:
I Checked with my DBADMIN and he confimerd that we have the supporting enviroment for DB2 REXX.
Have the entries you need also been made?

Suggest you work with the dba to get a prototype running and then go from there.
Yes.....DBADMIN said we have everything inplace.
T & R
Jasdeep Singh

DikDude
Moderator
Posts: 1001
Joined: Fri Jul 22, 2011 8:39 am
Location: usa

Post by DikDude » Thu Aug 18, 2011 10:08 am

To repeat:
Suggest you work with the dba to get a prototype running and then go from there.
Have a good one

Post Reply

FREE TUTORIALS

Tutorials
Free tutorials from mainframegurukul
  • JCL Tutorial
    Covers all important JCL concepts.
  • Cobol Tutorial
    This tutorials covers all Cobol Topics from STRING to COMP-3.
  • DB2 Tutorial
    DB2 Tutorial focuses on DB2 COBOL Programming.
  • SORT Tutorial
    This Tutorial covers all important aspects of DFSORT with examples
  • CICS Tutorial
    This CICS tutorial covers CICS concepts and CICS Basics, CICS COBOL Programming.
Interview
Mainframe Interview questions



Other References
Mainframe Tools and others