ALLBASE/SQL Message Manual (36216-90213)

2 ALLBASE/SQL Warning Messages

1 MESSAGE Output will be truncated. (DBWARN 1)

CAUSE The SELECT statement generated rows that are longer

than the size speciﬁed by the PAGEWIDTH option of the

SET command. The pagewidth may be set to a maximum

of 254 bytes.

ACTION Increase the pagewidth value using the ISQL SET

command.

2 MESSAGE File '!' already exists. Next SELECT will

overwrite. (DBWARN 2)

CAUSE You have speciﬁed a ﬁle name that already exists as the

output ﬁle for the results of a SELECT.

ACTION No action is necessary if you want to overwrite the

existing ﬁle. Specify another output ﬁle name using the

OUTPUT option of the ISQL SET command if you want

output to go to a different ﬁle.

3 MESSAGE Column name ! truncated to ! bytes. (DBWARN

CAUSE A column name speciﬁed in the ISQL INPUT command

was greater than 20 bytes. This probably occurred because

you did not leave a space between column names. If the

bytes which remained after the truncation formed an

existing column name, the command was executed for that

column.

ACTION Delete any rows that were incorrectly input. Issue the

INPUT command again, separating the column names

with spaces.

4 MESSAGE Parameter substitution caused overflow -

command truncated.

(DBWARN 4)

CAUSE Substitution of parameter values into the command

caused the command length to exceed 2048 bytes,

necessitating truncation.

ACTION Try to rewrite the command so that the command length

after parameter substitution will be no greater than 2048

bytes.