“Date, Time or Timestamp value is not valid (C G D F).”
Home > IT Answers > AS/400 > "Date, Time or Timestamp value is not valid (...
Svankipu
55 pts.
0
Q:
"Date, Time or Timestamp value is not valid (C G D F)."
AS/400 errors, AS/400 TimeStamp
How to Solve this problem. what could be the error?.
as far as i think the date is available in the database.
ASKED: Feb 27 2009  1:09 PM GMT
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _
RELATED QUESTIONS
0
Philpl1jb
24540 pts.
0
A:
 RATE THIS ANSWER
0
Click to Vote:
  •   0
  •  0
  • AddThis Social Bookmark Button
Hi,

This means that you have a Date, Time or Timestamp field which contains data that is not valid for the field type eg :-

25:61 for a time
20093232 or 00000000 for a date

I suggest you take option D to get a dump and check the data in your Date, Time or Timestamp fields. If the program is reading the data from a file, you may need to update the data to contain correct values. Maybe someone has mis-typed a date or time or forgotten to fill it in. Your application should really have stopped the invalid data being entered in the first place.

Regards,

Martin Gilbert.

///////////////////////////////

Hi Svankipu
Can you show us the code were the error occurs?
Phil
Last Answered: Feb 27 2009  2:09 PM GMT by Philpl1jb   24540 pts.
Latest Contributors: Gilly400   23625 pts.
  •   
0
0
RSS - Discussions Help
Discuss This Answer:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _



_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _

RPGILer   25 pts.  |   Apr 9 2009  5:12PM GMT

Hello!
Martin is correct in that your program should not allow an invalid date or timestamp to be entered in the first place but here is how I search for the data that is invalid:
Perform WRKACTJOB and enter 5 for the option on the workstation where the error is displayed. Enter 10 to display the job log then F10 and F18 to go to the bottom. You should see a function check message which tells what statement number in which program the error is occurring at. If you look at your compile listing of the program for that statement number it will tell you which file the program is currently in and what date has invalid data in it.
The press F12 twice and enter 14 for open files. Press F11 to see what record in the file from your compile listing your program is using.
Display the file, on the Control line enter the record number from the previous step and look for the invalid date. You may choose to do runqry *n filename then go to the record number and look for the invalid date.
In most cases you would have to cancel out of the program with the error in order to correct the invalid date or timestamp then take an R to retry, if appropriate.

 
0