How do we handle tables in CICS

lekshmi_ci · Posted: Tue Jun 12, 2007 9:57 am

How do we handle tables in CICS.
Is there any manuals available?

Devzee · Posted: Tue Jun 12, 2007 10:11 am

Which tables you are referring?
FCT
TCT
PCT
DCT
RCT

lekshmi_ci · Posted: Tue Jun 12, 2007 10:19 am

No...I just wanted to know the general commands used in a CICS DB2 program.

Devzee · Posted: Tue Jun 12, 2007 10:35 am

Still your question is not clear.

Are you asking what are the possible SQL statements used in CICS/DB2 program?

lekshmi_ci · Posted: Tue Jun 12, 2007 10:41 am

Yes, The possible SQl statements used iin a DB2 pgm.
Eg: To read a record from the table,write a record,update,delete.

prasadvrk · Posted: Tue Jun 12, 2007 10:46 am

Use the regular EXEC SQL END-EXEC blocks to code your SQL statements. DB2 code remain as that for a cobol program, the implementation part(CAF) is transparent to application programmer.

Devzee · Posted: Tue Jun 12, 2007 10:47 am

DECLARE CURSOR
OPEN CURSOR
CLOSE CURSOR
FETCH

SELECT
INSERT
DELETE
UPDATE

COMMIT
ROLLBACK

For syntax you can refer to manuals..

socker_dad · Posted: Tue Jun 12, 2007 9:10 pm

I highly recommend Murach's DB2 For the COBOL Programmer, Part 2. There is an excellent example of a CICS program used to access a DB2 table for Add, Change and Delete transactions.

www.murach.com

They also have a book called CICS for the COBOL Programmer and a CICS Desk Reference. They have saved my rear end on several occasions.