ShowWarnings – PB Docs 126

ShowWarnings database parameter

Description

Specifies whether warning message text can be concatenated
to existing error messages.

Controls

  • DIR Sybase DirectConnect

Syntax

Parameter

Description

value

Specifies whether warning message text
can be concatenated to existing error messages. Values are:

  • 0

    (Default) Does not allow the concatenation of warning message
    text to existing error messages.

  • 1

    Allows the concatenation of warning message text to existing
    error messages.

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:


Document get from Powerbuilder help
Thank you for watching.
Was this article helpful?
Subscribe
Notify of
guest
0 Comments
Inline Feedbacks
View all comments
0
Would love your thoughts, please comment.x
()
x