EDB PostgreSQL xa_open string

Restriction: This topic applies only when the Enterprise Server feature is enabled.

Note: This is a technology preview feature only. It is being made available to allow you to test and provide feedback on this new capability; however, this feature is not intended for production use and it is not supported as such. Furthermore, Micro Focus does not guarantee that this feature will be delivered at a GA level and if it is, then the functionality provided might differ considerably from this technology preview.

To complete the definition of an EDB PostgreSQL XAR, add the following values in the Open string field:

DSN=odbc_dsn[,USRPASS=userid.password]
   [,LOCALTX={T|F}]
   [,ISOLEVEL={CR|RR|SS|SZ|UR}][,ESLOGGING=0001]

odbc_dsn: The ODBC Data Source Name used to connect to the data source as defined within the Windows ODBC Data Source Administrator utility.¹
userid: The user ID required to connect to the data source.¹
password: The password required to connect the user ID to the data source.¹
LOCALTX, ISOLEVEL, and ESLOGGING: See SQL xa_open string Configuration Options for details.

¹ Alternatively, you can specify the DSN, user ID, and password by manually coding them into the ESPGSQLXA.cbl source. This can be helpful if you want to ease security. To do this, search for CUSTOMIZE within ESPGSQLXA.cbl to see where to apply the required changes.