Ansicht
Dokumentation

SQL6043 - Column list not built because no collections available. ( OS/400 )

CPI1466 during Backup   rdisp/max_wprun_time - Maximum work process run time  
This documentation is copyright by IBM.


Message : SQL6043
Column list not built because no collections available.

Message Long Text :

Cause . . . . . : One of the following conditions has occurred:
-- Before a column list can be built, a collection must have been selected from the list of collections. If a collection has not been selected, the list of collections will be displayed first, so that selection or selections can be made. There are two factors that determine the list of collections that will be available to select from. The first is the value that is in effect for the collection option LIBOPT, that is used as the basis for building the list of collections. The second is the value that is in effect for the list type LISTTYPE option, that can further limit the list of collections. There are currently no collections that match the values specified by the current values of these two options. Since the collection list cannot be built, it is not possible to select a collection name to use as a basis for the building of the column list.
-- Authorization to the collection or collections has changed since the selections were made on the list of collections.
-- Damage has occurred to the collection or collections.
-- More information may be available in other messages by pressing F10 (Display messages in job log) on this display.
Recovery . . . : Change the values that are in effect for each of the two parameters that are used to build the collection list by using session services so that the collection or collections needed to work with will appear in the collection list. Session services is used by pressing the F13 (Services) key on the Enter SQL Statements display. After the values have been changed, press F18 (Select columns) again on the Enter SQL Statements display.

Message File : QSQLMSG
Library Message File : QSYS2924


General Data in Customer Master   ABAP Short Reference  
This documentation is copyright by IBM.

Length: 3245 Date: 20240420 Time: 142746     sap01-206 ( 2 ms )