MsgTerse
database parameter
Description
Specifies whether PowerBuilder should display terse error messages
for 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 ODBC error messages with the
SQLSTATE prefix. To display error messages without the SQLSTATE prefix,
set MsgTerse to ‘Yes’.
Applies to
ODBC
Syntax
|
1 |
MsgTerse='value' |
|
Parameter |
Description |
|---|---|
|
value |
Specifies whether PowerBuilder should display error
|
Default value
MsgTerse=’No’
Usage
You can set the MsgTerse parameter to ‘Yes’ to display shorter
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 the section called “Working with Data Pipelines” in 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:
1SQLCA.DBParm="MsgTerse='Yes'"