Interested to Buy Any Domain ? << Click Here >> for more details...
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
- 11630 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 |
can I redistribute oorexx freely with commercial software?
Enlist the features of rexx as a programming language.
What are the functions available in rexx?
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.)
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
is there an aix version of oorexx?
How do I Run My Rexx Exec.?
for which platforms is uni-rexx available?
is oorexx compatible with rexx?
Can I combine uni-REXX with a compiled language in my application? What application programming interfaces are available? For example, can I share variables between uni-REXX and a compiled language?
How do I pass parms to my ISPF Edit macro
what would I use uni-rexx for?
COBOL 
