Interested to Buy Any Domain ? << Click Here >> for more details...
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
- 2 Answers
- 11122 Views
- Syntel, I also Faced
- E-Mail Answers
Answer Posted / jagdish
DSNREXX 'DISCONNECT'
insist of this wirte
ADDRESS DSNREXX 'DISCONNECT'
AND CHECK IT OUT
| Is This Answer Correct ? | 2 Yes | 1 No |
Post New Answer View All Answers
Suppose 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?
I executed one job and I forget to save the final JCL. But took an XDC from SPOOL. Now I want to recover the JCL from XDC dataset. Is there any process to do this?. (Manually it takes a lot of time). Is there
can oorexx run ibm object rexx programs?
what if I need to have the same application running on multiple platforms, such as unix and the mainframe? Does that mean I have to maintain two separate sources?
is oorexx compatible with ibm object rexx?
Can I cleanly uninstall oorexx?
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?
how to pass parms to ispf edit macro?
i want new rexx tool which will perform jcl chk without submitting it
How to code the db2 queries using rexx, and also plz send some link and examples using db2 queries?
how long does the install of oorexx take?
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.
When will a port of ooRexx to "XYZ" be available?
have you already used rexx - even for limited purposes? Do you need to maintain a high level of productivity during your transition to unix?
