SQL-JDBC - Process Steps
Execute SQL Scripts
Execute SQL scripts using JDBC driver.
| Name | Type | Description | Required |
|---|---|---|---|
| Autocommit | Boolean | Auto commit flag for database connection. | No |
| Connection String | String | The connection string used to connect to the database. Example: jdbc:mysql://dbhost:3306/mydb | Yes |
| Database JDBC Driver Name | String | The Fully Qualified JDBC driver Classname. | Yes |
| Driver Jar | String | The full path to the jdbc driver jar to use. | Yes |
| Encoding | String | The encoding of the files containing SQL statements. Leave blank to use the default JVM character encoding. | No |
| Error Handling | Enumeration: abort/continue/stop | Action to perform when statement fails: continue, stop, abort. | Yes |
| Exclude Files | String | Enter a new line separated set of file filters for the files to exclude from the execution. | No |
| Files | String | A white-space or comma separated list of sqlfiles to run. These will run in order as opposed to files grabbed using Include Files. This also takes precedence meaning if this is set Include File box will be ignored. | No |
| Include Files | String | Enter a new line separated set of file filters for the sql scripts to execute. | No |
| Password | Password | The password to be used to connect to the database. If youre using a password script, leave this field blank and fill out the Password Script field below. | No |
| Password Script | String | If you want to use a script or property lookups for your password, leave the Password field blank and enter it here. | No |
| Print Result Sets | Boolean | Print result sets from the statements. | No |
| SQL Statement Delimiter | String | String that separates SQL statements. | Yes |
| User | String | The user name used to connect to the database. | Yes |
Execute SQL Scripts with PassTicket Authentication
Execute SQL scripts using JDBC driver and PassTicket authentication.
| Name | Type | Description | Required |
|---|---|---|---|
| Autocommit | Boolean | Auto commit flag for database connection. | No |
| Connection String | String | The connection string used to connect to the database. Example: jdbc:mysql://dbhost:3306/mydb | Yes |
| Database JDBC Driver Name | String | The Fully Qualified JDBC driver Classname. | Yes |
| Driver Jar | String | The full path to the jdbc driver jar to use. | Yes |
| Encoding | String | The encoding of the files containing SQL statements. Leave blank to use the default JVM character encoding. | No |
| Error Handling | Enumeration: abort/continue/stop | Action to perform when statement fails: continue, stop, abort. | Yes |
| Exclude Files | String | Enter a new line separated set of file filters for the files to exclude from the execution. | No |
| Files | String | A white-space or comma separated list of sqlfiles to run. These will run in order as opposed to files grabbed using Include Files. This also takes precedence meaning if this is set Include File box will be ignored. | No |
| IRRRacf Native Library Path | String | Specify the path to the System Access Facility (SAF) native library, libIRRRacf.so. There is one library for 31-bit Java and one for 64-bit Java. You must point to the path of the appropriate library based on the version of Java you are running. The default value is /usr/lib. | Yes |
| IRRRacf.jar File | String | Specifies the path to the System Access Facility (SAF) JAR file, IRRRacf.jar. The default value is /usr/include/java_classes/IRRRacf.jar. | Yes |
| Include Files | String | Enter a new line separated set of file filters for the sql scripts to execute. | No |
| PassTicket Application ID | String | Subsystem ID of DB2 associated with PassTicket. | Yes |
| Print Result Sets | Boolean | Print result sets from the statements. | No |
| SQL Statement Delimiter | String | String that separates SQL statements. | Yes |
| User | String | The user name used to connect to the database. | Yes |