This pdf was also very useful:
Search found 5 matches
- Tue Feb 09, 2016 12:19 pm
- Forum: TSO, ISPF & REXX (Do you still do CLIST?!).
- Topic: DB2 queries using rexx.
- Replies: 4
- Views: 2387
- Tue Feb 09, 2016 12:16 pm
- Forum: TSO, ISPF & REXX (Do you still do CLIST?!).
- Topic: DB2 queries using rexx.
- Replies: 4
- Views: 2387
Re: DB2 queries using rexx.
Thanks Akatsukami. I have searched more and got this sample program which was very useful to me:
"SUBCOM DSNREXX"
IF RC=0 THEN
SAY 'DSNREXX IS AVAILABLE'
ELSE
DO
SAY 'DSNREXX IS NOT AVAILABLE'
SAY 'SUBCOM RC :' RC
END
IF RC THEN
DO
S_RC = RXSUBCOM('ADD','DSNREXX','DSNREXX ...
"SUBCOM DSNREXX"
IF RC=0 THEN
SAY 'DSNREXX IS AVAILABLE'
ELSE
DO
SAY 'DSNREXX IS NOT AVAILABLE'
SAY 'SUBCOM RC :' RC
END
IF RC THEN
DO
S_RC = RXSUBCOM('ADD','DSNREXX','DSNREXX ...
- Tue Feb 09, 2016 12:10 pm
- Forum: IBM DB2 and IMS DB/DC
- Topic: How to do SELECTIVE COMMIT in a COBOL DB2 program?
- Replies: 5
- Views: 3126
Re: How to do SELECTIVE COMMIT in a COBOL DB2 program?
For a financial calculation I need some input from the input file. Based the today's input the base rate in the table will be updated and now that rate should be taken for the final calculation. That is why I thought to have an intermediate commit for some tables which has got the base rate.
- Mon Jan 18, 2016 11:00 am
- Forum: IBM DB2 and IMS DB/DC
- Topic: How to do SELECTIVE COMMIT in a COBOL DB2 program?
- Replies: 5
- Views: 3126
How to do SELECTIVE COMMIT in a COBOL DB2 program?
Hi,
I have a COBOL DB2 program that updates many DB2 tables in it. However, I was thinking to COMMIT only some of the tables and not all. If I issue a COMMIT it'll update all the tables but I want to commit only a some DB2 tables. Is it possible to do such selective commit in a COBOL DB2 program ...
I have a COBOL DB2 program that updates many DB2 tables in it. However, I was thinking to COMMIT only some of the tables and not all. If I issue a COMMIT it'll update all the tables but I want to commit only a some DB2 tables. Is it possible to do such selective commit in a COBOL DB2 program ...
- Tue Dec 29, 2015 4:51 pm
- Forum: TSO, ISPF & REXX (Do you still do CLIST?!).
- Topic: DB2 queries using rexx.
- Replies: 4
- Views: 2387
DB2 queries using rexx.
HI,
Can we code DB2 queries using rexx? How can we do that? Can you please provide an example and or share some links to learn them.
Can we code DB2 queries using rexx? How can we do that? Can you please provide an example and or share some links to learn them.