SQL/MX 2.x Reference Manual (H06.04+)

MXCI Commands
HP NonStop SQL/MX Reference Manual—540440-003
4-55
SET WARNINGS Command
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)
------
a
--- 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)
------
a
--- 1 row(s) selected.
SET WARNINGS {ON | OFF}