LowerCaseIdent database parameter
Description
Specifies whether PowerBuilder displays identifier names in
lowercase.
Controls
DIR Sybase DirectConnect (applies only to DB2/MVS)
Syntax
1 |
LowerCaseIdent='<span>value</span>' |
Parameter |
Description |
---|---|
value |
Specifies whether you want PowerBuilder to
|
Default
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.

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.DbParameter="LowerCaseIdent='Yes'"