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)