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
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
Can I combine uni-REXX with a compiled language in my application? What application programming interfaces are available? For example, can I share variables between uni-REXX and a compiled language?
is there an aix version of oorexx?
Enlist the features of rexx as a programming language.
have you already used rexx - even for limited purposes? Do you need to maintain a high level of productivity during your transition to unix?
What is the use of uni-rexx?
can I port my existing applications from the mainframe or os/2? Will there be extensive changes required to do this?
how to access data in control blocks such as jobname?
How to code the db2 queries using rexx, and also plz send some link and examples using db2 queries?
Can I cleanly uninstall oorexx?
what would I use uni-rexx for?
How to run my rexx exec?
for which platforms is uni-rexx available?
When will a port of ooRexx to "XYZ" be available?
how to access data held on the jes spool?
Can anyone provide me the source code for LOC(lines of code) counter written in REXX language which can run on IBM mainframe z/OS V1R4. The LOC counter should be able to count the comments,lines of code,blank lines in a COBOL program and JCL's