Please ensure Javascript is enabled for purposes of website accessibility
Powered by Zoomin Software. For more details please contactZoomin

PI Interface for Relational Database RDBMS via ODBC

Startup parameters tab for PI Interface for RDBMS

  • Last UpdatedAug 19, 2025
  • 2 minute read

File Locations

Field

Description

Interface Log File

Full path to the interface specific log file.

(/OUTPUT) Required

SQL Files Directory

Directory of the SQL statement files.

(/SQL) Optional

Global Variables Files

Full path to the global SQL variable file.

(/GLOBAL) Optional

DSN Settings

Field

Description

DSN

Data Source Name (/DSN) Required

Username

Username for access to RDBMS

(/User_ODBC) Required

Password

Password for access to RDBMS (/Pass_ODBC).

The password is encrypted and stored locally in the directory configured for interface log files.

Beginning with the interface version 3.24.2, the RDBMS passwords are no longer maintained in .PWD files. Instead, they get stored in the Windows Credential Manager and the content of the .PWD files obfuscated; that is, replaced with a string of asterisks.

Note: If, after restarting interface version 3.24.2 and higher the content of the .pwd files is not replaced with asterisks, make sure that the NT service account has write permission to these files.

(See the /OUTPUT keyword)

To enter a new password, click .

Successful - Status Range

Specify the range of digital states indicating success from the system digital state table.

Field

Description

Start Code

Enter the starting location in the system digital state table. (/SUCC1=#) Optional

End Code

Enter the ending location in the system digital state table (/SUCC2=#) Optional

Bad Input - Status Range

Specify the range of digital states indicating Bad Input from the system digital state table.

Field

Description

Start Code

Enter the starting location in the system digital state table. (/BAD1=#) Optional

End Code

Enter the ending location in the system digital state table (/BAD2=#) Optional

TitleResults for “How to create a CRG?”Also Available in