C|Text
Variable object EXEC
FREI|Freely selected
0
1
0
0
0
1024
0
0
0
0
SYSTEM.GLOBAL.LIST_REST_JOB_RESPONSE_VARIABLES.JOBS_SQL
&RESULTS#
C|Text
Variable object EXEC
FREI|Freely selected
0
1
0
0
0
1024
0
0
0
0
SYSTEM.GLOBAL.LIST_OBJVAR_ARRAY_VALUES.JOBS_SQL
&RESULTS#
Take the response from a REST job, and create a data sequence for use by an EXEC VARA
C|Text
Variable object EXEC
FREI|Freely selected
0
1
0
0
0
1024
0
0
0
0
SYSTEM.GLOBAL.GET_MAX_OBJVAR_ARRAY_LENGTH.JOBS_SQL
&RESULTS#
Version 1.4.0
1
UC4
|SQL.ORACLE|HOSTG
SQL
1
0
0
0
0
0
0
1
0
1
0
0
0
1
0
1
0
0
1
3906-735
;
0
1
0
50
1
SQL.ORACLE
0
0
0| |
1
1
0
0
2|Average
0
0
0
0
0
0
1
0
0
0
0
0
0
00:00
1
0
0
0
0
0
0
0
0
0
0
"NO"
: STOP MSG,51,"Required variables not defined."
:ENDIF
:SET &UC4_SYSTEM# = SUBSTR(&$SYSTEM#,5)
:SWITCH &UC4_SYSTEM#
:CASE "EXP"
: PSET &CLIENT# = "0001"
:CASE "EXP2"
: PSET &CLIENT# = "0001"
:CASE "DEV"
: PSET &CLIENT# = "0100"
:CASE "ITE"
: PSET &CLIENT# = "0110"
:CASE "PROD"
: PSET &CLIENT# = "0120"
:ENDSWITCH
:PUT_ATT CONNECTION="UC4.ORACLE_&UC4_SYSTEM#.CONN_SQL"]]>
N
]>
Step-level OIs:
Step1: Restart
Step2: Call on-call person
Step3: Open ticket
]]>
Version 1.4.0
1
UC4
|SQL.ORACLE|HOSTG
SQL
1
0
0
0
0
0
0
1
0
1
0
0
0
1
0
1
0
0
1
3906-735
;
0
1
0
50
1
SQL.ORACLE
0
0
0| |
1
1
0
0
2|Average
0
0
0
0
0
0
1
0
0
0
0
0
0
00:00
1
0
0
0
0
0
0
0
0
0
0
"NO"
: STOP MSG,51,"Required variables not defined."
:ENDIF
:SET &UC4_SYSTEM# = SUBSTR(&$SYSTEM#,5)
:SWITCH &UC4_SYSTEM#
:CASE "EXP"
: PSET &CLIENT# = "0001"
:CASE "EXP2"
: PSET &CLIENT# = "0001"
:CASE "DEV"
: PSET &CLIENT# = "0100"
:CASE "ITE"
: PSET &CLIENT# = "0110"
:CASE "PROD"
: PSET &CLIENT# = "0120"
:ENDSWITCH
:PUT_ATT CONNECTION="UC4.ORACLE_&UC4_SYSTEM#.CONN_SQL"]]>
N
]>
Step-level OIs:
Step1: Restart
Step2: Call on-call person
Step3: Open ticket
]]>
Version 1.4.0
1
UC4
|SQL.ORACLE|HOSTG
SQL
1
0
0
0
0
0
0
1
0
1
0
0
0
1
0
1
0
0
1
3906-735
;
0
1
0
50
1
SQL.ORACLE
0
0
0| |
1
1
0
0
2|Average
0
0
0
0
0
0
1
0
0
0
0
0
0
00:00
1
0
0
0
0
0
0
0
0
0
0
"NO"
: STOP MSG,51,"Required variables not defined."
:ENDIF
:SET &UC4_SYSTEM# = SUBSTR(&$SYSTEM#,5)
:SWITCH &UC4_SYSTEM#
:CASE "EXP"
: PSET &CLIENT# = "0001"
:CASE "EXP2"
: PSET &CLIENT# = "0001"
:CASE "DEV"
: PSET &CLIENT# = "0100"
:CASE "ITE"
: PSET &CLIENT# = "0110"
:CASE "PROD"
: PSET &CLIENT# = "0120"
:ENDSWITCH
:PUT_ATT CONNECTION="UC4.ORACLE_&UC4_SYSTEM#.CONN_SQL"]]>
N
]>
Step-level OIs:
Step1: Restart
Step2: Call on-call person
Step3: Open ticket
]]>
Common output handling JOBI for job post-process.
Set default variable values for common error handling JOBI a data for job post-process.
Take the output of a job, and create a data sequence for use by an EXEC VARA
Create a data sequence for the parent EXEC VARA with just a 'no results' message. (For use if the child job returns no results.)
Create a data sequence for the parent EXEC VARA with just an error message. (For use if the child job ends in error.)