Configure Database Connection Alias in Process Configuration Console(PCC) (DbExecute system step)
1. Log on to Workplace XT
2. Go to Tools --> Administration --> Open Process Configuration Console
3. Right Click on Isolated Region open properties
4. Open DbExecute Connections tab
5. Click on Add button
6. Enter Name and Select Database Type (DB2 or MS-SQL or ORACLE)
7. Enter remaining Database details (Database Name, Database Host, Database Port, Database User and Database Password)
8. Click on ok.
****Database Connection Alias created Successfully ****
10. Use the above db execute alias in DbExecute system function to run a stored procedure in a specified database.
1. Log on to Workplace XT
2. Go to Tools --> Administration --> Open Process Configuration Console
3. Right Click on Isolated Region open properties
4. Open DbExecute Connections tab
5. Click on Add button
6. Enter Name and Select Database Type (DB2 or MS-SQL or ORACLE)
7. Enter remaining Database details (Database Name, Database Host, Database Port, Database User and Database Password)
8. Click on ok.
****Database Connection Alias created Successfully ****
10. Use the above db execute alias in DbExecute system function to run a stored procedure in a specified database.
