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 |
Is it possible to port existing applications from the mainframe or os/2? Are there major changes required to do this?
I want to remove a duplicates form a given input field using rexx program. please Any one help me out to solve this ... Thanks in Advance.
can I redistribute oorexx freely with commercial software?
how to pass parms to ispf edit macro?
If there are a set of statements and each has a word "value" in it, If I want to display all these statements so that the word "value" is aligned, then how do I code this in REXX. e.g - The value of X is Y. Wot is its value? Do u know its value? I want to know its value.
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
does uni-rexx give me any capabilities designed specifically for the unix environment?
have you already used rexx - even for limited purposes? Do you need to maintain a high level of productivity during your transition to unix?
Suppose if there are a set of statements and each has a word “value” in it, if I want to display all these statements so that the word “value” is aligned, then how do I code this in rexx?
is oorexx compatible with ibm object rexx?
What are various loop types supported by rexx?
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?