Ansicht
Dokumentation

QWM1760 - Only SQL date literals allowed. ( OS/400 )

BAL Application Log Documentation   General Data in Customer Master  
This documentation is copyright by IBM.


Message : QWM1760
Only SQL date literals allowed.

Message Long Text :

Cause . . . . . : The date format of the query is &1 and the date format of the job is &2. The query contains global variables so Query Management interpreted the date literals using an SQL date format. This was done to avoid making a determination of whether to use the job date format or the date format associated with the query.
Recovery . . . : Change the job date format to &1 or create the query again so that the date format is &2. If the query is created again, ensure that any date literals in the query are in the format of the job.
Technical description . . . . . . . . : When a query contains global variables and the job date format is different than the date format associated with the query, date literals could be coded in the query in the date format associated with the query and date literals could be substituted in the global variables in the job date format. In this case Query Management interprets all date literals using an SQL date format to avoid choosing between the job date format and the query date format which could potentially cause unexpected results.

Message File : QCPFMSG
Library Message File : QSYS2924


General Data in Customer Master   Vendor Master (General Section)  
This documentation is copyright by IBM.

Length: 3215 Date: 20240420 Time: 143125     sap01-206 ( 3 ms )