The easiest way to specify DBParm parameters in a PowerBuilder application script is to copy the DBParm syntax from the Preview tab in the Database Profile Setup dialog box into your code, modifying the default Transaction object name (SQLCA) if necessary.
As you set parameters in the Database Profile Setup dialog box in the development environment, PowerBuilder generates the correct connection syntax on the Preview tab. Therefore, copying the syntax directly from the Preview tab ensures that you use the correct DBParm syntax in your code.
To copy DBParm syntax from the Preview tab into
your code:
On one or more tab pages in the Database Profile Setup dialog box for your connection, supply values for any parameters you want to set.
For instructions, see “Setting database parameters in the development environment”.
For information about the parameters for your interface and the values to supply, click Help.
Click Apply to save your changes to the current tab without closing the Database Profile Setup dialog box.
Click the Preview tab.
The correct DBParm syntax for each selected option displays in the Database Connection Syntax box.
Select one or more lines of text in the Database Connection Syntax box and click Copy.
PowerBuilder copies the selected text to the clipboard.
Click OK to close the Database Profile Setup dialog box.
Paste the selected text from the Preview tab into your code, modifying the default Transaction object name (SQLCA) if necessary.
