Connection Information

To perform the requested action, WordPress needs to access your web server. Please enter your FTP credentials to proceed. If you do not remember your credentials, you should contact your web host.

Connection Type

LowerCaseIdent – PB Docs 126 – PowerBuilder Library

LowerCaseIdent – PB Docs 126

LowerCaseIdent database parameter

Description

Specifies whether PowerBuilder displays identifier names in
lowercase.

Controls

DIR Sybase DirectConnect (applies only to DB2/MVS)

Syntax

Parameter

Description

value

Specifies whether you want PowerBuilder to
display identifier names in lowercase. Values are:

  • Yes

    Display identifier names in lowercase

  • No

    (Default) Do not display identifier names in lowercase

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.

note.png 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:


Document get from Powerbuilder help
Thank you for watching.
Was this article helpful?
Subscribe
Notify of
guest
0 Comments
Oldest
Newest Most Voted
Inline Feedbacks
View all comments
0
Would love your thoughts, please comment.x
()
x