MsgTerse – PB Docs 126

MsgTerse database parameter

Description

Specifies whether PowerBuilder should display terse error messages
for JDBC or ODBC drivers. A terse error message is one without the
SQLSTATE=nnnn prefix, where nnnn is
the number of the error message.

By default, PowerBuilder displays JDBC and ODBC error messages
with the SQLSTATE prefix. To display error messages without the
SQLSTATE prefix, set MsgTerse to 'Yes'.

Controls

  • JDB JDBC

  • ODBC

Syntax

Parameter

Description

value

Specifies whether PowerBuilder should display
error messages without the SQLSTATE prefix. Values are:

  • Yes

    Display error messages without the SQLSTATE
    prefix

  • No

    (Default) Display error messages with the
    SQLSTATE prefix

Default

MsgTerse=’No’

Usage

You can set the MsgTerse parameter to ‘Yes’ to
display shorter JDBC or ODBC error messages in PowerBuilder. This
might be useful if space on your screen is limited.

For example, suppose you are using the Data Pipeline in PowerBuilder to
pipe data to a SQL Anywhere
ODBC database, and errors occur while you are executing the pipeline.
If MsgTerse is set to ‘No’ (the default value),
pipeline errors display in an Error dialog box with the
SQLSTATE prefix (for example, SQLSTATE=23000).

If you specify MsgTerse=’Yes’ in
the database profile of the SQL Anywhere destination
database, the Data Pipeline displays terse ODBC error messages without the
SQLSTATE prefix.

For instructions on using the Data Pipeline,
see the PowerBuilder Users Guide.

Examples

To specify that PowerBuilder should display terse error
messages without the SQLSTATE prefix:

  • Database profile

    Select the Display Terse Error Messages check box on the System
    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