DSNT506I INPUT STATEMENT WAS NOT A FULL SELECT ON A SINGLE TABLE. LOAD STATEMENT WILL NEED MODIFICATION.
Explanation
The SELECT statement used to request a table unload
contained one of the following:
- A SELECT clause other than "SELECT * FROM"
- A FROM clause that does not contain exactly one table name
The table to be loaded is therefore not the same as the table from which the data is unloaded. DSNTIAUL is unable to determine the table name and all column names for the table to be loaded.
System action
DSNTIAUL generates a LOAD statement containing the string 'TBLNAME' for the table name. Some column names may be blank.
User response
Change the LOAD statement table name to the name of a table with the indicated column descriptions.
Severity
4 (warning)