DSNREXX 'DISCONNECT' insist of this wirte ADDRESS DSNREXX &#

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

Question Posted / jagdish

2 Answers
11103 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

Please Help Members By Posting Answers For Below Questions

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

1032

how to access data in control blocks such as jobname?

909

does uni-rexx give me any capabilities designed specifically for the unix environment?

939

Is it possible to combine uni-rexx with a compiled language in any application? What applications interfaces are there?

874

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?

871

what is uni-rexx?

945

for which platforms is uni-rexx available?

928

is there an aix version of oorexx?

929

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?

917

can I port my existing applications from the mainframe or os/2? Will there be extensive changes required to do this?

932

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?

887

can I redistribute oorexx freely with commercial software?

995

Can I cleanly uninstall oorexx?

916

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

2588

What does the sample library of uni-rexx consist of?

1009