Ansicht
Dokumentation

QMR0045 - Date formats of job and query are different. ( OS/400 )

BAL_S_LOG - Application Log: Log header data   rdisp/max_wprun_time - Maximum work process run time  
This documentation is copyright by IBM.


Message : QMR0045
Date formats of job and query are different.

Message Long Text :

Cause . . . . . : The query was saved with a date format that is different to the date format of your job. The date format of your job is &1. The date format of the query being changed is &2. This may cause unexpected results if there is a date value in a condition test of a WHERE clause. For example, if the column date format is YY/MM/DD and your job's date format is set to YY/DD/MM, the condition WHERE DATECOL = '91/06/12' would result in '12' being used to compare the month (MM) instead of the day (DD).
Recovery . . . : If there are no date condition tests, as described, then you can ignore this message. If these conditions are present, you can press F3 and exit from the editor without saving the query and change your job date format, or you can press F3 and save the query to change its date format to your job format.

Message File : QSQLMSG
Library Message File : QSYS2924


RFUMSV00 - Advance Return for Tax on Sales/Purchases   rdisp/max_wprun_time - Maximum work process run time  
This documentation is copyright by IBM.

Length: 3226 Date: 20240419 Time: 130524     sap01-206 ( 2 ms )