Search found 5 matches

by Om Shah
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

Re: DB2 queries using rexx.

This pdf was also very useful:
DB2 and the Joy of Rexx.pdf
by Om Shah
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 ...
by Om Shah
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.
by Om Shah
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 ...
by Om Shah
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.

Go to advanced search