Versions Compared

Old Version 5

changes.mady.by.user eric revollo

Saved on

compared with

New Version Current

changes.mady.by.user Morgan Mackeson-Ellis

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

In addition to the specific variables in the previous tableslisted on the sections below, the following variables are available in all scripts:

Environment variableDescription
WSL_META_AUTHCFGAdditional user defined attributes as JSON, scripts can load attributes from this variable.
WSL_META_AUTHTKN_[1|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_DBIDThe Database ID property of the meta-repository connection.
WSL_META_DBThe name of the database for the meta-repository connection.
WSL_META_SCHEMAThe meta-repository schema name, with a trailing dot.


 
WSL_META_USERThe user id for the meta-repository connection.
WSL_META_PWDThe password for the meta-repository connection.
WSL_WORKDIR
  • Windows: The work directory defined in the Windows connection.
  • UNIX/Linux: The work directory defined in the UNIX/Linux or Hadoop connection.
WSL_SEQUENCEA 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_URLThe server URL for the scheduler connection.
WSL_SCH_RESTAPI_USERThe api user id for the scheduler connection.
WSL_SCH_RESTAPI_PWDThe password for the scheduler connection
WSL_JOB_KEYID of the Job which started the script, '0' for interactive execution.
WSL_JOB_NAMEName of the Job which started the script, 'Develop' for interactive execution.
WSL_TASK_KEYID for the Task within the Job, or Object ID for interactive execution.
WSL_TASK_NAMEName of the Task within the Job, or Object Name for interactive execution.

...

Environment variableDescription
WSL_LOAD_FULLNAMEThe fully-qualified load table name.
WSL_LOAD_TABLEThe unqualified load table name.
WSL_LOAD_SCHEMAThe schema for the load table.  
WSL_LOAD_DBThe name of the database for the load table.
WSL_TEMP_DB

The name of the staging database for the load (Teradata only). 

WSL_TGT_DBIDThe Database ID property of the load table's storage connection.
WSL_TGT_USERThe user id for the load table's storage connection.
WSL_TGT_PWDThe password for the load table's storage connection.
WSL_TGT_CONSTRINGThe ODBC connection string with RED tokens expanded.
WSL_TGT_AUTHCFGAdditional Profile authentication attributes (JSON format), from the associated Target Connection. Extract attributes by parsing the JSON, if required.
WSL_TGT_AUTHTKN_[1|2|3]

Additional Profile authentication token fields from the associated Target 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_PARAMnnnAny 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 will be created.

All load scripts from Database or ODBC connections

...