MVSFORUMS.com

achittu

I need to get the timestamp in NON DB2 COBOL program?

I need to populate the output file with a field in this format : -- "YYYY-MM-DD-hh.mm.ss.nnnnnn" ... This format is DB2 format but our program is not DB2 program.. it is a normal batch COBOL program.

We have two types in COBOL - DATE and TIME but they dont give the exact TIMESTAMP like what is returned by DB2 ... Is there any way this can be achieved in COBOL program without using DB2 ?

Nic Clouston · Posted: Tue Nov 20, 2007 2:12 pm Post subject:

I do not know if TIME gives the full nnnnnn but if it does not then just use zeros. Otherwise it is a case of getting the values and formatting them as you require. I think there was a thread about this not so long ago - did you search?
_________________
Utility and Program control cards are NOT, repeat NOT, JCL.

Terry_Heinze · Posted: Tue Nov 20, 2007 5:56 pm Post subject:

I did this task years ago when my COBOL program needed to generate a DB2 timestamp as one of the fields of the file used to load a DB2 table. I used the date function provided by COBOL and generated a sequential number for the microseconds portion of the timestamp to insure no duplicate timestamps.
_________________
....Terry

nbdtrjk1 · Beginner Joined: 12 Apr 2007 Posts: 76 Topics: 41

using LE environment u can achieve your requirement

achittu · Posted: Wed Nov 21, 2007 12:26 pm Post subject:

I dont know what CEELOCT means ? Is this some in-built routine ?

Terry , I dont know if our clients would agree with generating sequence nos.

kolusu · Posted: Wed Nov 21, 2007 12:34 pm Post subject:

Terry_Heinze · Posted: Wed Nov 21, 2007 1:35 pm Post subject:

"...I dont know if our clients would agree with generating sequence nos."
The sequence numbers were generated for the microseconds portion ONLY of the timestamp to insure unique values. Using CEELOCT looks easier.
_________________
....Terry