|
|
|
Connection flags (also referred to as SQL Option flags) are specified on the command line when invoking an Ingres operating system level command or user-written application that connects to a database. For details about other connection flags, see the description of the sql command in the Command Reference Guide and in the System Administrator Guide.
The ANSI standard specifies DBMS behavior when string truncation and numeric overflow occur. To specify handling of these conditions, use the connection flags described in the following sections.
|
|
|
The -string_truncation connection flag specifies how the DBMS handles attempts to write a character string to a table column that is too short to contain it (in an Insert, Update, Copy, or Create Table...as Select SQL statement). For details about this connection flag, see String Truncation Errors.
Specify -string_truncation=fail. If string truncation occurs, the statement that attempted to write the string fails and an error is returned.
Omit flag or specify -string_truncation=ignore. By default, the string is truncated to fit into the column, the statement succeeds, and no error is iss.
|
|
|
The -numeric_overflow connection flag specifies how the DBMS handles attempts to write numeric values that are outside the range of values supported by the data type of the receiving column (overflow and underflow).
The -numeric_overflow connection flag specifies behavior for integer, decimal, and floating point columns. For details about this connection flag, see Specifying Error Handling for Arithmetic Errors.
Specify -numeric_overflow=fail (or omit this flag). If numeric overflow or underflow occurs, the statement that attempted to write the value fails and an error is issued. (This is the Ingres default behavior.)