What is TimeStamp, What is TimeStamp error and What is the
Abend Code for TimeStamp Error ?
Answers were Sorted based on User's Feedback
Answer / nallapaneni bala
timestamp is to define the date and or time associated with
an treansaction
YYYY-MM-DD HH:MM:SS.NNNNNN WHERE NNNNNNN is in nanoseconds
timestamp error ==== -818
when ur trying to acess the plan first it will check the
timestamp of plan and time stamp of cobol load module if
both r not matched it results timestamp error.
| Is This Answer Correct ? | 8 Yes | 0 No |
Answer / venu
by usind time stamp all the cobol an db2 stmts are divided
separately and executed simultaniously.
when the load module and plan will not be created at the
same time then time stamp wil be occured.
-818 is the ts abend
| Is This Answer Correct ? | 5 Yes | 2 No |
Answer / nasar
NNNNNNN ----- is this nano seconds or micro seconds?
I think this is micro seconds. What do you say Bala?
| Is This Answer Correct ? | 0 Yes | 0 No |
Answer / mdvasanth86
Yes..
YYYY-MM-DD-HH:MM:SS:NNNNNN is the timestamp format.
In cobol it is generally defined as PIC X (26)
@Nasar ,
Yes it NNNNNN is microseconds.
-818 and -805 are both Timestamp mismatch related.
| Is This Answer Correct ? | 0 Yes | 0 No |
Explain how can the attributes of one sms dataset be copied to another dataset?
Say I have a file with 12 records. Each record has the name of the month. I have to append data in these 12 records into 1 record. How is it possible?
delete rules in db2
How do you restart a step in JCL?
I have two input files i/p1 name id-key flag date i/p 2 name id-key date if id-key matches in the both the files then it should write the output file from i/p1 with flag 'Y'. It should be done thru JCL sort card ,Please provide the info on this. ---Note : output file should have all records from i/p1 with proper Flag.
How to submit multiple jobs. These jobs are members in PDS. The second job should run if the first job runs successfully and so on.
CAN ANYONE TELL ME WHAT IS "JOB-CARD"
What is the purpose of disp parameter?
How are GDGs concatenated?
Could anyone please suggest me what is the maximum length of data that can be pass as input in //sysin dd * This was asked in interview. TIA
The disp in the JCL is MOD and the program opens the file in OUTPUT mode. What happens ? The DISP in the JCL is SHR and the program opens the file in EXTEND mode. What happens ?
How to view the hexa decimal value thru file aid if copy book is not present for that particular data