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
Answers were Sorted based on User's Feedback
Answer / jagdish
DSNREXX 'DISCONNECT'
insist of this wirte
ADDRESS DSNREXX 'DISCONNECT'
AND CHECK IT OUT
Is This Answer Correct ? | 2 Yes | 1 No |
Answer / jyotiprakash8
can any one send me website on which i can get REXX Book
with some Programing Example...
Thanks in advance
Jyoti Prakash
Is This Answer Correct ? | 0 Yes | 1 No |
What are various loop types supported by rexx?
How do I Run My Rexx Exec.?
what would I use uni-rexx for?
how to pass parms to ispf edit macro?
Enlist the features of rexx as a programming language.
can oorexx run normal rexx programs?
can I port my existing applications from the mainframe or os/2? Will there be extensive changes required to do this?
How do I find or access the current level of a GDG?
Is it possible to combine uni-rexx with a compiled language in any application? What applications interfaces are there?
I'm new to rexx. How to code rexx in jcl to read in a lpar cpu usage file and select 1. date, time 2. some system names 3. cpu usage for each system. The input file has hourly reporting. The output file (CSV)is for excel use. Run in batch mode. Output in FB.
Is it possible to port existing applications from the mainframe or os/2? Are there major changes required to do this?
How do I access data held on the JES spool?