Executes a SQL script. This operation takes the SQL script and processes each statement in the database using JDBC.
Please note that the statements in the SQL files must be delimited by a semi-colon. Also this operation does not support the execution of Oracle PL/SQL statements (See runPLSQLScript operation).
Environment/Instance Properties
Property Name | Required | Description |
---|---|---|
FDJDBC_URL | Yes | The JDBC URL of the database. |
FDJDBC_USER | No | The username that will be used to connect. |
FDJDBC_PASSWORD | No | The password for FDJDBC_USER. |
FDJDBC_DRIVER_PATH | Yes | Classpath for locating the JDBC Driver (e.g. for Weblogic - {ORACLE_HOME}/oracle_common/modules/ oracle.jdbc_11.2.0/ojdbc6.jar). |
Project Properties
Property Name | Required | Description |
---|---|---|
|
|
|
Inputs
Input Name | Required | Description |
---|---|---|
FDJDBC_INP_USER | No | The username that will be used to connect with. This input takes precedence over the environment instance scoped FDJDBC_USER property. This input is required if the FDJDBC_USER property is not specified. |
FDJDBC_INP_PASSWORD | No | The password for FDJDBC_INP_USER. This input takes precedence over the environment instance scoped FDJDBC_PASSWORD property. This input is required if the FDJDBC_PASSWORD property is not specified. |
FDJDBC_INP_FILE_NAME | Yes | The name of the script to execute. |
FDJDBC_INP_RUN_DESTRUCTIVE | No | This option allows destructive statements to be ran. See the note below. |
Outputs
Output Name | Required | Description |
---|---|---|
|
|
|
Artifacts
This operation consumes one or more SQL files, and an optional sequence file, from the artifacts repository.
...
Replacement Properties
See Appendix.