How to code the db2 queries using rexx?


No Answer is Posted For this Question
Be the First to Post Answer

Post New Answer

More REXX Interview Questions

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

2 Answers   Syntel,


how to access data held on the jes spool?

0 Answers   IBM,


Can I cleanly uninstall oorexx?

0 Answers   IBM,


have you already used rexx - even for limited purposes? Do you need to maintain a high level of productivity during your transition to unix?

0 Answers   IBM,


What are various loop types supported by rexx?

0 Answers  






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

0 Answers  


How do I access data in control blocks such as jobname?

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  


Is it possible to port existing applications from the mainframe or os/2? Are there major changes required to do this?

0 Answers  


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

0 Answers  


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?

0 Answers  


I'm new to rexx. How to code rexx in jcl to read in a lpar cpu usage file and select 1. date, time 2. some system names 3. cpu usage for each system. The input file has hourly reporting. The output file (CSV)is for excel use. Run in batch mode. Output in FB.

1 Answers  


Categories