Page Comparison

User

FDSQLCL_INP_ORA_USER

No

The username that will be used to connect with. This input takes precedence over the target scoped FDORA_USERproperty. This input is required if the FDORA_USERproperty is not specified.

Password

FDSQLCL_INP_ORA_PASSWORD

No

The password for FDSQLCL_INP_ORA_PASSWORD. This input takes precedence over the target scoped FDORA_PASSWORDproperty. This input is required if the FDORA_PASSWORDproperty is not specified.

Script File

FDSQLCL_INP_FILE_PATH

Yes

Fully qualified or relative path to script file. If relative path is given, it will be assumed to be in the FD_ARTIFACTS_DIR.

User Profile (login.sql)

FDSQLCL_INP_LOGIN_SQL_FILE

No

User Profile (login.sql) is intended to allow users to specifically customize their session.

(see the Special Considerations section for examples)

Generate SQL Spool File

FDSQLCL_INP_GENERATE_SPOOL_FILE

No

Check to generate report (Spool file) of SQL statement executions.

Show DBMS Output

FDSQLCL_INP_SHOW_DBMS_OUT

No

Print DBMS output in the log.

Fix SQL Syntax

FDSQLCL_INP_FIX_SQL_SYNTAX

No

Check to fix common SQL syntax issues.

Ignore Compilation Warnings

FDSQLCL_INP_IGNORE_WARNING

No

If checked, SQL compilation warnings will be ignored. Otherwise, they will cause the execution to be marked as fail.