About the Database Profile Setup dialog box – PB Docs 2019

Supply values for connection options supported by your database
interface

Each database interface has its own Database Profile Setup
dialog box that includes settings only for those connection parameters
supported by the interface. Similar parameters are grouped on the same
tab page. The Database Profile Setup dialog box for all interfaces
includes the Connection tab and Preview tab. Depending on the
requirements and features of your interface, one or more other tab
pages might also display.

Easily set additional connection parameters in the development
environment

You can specify additional connection parameters (database
parameters and transaction object properties) with easy-to-use check
boxes, drop-down lists, and text boxes. PowerBuilder generates the
proper syntax automatically when it saves your database profile in the
system registry.

Generate connection syntax for use in your PowerBuilder
application script

As you complete the Database Profile Setup dialog box in
PowerBuilder, the correct connection syntax for each selected option
is generated on the Preview tab. PowerBuilder assigns the
corresponding database parameter or transaction object property name
to each option and inserts quotation marks, commas, semicolons, and
other characters where needed. You can copy the syntax you want from
the Preview tab into your PowerBuilder script.