Ansicht
Dokumentation

SQL0183 - Result of date or timestamp expression not valid. ( OS/400 )

SQL0183 - Result of date or timestamp expression not valid. ( OS/400 )

RFUMSV00 - Advance Return for Tax on Sales/Purchases   SUBST_MERGE_LIST - merge external lists to one complete list with #if... logic for R3up  
This documentation is copyright by IBM.
SAP E-Book


Message : SQL0183
Result of date or timestamp expression not valid.

Message Long Text :

Cause . . . . . : The result of an arithmetic operation is a date or timestamp that is not within the valid range of dates which are between 0001-01-01 and 9999-12-31. If the result is a date in the format YMD, MDY, DMY, or JUL then the year must be between 1940 and 2039. If this is a FETCH, embedded SELECT, SET or VALUES INTO, then the relative position of the host variable in the INTO clause is &1 and the host variable name is &2.
Recovery . . . : Correct the arithmetic expression or the data that was being processed at the time the error occurred. If the date format is YMD, MDY, DMY or JUL and the result is not between 1940 and 2039, then specify USA, ISO, EUR, or JIS for the date format. The date format can be specified on the STRSQL or CRTSQLxxx commands or can be changed for the job by using the CHGJOB command. Try the request again.

Message File : QSQLMSG
Library Message File : QSYS2924


CL_GUI_FRONTEND_SERVICES - Frontend Services   Vendor Master (General Section)  
This documentation is copyright by IBM.

Length: 3231 Date: 20240329 Time: 004705     sap01-206 ( 3 ms )