Ansicht
Dokumentation
SQL6047 - Column list not built because no tables available. ( OS/400 )
rdisp/max_wprun_time - Maximum work process run time Vendor Master (General Section)This documentation is copyright by IBM.
Message : SQL6047
Column list not built because no tables available.
Message Long Text :
Cause . . . . . : One of the following conditions has occurred:
-- Before a column list can be built, a table must have been selected from the table list. If a table has not been selected, the table list will be displayed first, so that the selection or selections can be made. There are two factors that affect the building of the table list. The first is the selections that were made on the list of collections. The second is the value that is in effect for the LISTTYPE parameter. There are currently no tables that are available for the collections that were chosen on the collection list that satisfy the values set by the LISTTYPE parameter. Since the table list cannot be built, it is not possible to select a table name to use as a basis for the building of the column list.
-- Authorization to either the table or tables or collection has changed.
-- Either the table or tables and collection or collections or the files or libraries is damaged.
-- More information may be available in other messages by pressing F10 (Display messages in job log) on this display.
Recovery . . . : Press F18 (Select columns) again. Before the column list is presented, a request to select a collection or collections from the list of collections will be displayed. The value that is in effect for the LISTTYPE parameter may be changed by using session services. Session services is available by pressing F13 (Services) on the Enter SQL Statements display.
Message File : QSQLMSG
Library Message File : QSYS2924
Addresses (Business Address Services) SUBST_MERGE_LIST - merge external lists to one complete list with #if... logic for R3up
This documentation is copyright by IBM.
Length: 3240 Date: 20240417 Time: 225543 sap01-206 ( 4 ms )