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.