Ansicht
Dokumentation

SQL1506 - Key or attribute for &1 in &2 ignored. ( OS/400 )

SUBST_MERGE_LIST - merge external lists to one complete list with #if... logic for R3up   PERFORM Short Reference  
This documentation is copyright by IBM.


Message : SQL1506
Key or attribute for &1 in &2 ignored.

Message Long Text :

Cause . . . . . : One of the following attributes is ignored:
-- &1 is a keyed physical file, but the key is not a primary key, is not unique, or allows nulls. An SQL table is only keyed if it has a primary key. The SQL statement creates a table that is non-keyed.
-- &1 is a keyed logical file, but VIEW is specified for the object type. The SQL statement creates a view that is non-keyed.
-- The key has an attribute of ALTSEQ, DIGIT, FCFO, FIFO, LIFO, UNSIGNED, or ZONE. These attributes are ignored.
-- &1 has a sort sequence. The sort sequence is ignored.
Recovery . . . : If it is not acceptable for the table or view to be non-keyed or to ignore one or more attributes, do not use the generated SQL statement. SQL only supports non-keyed views, non-keyed or primary keyed tables, and does not support these attributes.

Message File : QSQLMSG
Library Message File : QSYS2924


Addresses (Business Address Services)   Fill RESBD Structure from EBP Component Structure  
This documentation is copyright by IBM.

Length: 3228 Date: 20240420 Time: 114642     sap01-206 ( 2 ms )