How do I find or access the current level of a GDG?
Answers were Sorted based on User's Feedback
Answer / shakila vinayagam
Use Outtrap() on the output of TSO LISTCAT.
| Is This Answer Correct ? | 4 Yes | 0 No |
Answer / rainer bartosch
You may use this
CALL BPXWDYN "ALLOC DD(ddn) SHR DSN('"gdg"(0)') RTDSN(GDGN)"
Afterwards GDGD contains the name of the actual gdg data
set.
| Is This Answer Correct ? | 5 Yes | 2 No |
I am tryin to select one records(SQL) using Rexx.Here is the code ADDRESS DSNREXX "EXECSQL FETCH C1 USING DESCRIPTOR :TBSQLDA" IF SQLCODE = 0 THEN DO LINE = '' DO I = 1 TO TBSQLDA.SQLD LINE = LINE TBSQLDA.I.SQLDATA END I SAY LINE END ADDRESS DSNREXX "EXECSQL CLOSE C1" ADDRESS DSNREXX 'DISCONNECT' i am getting the following errors and also i dont know wr to see the ouput.Can anyone please hlep me in solving this? 28 +++ ADDRESS DSNREXX 'DISCONNECT' Error running DB2REXX, line 28: Incomplete DO/SELECT/IF
How to run my rexx exec?
If I have limited experience with Rexx or it's been a long time since I've used it, what kind of help is available to get me started?
What are the functions available in rexx?
I have one input file and some 40 tables, I want to read input file and compare the input file value with the table value if it is present then we have to update with new value, this should be repeated for all 40 tables and we are reading only one input file, for this is there any REXX program or job or routine to accomplish above requirement. components of the requirements; 1. One input file 2. 40 DB2 tables 3. we have to read from the input file and compare with table value, if present then update with new value (this should be recurssive for all 40 tables for every record of input file). 4. quick help is appreciated.
I want to code a REXX Program in order to load many tables in a database simultaneously in a batch fashion. Currently batch codes ar available in which only one job is submitted at a time and this loads only one table. My requirement is that many tables should be loaded at a time when one Job is submitted and can this be done using REXX Tool??? I want code snippet or the coding for this , please
how to access data held on the jes spool?
I want to open particular list of members inside pds.Let me know whether below code will work.if not tell me how it works INPUT='DDM.DATASET(AAA*)' X = OUTTRAP(MEMS.)
how long does the install of oorexx take?
When will a port of ooRexx to "XYZ" be available?
i want to code a rexx program in order to get the inputfile and output files of jcl. i want code snippet or the coding for this , please
How to find or access the current level of a gdg?