01UC01000001000010000| |11002|Average000000100000000:00100000000001CLIENT_QUEUE|<SQL>|HOSTSQL0100000100000101001;010501<SQL>000| |11002|Average000000100000000:0010000000000 " "
: PUT_ATT CONNECTION = &SQL_Connection#
:ELSE
: PUT_ATT LOGIN = &Login#
: PUT_ATT SERVER_NAME = &SQL_Server#
: PUT_ATT DATABASE_NAME = &SQL_Database#
:ENDIF
:PRINT "SQL Statement:"
:PRINT "--------------------------------------------------------------------------------"
:PRINT "&SQL_Query#"
:PRINT "--------------------------------------------------------------------------------"]]>NCreate a data sequence for the parent EXEC VARA with just a 'no results' message. (For use if the child job returns no results.)1UC4|<UNIX>|HOSTUNIX100000010100010100100000| |11002|Average000000100000000:0010000000000 " "
: PUT_ATT HOST = &Agent#
:ENDIF
:PUT_ATT LOGIN = &Login#
:PRINT "Command to run:"
:PRINT "--------------------------------------------------------------------------------"
:PRINT "&Command#"
:PRINT "--------------------------------------------------------------------------------"
! Pass parameters for PREP_PROCESS_REPORT to post-process tab.
:RSET &PPR_ReportType# = &PPR_ReportType#
:RSET &PPR_Filter# = &PPR_Filter#
:RSET &PPR_Def1# = &PPR_Def1#
:RSET &PPR_Def2# = &PPR_Def2#
:RSET &Output_Delimiter# = &Output_Delimiter#]]>NGeneral purpose EXEC VARA for running back-end jobs.Version 1.4.0EXECC|TextVariable object EXECFREI|Freely selected0100010240000UC4.GP_UNIX.JOBS&RESULTS#1UC4|<SQL>|HOSTSQL0100000101000101001;010501<SQL>000| |11002|Average000000100000000:0010000000000 " "
: PUT_ATT HOST = &Agent#
:ENDIF
:IF &SQL_Connection# <> " "
: PUT_ATT CONNECTION = &SQL_Connection#
:ELSE
: PUT_ATT LOGIN = &Login#
: PUT_ATT SERVER_NAME = &SQL_Server#
: PUT_ATT DATABASE_NAME = &SQL_Database#
:ENDIF
:PRINT "SQL Statement:"
:PRINT "--------------------------------------------------------------------------------"
:PRINT "&SQL_Query#"
:PRINT "--------------------------------------------------------------------------------"
! Pass parameters for PREP_PROCESS_REPORT to post-process tab.
:RSET &PPR_ReportType# = &PPR_ReportType#
:RSET &PPR_Filter# = &PPR_Filter#
:RSET &PPR_Def1# = &PPR_Def1#
:RSET &PPR_Def2# = &PPR_Def2#
:RSET &Output_Delimiter# = &Output_Delimiter#]]>N1UC01000001000010000| |11002|Average000000100000000:0010000000000Create a data sequence for the parent EXEC VARA with just an error message. (For use if the child job ends in error.)Take the output of a job, and create a data sequence for use by an EXEC VARAGeneral purpose EXEC VARA for running SQL jobs.Version 1.4.0EXECC|TextVariable object EXECFREI|Freely selected0100010240000UC4.GP_SQL.JOBS&RESULTS#General purpose EXEC VARA for running back-end jobs.Version 1.4.0EXECC|TextVariable object EXECFREI|Freely selected0100010240000UC4.GP_UNIX.JOBS&RESULTS#SQLI_SECC|TextFREI|Freely selected0100010240000select OH_HostAttrTypeDst
from OH
where OH_OType = ?
and OH_Name = ?U04002751 Attention: There is a variable-replacement restriction in case of security limits (SQLVAR_SECURITY_LEVEL)!Common error handling JOBI a data for job post-process.SQLI_SECC|TextFREI|Freely selected0100010240000select OH_HostAttrTypeDst
from OH
where OH_OType = ?
and OH_Name = ?U04002751 Attention: There is a variable-replacement restriction in case of security limits (SQLVAR_SECURITY_LEVEL)!General purpose EXEC VARA for running SQL jobs.Version 1.4.0EXECC|TextVariable object EXECFREI|Freely selected0100010240000UC4.GP_SQL.JOBS&RESULTS#