Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

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

Answers were Sorted based on User's Feedback



I am tryin to select one records(SQL) using Rexx.Here is the code ADDRESS DSNREXX "EXECSQL ..

Answer / jagdish

DSNREXX 'DISCONNECT'

insist of this wirte
ADDRESS DSNREXX 'DISCONNECT'

AND CHECK IT OUT

Is This Answer Correct ?    2 Yes 1 No

I am tryin to select one records(SQL) using Rexx.Here is the code ADDRESS DSNREXX "EXECSQL ..

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

Post New Answer

More REXX Interview Questions

I am new to rexx db2 ,can anyone help me by expalinin how to code the db2 queries using rexx,and also plz send some link and examples using db2 queries.

3 Answers  

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

1 Answers  

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?

0 Answers  

for which platforms is uni-rexx available?

0 Answers   IBM,

What are the various error conditions seen in rexx?

0 Answers  

what is uni-rexx?

0 Answers   IBM,

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

0 Answers   IBM,

How do I pass parms to my ISPF Edit macro

2 Answers   Wipro,

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

0 Answers  

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

1 Answers  

i want new rexx tool which will perform jcl chk without submitting it

0 Answers  

is oorexx compatible with ibm object rexx?

0 Answers   IBM,

For more REXX Interview Questions Click Here
Categories