ShowWarnings database parameter
Description
Specifies whether warning message text can be concatenated
to existing error messages.
Controls
-
DIR Sybase DirectConnect
Syntax
|
1 |
ShowWarnings=<span>value</span> |
|
Parameter |
Description |
|---|---|
|
value |
Specifies whether warning message text
|
Default
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.DbParameter="ShowWarnings=1"