i-effect Manual

*JOB2-Constants

DIRECTORY

Constant Name

Description

*JOB2.DIRECTORY.INPUT.ARCHIVE

The directory in which input files are archived; variables are resolved

*JOB2.DIRECTORY.INPUT.ARCHIVERAW

The directory in which input files are archived; Contains the variables

*JOB2.DIRECTORY.INPUT.ERROR

The directory to which input files are moved when an error occurs; variables are resolved

*JOB2.DIRECTORY.INPUT.ERRORRAW

The directory to which input files are moved when an error occurs; Contains the variables

*JOB2.DIRECTORY.OUTPUT.ARCHIVE

The directory in which output files are archived; variables are resolved

*JOB2.DIRECTORY.OUTPUT.ARCHIVERAW

The directory in which output files are archived; Contains the variables

*JOB2.DIRECTORY.OUTPUT.ERROR

The directory to which output files are moved when an error occurs; variables are resolved

*JOB2.DIRECTORY.OUTPUT.ERRORRAW

The directory to which output files are moved when an error occurs; Contains the variables

INPUT (Input Files)

Constant Name

Description

*JOB2.INPUT.CURRENT.PROCESSID

Process ID of current input file

*JOB2.INPUT.CURRENT.ARCHIVE.FILEID

File ID of current input file in the archive

*JOB2.INPUT.CURRENT.ARCHIVE.FILEPATH

File path of current input file in the archive

*JOB2.INPUT.CURRENT.ARCHIVE.DIRECTORY

Directory of current input file in the archive

*JOB2.INPUT.CURRENT.ARCHIVE.FILENAME

Name of current input file in the archive

*JOB2.INPUT.CURRENT.ERROR.FILEID

File ID of current input file, if it has been moved to the error directory

*JOB2.INPUT.CURRENT.ERROR.FILEPATH

File path of current input file, if it has been moved to the error directory

*JOB2.INPUT.CURRENT.ERROR.DIRECTORY

Directory of current input file, if it has been moved to the error directory

*JOB2.INPUT.CURRENT.ERROR.FILENAME

Name of the current input file, if it has been moved to the error directory

*JOB2.INPUT.CURRENT.SOURCE.FILEID

Original file ID of current input file

*JOB2.INPUT.CURRENT.SOURCE.FILEPATH

Original file path of current input file

*JOB2.INPUT.CURRENT.SOURCE.DIRECTORY

Original directory of current input file

*JOB2.INPUT.CURRENT.SOURCE.FILENAME

Original name of the current input file

*JOB2.INPUT.CURRENT.TARGET.FILEID

File ID of current input file, after it has been copied or moved

*JOB2.INPUT.CURRENT.TARGET.FILEPATH

File path of current input file, after it has been copied or moved

*JOB2.INPUT.CURRENT.TARGET.DIRECTORY

Directory of current input file, after it has been copied or moved

*JOB2.INPUT.CURRENT.TARGET.FILENAME

Name of the current input file, after it has been copied or moved

OUTPUT (Output Files)

OUTPUT.LAST.* – File information (FILEPATH, DIRECTORY, FILENAME) is only available after writing the output file

FILEID and PROCESSID for output file - All positions (LAST, CURRENT, NEXT) available, because they are independent of existing file.

Constant Name

Description

*JOB2.OUTPUT.LAST.PROCESSID

Process ID of last output file

*JOB2.OUTPUT.LAST.ARCHIVE.FILEID

File ID of last output file in the archive

*JOB2.OUTPUT.LAST.ARCHIVE.FILEPATH

File path of last output file in the archive

*JOB2.OUTPUT.LAST.ARCHIVE.DIRECTORY

Directory of last output file in the archive

*JOB2.OUTPUT.LAST.ARCHIVE.FILENAME

File name of last output file in the archive

*JOB2.OUTPUT.LAST.ERROR.FILEID

File ID of last output file, if it has been moved to the error directory

*JOB2.OUTPUT.LAST.ERROR.FILEPATH

File path of last output file, if it has been moved to the error directory

*JOB2.OUTPUT.LAST.ERROR.DIRECTORY

Directory of last output file, if it has been moved to the error directory

*JOB2.OUTPUT.LAST.ERROR.FILENAME

File name of last output file, if it has been moved to the error directory

*JOB2.OUTPUT.LAST.SOURCE.FILEID

File ID of last output file, in temporary directory

*JOB2.OUTPUT.LAST.SOURCE.FILEPATH

File path of last output file, in temporary directory

*JOB2.OUTPUT.LAST.SOURCE.DIRECTORY

Directory of last output file, in temporary directory

*JOB2.OUTPUT.LAST.SOURCE.FILENAME

File name of last output file, in temporary directory

*JOB2.OUTPUT.LAST.TARGET.FILEID

File ID of last output file, after writing it to file system

*JOB2.OUTPUT.LAST.TARGET.FILEPATH

File path of last output file, after writing it to file system

*JOB2.OUTPUT.LAST.TARGET.DIRECTORY

Directory of last output file, after writing it to file system

*JOB2.OUTPUT.LAST.TARGET.FILENAME

File name of last output file, after writing it to file system

*JOB2.OUTPUT.CURRENT.PROCESSID

Process ID of current output file

*JOB2.OUTPUT.CURRENT.ARCHIVE.FILEID

File ID of current output file in the archive

*JOB2.OUTPUT.CURRENT.ERROR.FILEID

File ID of current output file, if it has been moved to the error directory

*JOB2.OUTPUT.CURRENT.SOURCE.FILEID

File ID of current output file, in temporary directory

*JOB2.OUTPUT.CURRENT.TARGET.FILEID

File ID of current output file, after writing it to file system

*JOB2.OUTPUT.NEXT.PROCESSID

Process ID of next output file

*JOB2.OUTPUT.NEXT.ARCHIVE.FILEID

File ID of next output file in the archive

*JOB2.OUTPUT.NEXT.ERROR.FILEID

File ID of next output file, if it has been moved to the error directory

*JOB2.OUTPUT.NEXT.SOURCE.FILEID

File ID of next output file, in temporary directory

*JOB2.OUTPUT.NEXT.TARGET.FILEID

File ID of next output file, after writing it to file system

Others (Remaining Variables)

Constant Name

Description

SESSIONNR

Current i-effect session number

SQLCODE

Retrieve SQL code from last sql task