Additional connection options

The tabbed pages in the Database Profile Setup – SAP Adaptive
Server Enterprise dialog box include additional options that you
can set if desired to fine-tune your database connection and take
advantage of DBMS-specific features that the SAP Adaptive Server
Enterprise interface supports. Each connection option corresponds
to a DBParm parameter or (for Isolation Level and AutoCommit Mode)
SQLCA property that can be set in a PowerBuilder application script
by copying its syntax from the Preview
tab (PowerBuilder only).

The following tables list the connection options on each tabbed
page and their corresponding DBParm parameter or SQLCA property.
Click the DBParm or SQLCA property for a complete description.

Connection
tab

Option	DBParm parameter or SQLCA property
Release (For ASE driver, must be set to 15)	Release
Isolation Level	Lock
AutoCommit Mode	AutoCommit
Commit on Disconnect	CommitOnDisconnect
Displays Runtime Dialog When Password Expires	PWDialog

Regional
Settings tab

Option	DBParm parameter or SQLCA property
Language	Language
Character Set	CharSet
Locale	Locale
UTF-8 Character Set Installed or Unicode Conversions Enabled in Server	UTF8

System
tab

Option	DBParm parameter or SQLCA property
Log Text and Image Updates	Log
Display System Stored Procedures	SystemProcs
PowerBuilder Catalog Table Owner	PBCatalogOwner
Table Criteria	TableCriteria
Show Temp Tables	ShowTempTables

Transaction
tab

Option	DBParm parameter or SQLCA property
Asynchronous	Async
Number of Seconds to Wait	DBGetTime
Static Bind	StaticBind
Disable Bind	DisableBind
Bind String parameters as Unichar type	UnicharBind
Retrieve Blocking Factor	Block (DirectConnect and Adaptive Server Enterprise)
Cursors Declared Updatable	CursorUpdate
Read Only Cursor Type	CursorType

Syntax
tab

Option	DBParm parameter or SQLCA property
Enclose Table and Column Names in Quotes	DelimitIdentifier
DateTime Datatype Allowed	DateTimeAllowed
Format Arguments in Scientific Notation	FormatArgsAsExp
Text Limit in SQL	DBTextLimit
Trim Trailing Spaces in CHAR data	TrimSpaces
Outer Join Syntax	OJSyntax

Network
tab

Option	DBParm parameter or SQLCA property
Application Name	AppName
Workstation Name	Host
Packet Size	PacketSize (ASE, DIR, SNC, SYC)
Maximum Client Library Connections	MaxConnect
Keep Connection Alive	KeepAlive
Encrypt Password	PWEncrypt
Allow Server Failover	SvrFailover

Security
tab

Option	DBParm parameter or SQLCA property
Security Mechanism	Sec_Mechanism
Server Principal Name	Sec_Server_Principal
Session Timeout	Sec_Sess_Timeout
Credential Timeout	Sec_Cred_Timeout
Mutual Authentication	Sec_Mutual_Auth
Network Based Authentication	Sec_Network_Auth
Use Delegated Credentials	Sec_Delegation
Enable Channel Binding	Sec_Channel_Bind
Keytab File	Sec_Keytab_File
Encrypt All Results	Sec_Confidential
Ensure Data Integrity	Sec_Data_Integrity
Verify Packet Origin	Sec_Data_Origin
Detect Replayed Commands	Sec_Replay_Detection
Detect Sequence Errors	Sec_Seq_Detection

Directory
Services tab

Option	DBParm parameter or SQLCA property
Provider	DS_Provider
DIT Base	DS_DitBase
Principal Name	DS_Principal
Password (Adaptive Server Enterprise 12.5 or higher)	DS_Password
Directory Search Time Limit	DS_TimeLimit
Enable Failover	DS_Failover
Use Caching	DS_Copy
Directory Alias Entries	DS_Alias

Document get from Powerbuilder help

Thank you for watching.

Powerbuilder Documentation 2017

August 20, 2023

Was this article helpful?