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 / 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



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

is there an aix version of oorexx?

566


How to code the db2 queries using rexx?

584


How to find or access the current level of a gdg?

489


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

2105


How to code the db2 queries using rexx, and also plz send some link and examples using db2 queries?

562






What is the difference between ooRexx and IBM's Object REXX for Windows?

543


what is uni-rexx?

595


What are the functions available in rexx?

531


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?

528


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?

552


When will a port of ooRexx to "XYZ" be available?

529


why is there no os/2 (ecs) port of oorexx?

589


how long does the install of oorexx take?

570


I want to set position for a particular text in a certain position in several of my cics maps.Please provide me with a solution. Ex: If "F1-Help" has to be set to pos(4,27) always in all the maps within a PDS.

1946


What is the use of uni-rexx?

549