Page History
...
In addition to the specific variables in the previous tables, the following variables are available in all scripts:
| Environment variable | Description |
|---|---|
WSL_META_AUTHCFG | Additional user defined attributes as JSON, scripts can load attributes from this variable. |
WSL_META_AUTHTKN_[1 |
Encrypted field “Token 1” can be replaced in connection strings by specifying the token: $AUTHTKN_1$. It is intended to contain tokens, passwords or secrets related to authentication.
WSL_META_AUTHTKN_2Encrypted field “Token 2” can be replaced in connection strings by specifying the token: $AUTHTKN_2$. It is intended to contain tokens, passwords or secrets related to authentication.
WSL_META_AUTHTKN_3|2|3] | Additional Profile authentication token fields from the associated Metadata Connection, normally used directly in connection strings with the token format $AUTHTKN_[1|2|3]$ but can be accessed in scripts via this variable. |
WSL_META_DBID | The Database ID property of the meta-repository connection. |
WSL_META_DB | The name of the database for the meta-repository connection. |
WSL_META_SCHEMA | The meta-repository schema name, with a trailing dot. |
WSL_META_USER | The user id for the meta-repository connection. |
WSL_META_PWD | The password for the meta-repository connection. |
WSL_WORKDIR |
|
WSL_SEQUENCE | A unique sequence number for the load or export task. |
WSL_PARAMnnn | Any parameters that start with the load table or export object name. Example: A table called load_abc has a parameter called load_abc_server defined. In this case, a variable called WSL_PARAM_SERVER (Windows) or PARAM_SERVER (UNIX/Linux) will be created. |
WSL_SCH_RESTAPI_URL | The server URL for the scheduler connection. |
WSL_SCH_RESTAPI_USER | The api user id for the scheduler connection. |
WSL_SCH_RESTAPI_PWD | The password for the scheduler connection |
WSL_JOB_KEY | ID of the Job which started the script, '0' for interactive execution. |
WSL_JOB_NAME | Name of the Job which started the script, 'Develop' for interactive execution. |
WSL_TASK_KEY | ID for the Task within the Job, or Object ID for interactive execution. |
WSL_TASK_NAME | Name of the Task within the Job, or Object Name for interactive execution. |
Additional environment variables for load scripts
...
| Environment variable | Description | |||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|
WSL_SRC_AUTHCFG | Additional user defined attributes as JSON, scripts can load attributes from this variable. | |||||||||||
WSL_SRC_DSN | The ODBC data source name (DSN) for the source connection. | |||||||||||
WSL_SRC_SERVER | The server for the source connection. | |||||||||||
WSL_SRC_DBPORT | The database port for the source connection. | |||||||||||
WSL_SRC_DBID | The Database ID property of the source connection. | |||||||||||
WSL_SRC_DB | The name of the database for the source connection. | |||||||||||
WSL_SRC_AUTHTKN_[1 | Encrypted field “Token 1” can be replaced in connection strings by specifying the token: $AUTHTKN_1$. It is intended to contain tokens, passwords or secrets related to authentication. | |||||||||||
WSL_SRC_AUTHTKN_2 | Encrypted field “Token 2” can be replaced in connection strings by specifying the token: $AUTHTKN_2$. It is intended to contain tokens, passwords or secrets related to authentication. | |||||||||||
|2|3] | Additional Profile authentication token fields from the associated Source Connection, normally used directly in connection strings with the token format $AUTHTKN_[1|2|3]$ but can be accessed in scripts via this variable | WSL_SRC_AUTHTKN_3 | Encrypted field “Token 3” can be replaced in connection strings by specifying the token: $AUTHTKN_3$. It is intended to contain tokens, passwords or secrets related to authentication. | |||||||||
WSL_SRC_SCHEMA | The Source Schema property of the load.
| |||||||||||
WSL_SRC_USER | The user id for the source connection. | |||||||||||
WSL_SRC_PWD | The password for the source connection. |
...