...
Description | Returns the date after applying offsets. Optionally, can specify the output format.
|
|---|
Syntax | ${_formatDate(['date_time', 'format', day_offset, use_business_days, hour_offset, minute_offset, timezone])}
|
|---|
Parameters | |
|---|
Example | |
|---|
...
Description | Returns the date after applying offsets. Optionally, can specify the output format.
|
|---|
Syntax | ${_formatDateAdv(['date_time', 'format', year_offset, month_offset, day_offset, use_business_days, hour_offset, minute_offset, timezone])}
|
|---|
Parameters | |
|---|
Examples | |
|---|
...
Description | Returns the Nth non-business day of month for the month of the date specified. Optionally, can start from the end of the month.
|
|---|
Syntax | ${_nonBusinessDayOfMonth(index, ['date', 'format', reverse])}
|
|---|
Parameters | |
|---|
Examples | |
|---|
...
Description | Returns the Nth business day of month for the month of the date specified. Optionally, can start from the end of the month.
|
|---|
Syntax | ${_businessDayOfMonth(index, ['date', 'format', reverse])}
|
|---|
Parameters | |
|---|
Examples | |
|---|
...
Description | Returns the number of business days between date1 and date2. The start date is inclusive, but the end date is not.
|
|---|
Syntax | ${_businessDaysBetween('date1', 'date2')}
|
|---|
Parameters | |
|---|
Example | |
|---|
...
| Anchor |
|---|
| Task Instance Output Path |
|---|
| Task Instance Output Path |
|---|
|
Task Instance Output Path
Description | Returns a token representing the path to a temporary file containing the specified task instance output data. |
|---|
Syntax | ${_outputPath('outputType'[, 'fileExtension'])}
|
|---|
Parameters | outputType
Required; Type of output to create a temporary file for: STDOUT, STDERR, FILE, EXTENSION, JOBLOG, WEBSERVICE, SQL, STOREDPROC.fileExtension
Optional; The extension to use for the temporary file. Can be a maximum of 10 characters.- For SQL and STOREDPROC
outputType, the result set is translated to comma-separated values (csv), or tab-separated values (tsv), and, therefore, only csv (default) and tsv are supported file extensions. - For any other
outputType, the default file extension is txt.
|
|---|
Example | | Code Block |
|---|
| language | text |
|---|
| linenumbers | true |
|---|
| application.exe -file ${_outputPath('STDOUT')}
> application.exe -file $(ops_output_path_1638302212442528629FTPBE4AJQV2FT_stdout_txt) |
| Code Block |
|---|
| language | text |
|---|
| linenumbers | true |
|---|
| application.exe -file ${_outputPath('SQL')}
> application.exe -file $(ops_output_path_1639503212294078671DNPMULGSEVMHT_sql_csv) |
| Code Block |
|---|
| language | text |
|---|
| linenumbers | true |
|---|
| application.exe -file ${_outputPath('SQL', 'tsv')}
> application.exe -file $(ops_output_path_1639503212294078671DNPMULGSEVMHT_sql_tsv) |
| Code Block |
|---|
| language | text |
|---|
| linenumbers | true |
|---|
| application.exe -file ${_outputPath('EXTENSION', 'json')}
> application.exe -file $(ops_output_path_1639503212294187671OAI9SM79CNC2V_extension_json) |
|
|---|
| Anchor |
|---|
| Sibling Task Instance Output Path |
|---|
| Sibling Task Instance Output Path |
|---|
|
Sibling Task Instance Output PathDescription | Returns a token representing the path to a temporary file containing the specified sibling task instance output data. |
|---|
Syntax | ${_outputPathFromTask('outputType'[, 'fileExtension'])}
|
|---|
Parameters | outputType
Required; Type of output to create a temporary file for: STDOUT, STDERR, FILE, EXTENSION, JOBLOG, WEBSERVICE, SQL, STOREDPROC.fileExtension
Optional; The extension to use for the temporary file. Can be a maximum of 10 characters.- For SQL and STOREDPROC
outputType, the result set is translated to comma-separated values (csv), or tab-separated values (tsv), and, therefore, only csv (default) and tsv are supported file extensions. - For any other
outputType, the default file extension is txt.
|
|---|
Example | | Code Block |
|---|
| language | text |
|---|
| linenumbers | true |
|---|
| application.exe -file ${_outputPathFromTask('Sibling_Instance_Name', 'STDERR')}
> application.exe -file $(ops_output_path_1639503212294128671YL1B04U3OT55P_stderr_txt) |
| Code Block |
|---|
| language | text |
|---|
| linenumbers | true |
|---|
| application.exe -file ${_outputPathFromTask('Sibling_Instance_Name', 'STOREDPROC')}
> application.exe -file $(ops_output_path_1639503212294197671Q13UV8MSH6355_storedproc_csv) |
| Code Block |
|---|
| language | text |
|---|
| linenumbers | true |
|---|
| application.exe -file ${_outputPathFromTask('Sibling_Instance_Name', 'STOREDPROC', 'tsv')}
> application.exe -file $(ops_output_path_1639503212294197671Q13UV8MSH6355_storedproc_tsv) |
| Code Block |
|---|
| language | text |
|---|
| linenumbers | true |
|---|
| application.exe -file ${_outputPathFromTask('Sibling_Instance_Name', 'WEBSERVICE', 'json')}
> application.exe -file $(ops_output_path_1639503212294088671CAWMP3VNQ468B_webservice_json) |
|
|---|
| Anchor |
|---|
| Script Functions |
|---|
| Script Functions |
|---|
|
Script Functions
...