Warnings

Adaptive Server currently detects only one SQLSTATE warning condition, which is described in Table 6-1:

Table 6-1: SQLSTATE warnings

Message

Value

Description

Warning – null value eliminated in set function.

01003

Occurs when you use an aggregate function (avg, max, min, sum, or count) on an expression with a null value.

Warning–string data, right truncation

01004

Occurs when character, unichar, or binary data is truncated to 255 bytes. The data may be:

  • The result of a select statement in which the client does not support the WIDE TABLES property.

  • Parameters to an RPC on remote Adaptive Servers or Open Servers that do not support the WIDE TABLES property.