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.

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

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.

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  

---

What are the various error conditions seen in rexx?

0 Answers  

---

can I port my existing applications from the mainframe or os/2? Will there be extensive changes required to do this?

0 Answers   IBM,

---

How to find or access the current level of a gdg?

0 Answers  

---

Can anyone provide me the source code for LOC(lines of code) counter written in REXX language which can run on IBM mainframe z/OS V1R4. The LOC counter should be able to count the comments,lines of code,blank lines in a COBOL program and JCL's

0 Answers   Wipro,

---

---

When will a port of ooRexx to "XYZ" be available?

0 Answers  

---

How to code the db2 queries using rexx, and also plz send some link and examples using db2 queries?

0 Answers  

---

How to code the db2 queries using 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???

1 Answers  

---

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 would I use uni-rexx for?

0 Answers   IBM,

---

Can I cleanly uninstall oorexx?

0 Answers   IBM,

---