Ansicht
Dokumentation

SQL0527 - ALWCPYDTA(*NO) specified but temporary result required for &1. ( OS/400 )

rdisp/max_wprun_time - Maximum work process run time   TXBHW - Original Tax Base Amount in Local Currency  
This documentation is copyright by IBM.


Message : SQL0527
ALWCPYDTA(*NO) specified but temporary result required for &1.

Message Long Text :

Cause . . . . . : The Allow Copy Data (ALWCPYDTA) parameter was specified on the precompiler command or the STRSQL command with a value of *NO. This value indicates that the queries should always use data directly retrieved from the database, so that the data always reflects the current values. Certain types of SQL queries can not be resolved without making a copy of the data. Examples would be queries using the keywords DISTINCT or UNION. The query being run is a query which requires a copy of the data.
Recovery . . . : Specify a different value for the ALWCPYDTA parameter or change the SQL statement so that it can be evaluated without using a temporary result.

Message File : QSQLMSG
Library Message File : QSYS2924


BAL_S_LOG - Application Log: Log header data   Fill RESBD Structure from EBP Component Structure  
This documentation is copyright by IBM.

Length: 3244 Date: 20240424 Time: 041814     sap01-206 ( 3 ms )