“Date, Time or Timestamp value is not valid (C G D F).”

560 pts.
Tags:
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: February 27, 2009  1:09 PM
UPDATED: February 27, 2009  2:09 PM

Answer Wiki

Thanks. We'll let you know when a new response is added.

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

Discuss This Question: 1  Reply

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
  • RPGILer
    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.
    25 pointsBadges:
    report

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following