SQL/MX 2.x Reference Manual (G06.24+, H06.03+)

MXCI Commands

HP NonStop SQL/MX Reference Manual—523725-004

4-55

SET WARNINGS Command

The SET WARNINGS command is used to turn the display of warnings on or off during

an MXCI session. An MXCI session starts with the warnings on.

You can use SET WARNINGS only within an MXCI session.

Examples of SET WARNINGS

•

Suppose that T1 is a table containing one row. This example is executed with

warnings on—the MXCI default:

SET WARNINGS ON;

SELECT CAST('abcd' as CHAR(1)) FROM T1;

*** WARNING[8402] A string overflow occurred during the

evaluation of a character expression.

(EXPR)

------

--- 1 row(s) selected.

•

Suppose that table T1 exists as in the preceding example. This example is

executed with warnings off:

SET WARNINGS OFF;

SELECT CAST('abcd' as CHAR(1)) FROM T1;

(EXPR)

------

--- 1 row(s) selected.

SET WARNINGS {ON | OFF}