Controlling toleration of warnings in SPUFI

When you use SPUFI, you can specify the action that SPUFI is to take when a warning occurs.

About this task

To control the toleration of warnings, specify one of the following TOLWARN control statements:

--#SET TOLWARN NO: If a warning occurs when SPUFI executes an OPEN or FETCH for SELECT statement, SPUFI stops processing the SELECT statement. If SQLCODE +802 occurs when SPUFI executes a FETCH for a SELECT statement, SPUFI continues to process the SELECT statement.
--#SET TOLWARN YES: If a warning occurs when SPUFI executes an OPEN or FETCH for SELECT statement, SPUFI continues to process the SELECT statement.
--#SET TOLWARN QUIET: The same as YES, except that SPUFI suppresses all SQL warning messages from OPEN or FETCH if the SQLCODE is 0 or greater.

The following example activates and then deactivates toleration of SQL warnings:

SELECT * FROM MY.T1;
--#SET TOLWARN YES
SELECT * FROM YOUR.T1;
--#SET TOLWARN NO