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

how to access data held on the jes spool?

0 Answers   IBM,

I want to open particular list of members inside pds.Let me know whether below code will work.if not tell me how it works INPUT='DDM.DATASET(AAA*)' X = OUTTRAP(MEMS.)

0 Answers   Mind Tree,

is there an aix version of oorexx?

0 Answers   IBM,

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 , please

1 Answers  

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.

0 Answers  

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

0 Answers  

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.

1 Answers  

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

0 Answers  

What are the functions available in rexx?

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 just know the Panvalet dataset name, i would like to search all the members of that dataset for particular keyword through Rexx. how to achive? please suggest. Is it possible to open panvalet member in browse mode using Rexx? Your help would be appreciated very much. Thanks in advance.

0 Answers  

What do unusual return codes such as -3 and 0196 mean?

2 Answers  

For more REXX Interview Questions Click Here
Categories