MVSFORUMS.com

[mf_user]

Hi,

I got a CR with a requirement to write record to Error File whenever certain column of a DB2 table is empty. The program is COBOL-IMSDB-DB2 program. It first reads the record from GSAM file then does DB2 table look-up then apply updates. The Error File must be a GSAM file. So, I added the code to the program, changed corresponding PSB also, I put TYPE=GSAM and DBDNAME=Filename. Now, I would like to know about the checkpoint/restart logic on GSAM output files.

1). Do we apply checkpoint/restart logic only on input files?
2). Are the output GSAM files eligible to apply checkpoint/restart logic?
3). Does it make sense to apply checkpoint/restart logic on output GSAM files? Because, generally, in case of an abend, we would like to continue reading where we stopped through chkpt/rstrt logic........isn't it?
4). Is it true that the chkpt/rstrt logic can be applied on both input and output GSAM files?
5). What are the advantages if we apply chkpt/rstrt logic on an output GSAM files?
6). How do we go about chkpt/rstrt logic on a GSAM file that is opened in I-O mode for updates?

Please clear my doubts.

TIA.
_________________
MF
==
Any training that does not include the emotions, mind and body is incomplete; knowledge fades without feeling.
==

[kolusu]

mf_user,

Please search the forum for "gsam" and "checkpoint" in the forum.

Kolusu
_________________
Kolusu
www.linkedin.com/in/kolusu

[mf_user]

Ok Kolusu.............
_________________
MF
==
Any training that does not include the emotions, mind and body is incomplete; knowledge fades without feeling.
==