Share this page

# ksc_run_sql

This command runs a SQL query against the chosen environment. The result of the last row queried is returned in the `[SQL_OUTPUT]` token. The result of the entire query is placed in the `[AS.PKG_TRANSFER_PATH][PKGL.SEQ].txt` file in `<ITG_Home>`.

To run this special command, any execution steps in the Change Management workflow must have their source environments defined in the Workflow Step window.

`ksc_run_sql` parameters

Parameter | Default token | Description
--- | --- | ---
QUERY_STRING | [QUERY_STRING] | A SQL select statement
ENV_NAME | [ENV_NAME] | The name of the environment where data will be queried. The JDBC connection should be checked in the environment checker.
EXCEPTION_OPTION | [EXCEPTION_OPTION] | If no data is returned, determines if an exception should be thrown. The only available option is '-no_data_exception.'

Example using `ksc_run_sql`

`ksc_run_sql QUERY_STRING="select sysdate from sys.dual" ENV_ NAME="[SOURCE_ENV.ENVIRONMENT_NAME]"`

Note: The `ksc_run_sql` special command can be used to populate a validation. This is appropriate when the validation is validated by a Command with Delimited Output. In this case, the Data Delimiter should be set to “`#@#`”.

The following code is an example of `ksc_run_sql` in a validation.

    ksc_run_sql QUERY_STRING=”select id, name from some_table”
    ENV_NAME=”[SOURCE_ENV.ENVIRONMENT_NAME]”
    ksc_capture_output cat [AS.PKG_TRANSFER_PATH][PKGL.SEQ].txt

https://admhelp.microfocus.com PPM 8942
Tips to improve your search results... OpenText™ Project and Portfolio Management Help Center PPM Help 26.2-26.3 All View Local Help Center View Online Help Center Version: