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.

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  

---

What do unusual return codes such as -3 and 0196 mean?

2 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,

---

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

1 Answers  

---

how to access data held on the jes spool?

0 Answers   IBM,

---

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  

---

how to access data in control blocks such as jobname?

0 Answers   IBM,

---

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.)

0 Answers   Mind Tree,

---

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

0 Answers  

---

Suppose I want to code a rexx program in order to get the inputfile and output files of jcl. I want code snippet or the coding for this?

0 Answers  

---

for which platforms is uni-rexx available?

0 Answers   IBM,

---

I want to remove a duplicates form a given input field using rexx program. please Any one help me out to solve this ... Thanks in Advance.

1 Answers  

---