How to code the db2 queries using rexx?
No Answer is Posted For this Question
Be the First to Post Answer
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
how to access data held on the jes spool?
Can I cleanly uninstall oorexx?
have you already used rexx - even for limited purposes? Do you need to maintain a high level of productivity during your transition to unix?
What are various loop types supported by rexx?
Is it possible to combine uni-rexx with a compiled language in any application? What applications interfaces are there?
How do I access data in control blocks such as jobname?
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.
Is it possible to port existing applications from the mainframe or os/2? Are there major changes required to do this?
i want new rexx tool which will perform jcl chk without submitting it
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?
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.