HomePowerBuilderAppeon Documentation Center

ShowWarnings

Description

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

Applies to

DIR SAP DirectConnect

Syntax

ShowWarnings=value

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 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:

    SQLCA.DBParm="ShowWarnings=1"
Prev  Up  Next
ShowTempTables  Home  SPCache