Using the Preview tab to connect in a PowerBuilder
application
The Preview tab page in the Database Profile Setup dialog box
makes it easy to generate accurate PowerScript connection syntax in the
development environment for use in your PowerBuilder application
script.
As you complete the Database Profile Setup dialog box, the correct
PowerScript connection syntax for each selected option is generated on
the Preview tab. PowerBuilder assigns the corresponding DBParm parameter
or SQLCA 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 directly into your script.
To use the Preview tab to connect in a PowerBuilder
application:
-
In the Database Profile Setup dialog box for your connection,
supply values for basic options (on the Connection tab) and
additional DBParm parameters and SQLCA properties (on the other
tabbed pages) as required by your database interface.For information about connection parameters for your interface
and the values you should supply, click Help. -
Click Apply to save your settings without closing the Database
Profile Setup dialog box. -
Click the Preview tab.
The correct PowerScript connection syntax for each selected
option displays in the Database Connection Syntax box on the Preview
tab. -
Select one or more lines of text in the Database Connection
Syntax box and click Copy.PowerBuilder copies the selected text to the clipboard. You
can then paste this syntax into your script, modifying the default
Transaction object name (SQLCA) if necessary. -
Click OK.