1. Categories >> Software >> MainFrame >> IBM MainFrame >> REXX
  2. Suggest New Category

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

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

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?

575

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

529

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

543

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?

545

what would I use uni-rexx for?

567




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

for which platforms is uni-rexx available?

576

I executed one job and I forget to save the final JCL. But took an XDC from SPOOL. Now I want to recover the JCL from XDC dataset. Is there any process to do this?. (Manually it takes a lot of time). Is there

2682

can oorexx run normal rexx programs?

588

can oorexx run ibm object rexx programs?

604

is oorexx compatible with rexx?

570

Can I cleanly uninstall oorexx?

583

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

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

595

how to access data held on the jes spool?

661