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'.
JDB JDBC
ODBC
MsgTerse='value'
Parameter |
Description |
|---|---|
value |
Specifies whether PowerBuilder should display error messages without the SQLSTATE prefix. Values are:
|
MsgTerse='No'
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.
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:
SQLCA.DBParm="MsgTerse='Yes'"
