MsgTerse – PB Docs 2018

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’.

Applies to

JDB JDBC

ODBC

Syntax

Default value

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 Working with Data Pipelines in Users Guide.

Examples

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