LowerCaseIdent
database parameter
Description
Specifies whether PowerBuilder displays identifier names in
lowercase.
Applies to
DIR SAP DirectConnect (applies only to DB2/MVS)
Syntax
|
1 |
LowerCaseIdent='value' |
|
Parameter |
Description |
|---|---|
|
value |
Specifies whether you want PowerBuilder to display
|
Default value
LowerCaseIdent=’No’
Usage
PowerBuilder displays identifier names in uppercase (the way they
are stored in the database). The LowerCaseIdent parameter can be set
only if the DelimitIdentifier parameter is set to No, indicating that
PowerBuilder should not enclose table and column names in double quotes.
If you try to enclose a table and column names in double quotes with
identifier names in lowercase, the LowerCaseIdent parameter value is
reset to the default value, and you receive a warning message.
Migrating PBMDI and PBNET applications to PBDIR
If you are migrating an application that previously used the
InformationConnect DB2 Gateway or Net-Gateway for DB2 interface to the
DirectConnect for DB2/MVS database interface, you should set the
LowerCaseIdent parameter value to Yes. This enables you to continue to
use the Select painter to edit DataWindows.
Examples
To have PowerBuilder display identifier names in lowercase:
-
Database profile
Select the Display Identifiers In Lower Case check box on the
Syntax page in the Database Profile Setup dialog box. -
Application
Type the following in code:
1SQLCA.DBParm="LowerCaseIdent='Yes'"