ShowWarnings
database parameter
Description
Specifies whether warning message text can be concatenated to
existing error messages.
Applies to
DIR SAP DirectConnect
Syntax
|
1 |
ShowWarnings=value |
|
Parameter |
Description |
|---|---|
|
value |
Specifies whether warning message text can be
|
Default value
ShowWarnings=0
Usage
The ShowWarnings parameter allows the DirectConnect interface to
use warning and error processing similar to that formerly available in
the InformationConnect DB2 Gateway (MDI) interface. For example, if a
single warning message appears on the DIR error queue, the default
behavior is to discard warnings. If ShowMessages is set,
sqlca.sqlcode=-1 and sqlca.sqlerrtext=”text_of_warning_message” are
returned to the application.
sqlca.sqlerrtext cannot exceed 254 characters. Consequently, if
multiple warning messages are returned together, message text might be
truncated.
For Access Service connections, must be issued before connecting
to ensure its correct operation.
Examples
To specify that you want to show warning messages as
errors:
-
Database profile
Select the Show Warning Messages as Errors check box on the
Syntax page in the Database Profile Setup dialog box. -
Application
Type the following in code:
1SQLCA.DBParm="ShowWarnings=1"