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
- 11944 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / marlo
I've done this before and here's part of my code!!! You do
the research!!!
ADDRESS TSO "SUBCOM DSNREXX"
IF RC <> 0 THEN
DO
X_RC = RXSUBCOM('ADD','DSNREXX','DSNREXX')
IF X_RC <> 0 THEN
DO
SAY 'PROBLEM LOADING '||SUBSYS' ENVIRONMENT'
EXIT 0
END
END
ADDRESS DSNREXX "CONNECT" SUBSYS
...
...
ADDRESS DSNREXX "EXECSQL DECLARE C1 CURSOR FOR S1"
ADDRESS DSNREXX "EXECSQL PREPARE S1 FROM :SQLSTMT"
ADDRESS DSNREXX "EXECSQL OPEN C1"
ADDRESS DSNREXX "EXECSQL FETCH C1 INTO :COUNT "
ADDRESS DSNREXX "EXECSQL CLOSE C1"
-marloL.
| Is This Answer Correct ? | 7 Yes | 0 No |
Answer / martin
sometimes it is wise to start with an options, like:
ADDRESS AS400REXX 'EXECSQL SET OPTION COMMIT = *NONE'
don't know the db2 syntax, though
| Is This Answer Correct ? | 0 Yes | 0 No |
Answer / guest
REXX doesn't have support to DB2. But still you can access
it thru some TSO CPs. One of the commercial CP is
REXXTOOLS/MVS. If your shop has that s/w installed you
could able to access DB2.
| Is This Answer Correct ? | 0 Yes | 12 No |
what is uni-rexx?
how to access data in control blocks such as jobname?
can I port my existing applications from the mainframe or os/2? Will there be extensive changes required to do this?
Is it possible to combine uni-rexx with a compiled language in any application? What applications interfaces are there?
How do I find or access the current level of a GDG?
What are the functions available in rexx?
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.
What are various loop types supported by rexx?
When will a port of ooRexx to "XYZ" be available?
What do unusual return codes such as -3 and 0196 mean?
can I redistribute oorexx freely with commercial software?
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
COBOL 
