Reading AutoCommit and Lock values from an external text file – PB Docs 2017

To read AutoCommit and Lock values from an external text
file:

1. Open the application script in which you want to set
   connection properties.

2. Use the following PowerScript syntax to specify the
   ProfileString function with the SQLCA.Lock property:

   PowerBuilder

   SQLCA.Lock = ProfileString ( file, section, key, default )

   1	SQLCA.Lock = ProfileString ( file, section, key, default )

   The AutoCommit property is a boolean, so you need to convert
   the string returned by ProfileString to a boolean. For example,
   the following statements in a PowerBuilder script read the
   AutoCommit and Lock values from the [Database] section of the
   APP.INI file:

   PowerBuilder

   string ls_string ls_string=Upper(ProfileString("APP.INI", "Database", "Autocommit","")) if ls_string = "TRUE" then SQLCA.Autocommit = TRUE else SQLCA.Autocommit = FALSE end if SQLCA.Lock=ProfileString("APP.INI", "Database", "Lock","")

   1 2 3 4 5 6 7 8

   string ls_string ls_string=Upper(ProfileString("APP.INI", "Database", "Autocommit","")) if ls_string = "TRUE" then    SQLCA.Autocommit = TRUE else    SQLCA.Autocommit = FALSE end if SQLCA.Lock=ProfileString("APP.INI", "Database", "Lock","")

3. Compile the script to save your changes.