dsjob: Return codes
Job Control Error codes.
Equ DSJS.RUNNING To 0 ;* This is the only status that means the job is actually running
Equ DSJS.RUNOK To 1 ;* Job finished a normal run with no warnings
Equ DSJS.RUNWARN To 2 ;* Job finished a normal run with warnings
Equ DSJS.RUNFAILED To 3 ;* Job finished a normal run with a fatal error
Equ DSJS.VALOK To 11 ;* Job finished a validation run with no warnings
Equ DSJS.VALWARN To 12 ;* Job finished a validation run with warnings
Equ DSJS.VALFAILED To 13 ;* Job failed a validation run
Equ DSJS.RESET To 21 ;* Job finished a reset run
Equ DSJS.CRASHED To 96 ;* Job has crashed
Equ DSJS.STOPPED To 97 ;* Job was stopped by operator ntervention (can't tell run type)
Equ DSJS.NOTRUNNABLE To 98 ;* Job has not been compiled
Equ DSJS.NOTRUNNING To 99 ;* Any other status
DataStage API error codes
0 DSJE_NOERROR No DataStage API error has occurred.
–1 DSJE_BADHANDLE Invalid JobHandle.
–2 DSJE_BADSTATE Job is not in the right state (compiled, not running).
–3 DSJE_BADPARAM ParamName is not a parameter name in the job.
–4 DSJE_BADVALUE Invalid MaxNumber value.
–5 DSJE_BADTYPE Information or event type was unrecognized.
–6 DSJE_WRONGJOB Job for this JobHandle was not started from a call to DSRunJob
by the current process.
–7 DSJE_BADSTAGE StageName does not refer to a known stage in the job.
–8 DSJE_NOTINSTAGE Internal server error.
–9 DSJE_BADLINK LinkName does not refer to a known link for the stage in question.
–10 DSJE_JOBLOCKED The job is locked by another process.
–11 DSJE_JOBDELETED The job has been deleted.
–12 DSJE_BADNAME Invalid project name.
–13 DSJE_BADTIME Invalid StartTime or EndTime value.
–14 DSJE_TIMEOUT The job appears not to have started after waiting for a reasonable length of time. (About 30 minutes.)
–15 DSJE_DECRYPTERR Failed to decrypt encrypted values.
–16 DSJE_NOACCESS Cannot get values, default values or design default values for any job
except the current job.
–99 DSJE_REPERROR General server error.
-100 DSJE_NOTADMINUSER User is not an administrator.
-101 DSJE_ISADMINFAILED Failed to determine whether user is an administrator.
-102 DSJE_READPROJPROPERTY Failed to read property.
-103 DSJE_WRITEPROJPROPERTY Property not supported.
-104 DSJE_BADPROPERTY Unknown property name.
-105 DSJE_PROPNOTSUPPORTED Unsupported property.
-106 DSJE_BADPROPVALUE Invalid value for this property.
-107 DSJE_OSHVISIBLEFLAG Failed to get value for OSHVisible.
-108 DSJE_BADENVVARNAME Invalid environment variable name.
-109 DSJE_BADENVVARTYPE Invalid environment variable type.
-110 DSJE_BADENVVARPROMPT No prompt supplied.
-111 DSJE_READENVVARDEFNS Failed to read environment variable definitions.
-112 DSJE_READENVVARVALUES Failed to read environment variable values.
-113 DSJE_WRITEENVVARDEFNS Failed to write environment variable definitions.
-114 DSJE_WRITEENVVARVALUES Failed to write environment variable values.
-115 DSJE_DUPENVVARNAME Environment variable being added already exists.
-116 DSJE_BADENVVAR Environment variable does not exist.
-117 DSJE_NOTUSERDEFINED Environment variable is not userdefined and therefore cannot be deleted.
-118 DSJE_BADBOOLEANVALUE Invalid value given for a Boolean environment variable.
-119 DSJE_BADNUMERICVALUE Invalid value given for an integer environment variable.
-120 DSJE_BADLISTVALUE Invalid value given for a list environment variable.
-121 DSJE_PXNOTINSTALLED Environment variable is specific to Enterprise Edition which is not installed.
-122 DSJE_ISPARALLELLICENCED Failed to determine if Enterprise Edition installed.
-123 DSJE_ENCODEFAILED Failed to encode an encrypted value.
-124 DSJE_DELPROJFAILED Failed to delete project definition.
-125 DSJE_DELPROJFILESFAILED Failed to delete project files.
-126 DSJE_LISTSCHEDULEFAILED Failed to get list of scheduled jobs for project.
-127 DSJE_CLEARSCHEDULEFAILED Failed to clear scheduled jobs for project.
-128 DSJE_BADPROJNAME Invalid project name supplied.
-129 DSJE_GETDEFAULTPATHFAILED Failed to determine default project directory.
-130 DSJE_BADPROJLOCATION Invalid pathname supplied.
-131 DSJE_INVALIDPROJECTLOCATION Invalid pathname supplied.
-132 DSJE_OPENFAILED Failed to open UV.ACCOUNT file.
-133 DSJE_READUFAILED Failed to lock project create lock record.
-134 DSJE_ADDPROJECTBLOCKED Another user is adding a project.
-135 DSJE_ADDPROJECTFAILED Failed to add project.
-136 DSJE_LICENSEPROJECTFAILED Failed to license project.
-137 DSJE_RELEASEFAILED Failed to release project create lock record.
-138 DSJE_DELETEPROJECTBLOCKED Project locked by another user.
-139 DSJE_NOTAPROJECT Failed to log to project.
-140 DSJE_ACCOUNTPATHFAILED Failed to get account path.
-141 DSJE_LOGTOFAILED Failed to log to UV account.
-201 DSJE_UNKNOWN_JOBNAME The supplied jobname cannot be found in the project.
–1001 DSJE_NOMORE All events matching the filter criteria have been returned.
–1002 DSJE_BADPROJECT ProjectName is not a known DataStage project.
–1003 DSJE_NO_DATASTAGE DataStage is not installed on the server system.
–1004 DSJE_OPENFAIL The attempt to open the job failed – perhaps it has not been compiled.
–1005 DSJE_NO_MEMORY Failed to allocate dynamic memory.
–1006 DSJE_SERVER_ERROR An unexpected or unknown error occurred in the DataStage server engine.
–1007 DSJE_NOT_AVAILABLE The requested information was not found.
–1008 DSJE_BAD_VERSION The DataStage server does not support this version of the
DataStage API.
–1009 DSJE_INCOMPATIBLE_SERVER The server version is incompatible with this
API Communication Layer Error Codes
Error
Number Description
39121 The DataStage server license has expired.
39134 The DataStage server user limit has been reached.
80011 Incorrect system name or invalid user name or password provided.
80019 Password has expired.
Job Control, Job handler error values.
******************************************************************************
* ERROR VALUES
******************************************************************************
Equ DSJE.NOERROR To 0 ;* not an error
Equ DSJE.BADHANDLE To -1 ;* Invalid JobHandle
Equ DSJE.BADSTATE To -2 ;* Job is not in the right state (compiled, not running)
Equ DSJE.BADPARAM To -3 ;* ParamName does not reference a known parameter of the job
Equ DSJE.BADVALUE To -4 ;* ParamValue/Limitvalue is not appropriate
Equ DSJE.BADTYPE To -5 ;* Token in LimitType/RunMode/InfoType not recognized
Equ DSJE.WRONGJOB To -6 ;* Job was not run from within the current job
Equ DSJE.BADSTAGE To -7 ;* StageName does not refer to a known stage in the job
Equ DSJE.NOTINSTAGE To -8 ;* StageName was DSJ.ME and the caller is not running within a stage
Equ DSJE.BADLINK To -9 ;* LinkName does not refer to a known link of the stage
Equ DSJE.JOBLOCKED To -10 ;* JobHandle refers to a job that is locked by another user
Equ DSJE.JOBDELETED To -11 ;* JobHandle refers to a job that has now been deleted
Equ DSJE.BADNAME To -12 ;* JobName badly formed
Equ DSJE.BADTIME To -13 ;* A TimeStamp parameter was badly formed
Equ DSJE.TIMEOUT To -14 ;* Given up waiting for something to happen
Equ DSJE.DECRYPTERR To -15 ;* Decryption of encrypted value failed
Equ DSJE.NOACCESS To -16 ;* Cannot get values, Default values or Design Default values
;* for any job except the current job (Job Handle == DSJ.ME)
Equ DSJE.NOTEMPLATE To -17 ;* Cannot find template file
Equ DSJE.BADTEMPLATE To -18 ;* Error encountered when processing template file
Equ DSJE.NOPARAM To -19 ;* Parameter name missing - field does not look like 'name:value'
Equ DSJE.NOFILEPATH To -20 ;* File path name not given
Equ DSJE.CMDERROR To -21 ;* Error when executing external command
Equ DSJE.BADVAR To -22 ;* Stage Variable name not recognised.
Equ DSJE.NONUNIQUEID To -23 ;* Id already exists for a job in this project.
Equ DSJE.INVALIDID To -24 ;* Invalid Job Id
Equ DSJE.REPERROR To -99 ;* general repository interface "other error"
Equ DSJS.RUNNING To 0 ;* This is the only status that means the job is actually running
Equ DSJS.RUNOK To 1 ;* Job finished a normal run with no warnings
Equ DSJS.RUNWARN To 2 ;* Job finished a normal run with warnings
Equ DSJS.RUNFAILED To 3 ;* Job finished a normal run with a fatal error
Equ DSJS.VALOK To 11 ;* Job finished a validation run with no warnings
Equ DSJS.VALWARN To 12 ;* Job finished a validation run with warnings
Equ DSJS.VALFAILED To 13 ;* Job failed a validation run
Equ DSJS.RESET To 21 ;* Job finished a reset run
Equ DSJS.CRASHED To 96 ;* Job has crashed
Equ DSJS.STOPPED To 97 ;* Job was stopped by operator ntervention (can't tell run type)
Equ DSJS.NOTRUNNABLE To 98 ;* Job has not been compiled
Equ DSJS.NOTRUNNING To 99 ;* Any other status
DataStage API error codes
0 DSJE_NOERROR No DataStage API error has occurred.
–1 DSJE_BADHANDLE Invalid JobHandle.
–2 DSJE_BADSTATE Job is not in the right state (compiled, not running).
–3 DSJE_BADPARAM ParamName is not a parameter name in the job.
–4 DSJE_BADVALUE Invalid MaxNumber value.
–5 DSJE_BADTYPE Information or event type was unrecognized.
–6 DSJE_WRONGJOB Job for this JobHandle was not started from a call to DSRunJob
by the current process.
–7 DSJE_BADSTAGE StageName does not refer to a known stage in the job.
–8 DSJE_NOTINSTAGE Internal server error.
–9 DSJE_BADLINK LinkName does not refer to a known link for the stage in question.
–10 DSJE_JOBLOCKED The job is locked by another process.
–11 DSJE_JOBDELETED The job has been deleted.
–12 DSJE_BADNAME Invalid project name.
–13 DSJE_BADTIME Invalid StartTime or EndTime value.
–14 DSJE_TIMEOUT The job appears not to have started after waiting for a reasonable length of time. (About 30 minutes.)
–15 DSJE_DECRYPTERR Failed to decrypt encrypted values.
–16 DSJE_NOACCESS Cannot get values, default values or design default values for any job
except the current job.
–99 DSJE_REPERROR General server error.
-100 DSJE_NOTADMINUSER User is not an administrator.
-101 DSJE_ISADMINFAILED Failed to determine whether user is an administrator.
-102 DSJE_READPROJPROPERTY Failed to read property.
-103 DSJE_WRITEPROJPROPERTY Property not supported.
-104 DSJE_BADPROPERTY Unknown property name.
-105 DSJE_PROPNOTSUPPORTED Unsupported property.
-106 DSJE_BADPROPVALUE Invalid value for this property.
-107 DSJE_OSHVISIBLEFLAG Failed to get value for OSHVisible.
-108 DSJE_BADENVVARNAME Invalid environment variable name.
-109 DSJE_BADENVVARTYPE Invalid environment variable type.
-110 DSJE_BADENVVARPROMPT No prompt supplied.
-111 DSJE_READENVVARDEFNS Failed to read environment variable definitions.
-112 DSJE_READENVVARVALUES Failed to read environment variable values.
-113 DSJE_WRITEENVVARDEFNS Failed to write environment variable definitions.
-114 DSJE_WRITEENVVARVALUES Failed to write environment variable values.
-115 DSJE_DUPENVVARNAME Environment variable being added already exists.
-116 DSJE_BADENVVAR Environment variable does not exist.
-117 DSJE_NOTUSERDEFINED Environment variable is not userdefined and therefore cannot be deleted.
-118 DSJE_BADBOOLEANVALUE Invalid value given for a Boolean environment variable.
-119 DSJE_BADNUMERICVALUE Invalid value given for an integer environment variable.
-120 DSJE_BADLISTVALUE Invalid value given for a list environment variable.
-121 DSJE_PXNOTINSTALLED Environment variable is specific to Enterprise Edition which is not installed.
-122 DSJE_ISPARALLELLICENCED Failed to determine if Enterprise Edition installed.
-123 DSJE_ENCODEFAILED Failed to encode an encrypted value.
-124 DSJE_DELPROJFAILED Failed to delete project definition.
-125 DSJE_DELPROJFILESFAILED Failed to delete project files.
-126 DSJE_LISTSCHEDULEFAILED Failed to get list of scheduled jobs for project.
-127 DSJE_CLEARSCHEDULEFAILED Failed to clear scheduled jobs for project.
-128 DSJE_BADPROJNAME Invalid project name supplied.
-129 DSJE_GETDEFAULTPATHFAILED Failed to determine default project directory.
-130 DSJE_BADPROJLOCATION Invalid pathname supplied.
-131 DSJE_INVALIDPROJECTLOCATION Invalid pathname supplied.
-132 DSJE_OPENFAILED Failed to open UV.ACCOUNT file.
-133 DSJE_READUFAILED Failed to lock project create lock record.
-134 DSJE_ADDPROJECTBLOCKED Another user is adding a project.
-135 DSJE_ADDPROJECTFAILED Failed to add project.
-136 DSJE_LICENSEPROJECTFAILED Failed to license project.
-137 DSJE_RELEASEFAILED Failed to release project create lock record.
-138 DSJE_DELETEPROJECTBLOCKED Project locked by another user.
-139 DSJE_NOTAPROJECT Failed to log to project.
-140 DSJE_ACCOUNTPATHFAILED Failed to get account path.
-141 DSJE_LOGTOFAILED Failed to log to UV account.
-201 DSJE_UNKNOWN_JOBNAME The supplied jobname cannot be found in the project.
–1001 DSJE_NOMORE All events matching the filter criteria have been returned.
–1002 DSJE_BADPROJECT ProjectName is not a known DataStage project.
–1003 DSJE_NO_DATASTAGE DataStage is not installed on the server system.
–1004 DSJE_OPENFAIL The attempt to open the job failed – perhaps it has not been compiled.
–1005 DSJE_NO_MEMORY Failed to allocate dynamic memory.
–1006 DSJE_SERVER_ERROR An unexpected or unknown error occurred in the DataStage server engine.
–1007 DSJE_NOT_AVAILABLE The requested information was not found.
–1008 DSJE_BAD_VERSION The DataStage server does not support this version of the
DataStage API.
–1009 DSJE_INCOMPATIBLE_SERVER The server version is incompatible with this
API Communication Layer Error Codes
Error
Number Description
39121 The DataStage server license has expired.
39134 The DataStage server user limit has been reached.
80011 Incorrect system name or invalid user name or password provided.
80019 Password has expired.
Job Control, Job handler error values.
******************************************************************************
* ERROR VALUES
******************************************************************************
Equ DSJE.NOERROR To 0 ;* not an error
Equ DSJE.BADHANDLE To -1 ;* Invalid JobHandle
Equ DSJE.BADSTATE To -2 ;* Job is not in the right state (compiled, not running)
Equ DSJE.BADPARAM To -3 ;* ParamName does not reference a known parameter of the job
Equ DSJE.BADVALUE To -4 ;* ParamValue/Limitvalue is not appropriate
Equ DSJE.BADTYPE To -5 ;* Token in LimitType/RunMode/InfoType not recognized
Equ DSJE.WRONGJOB To -6 ;* Job was not run from within the current job
Equ DSJE.BADSTAGE To -7 ;* StageName does not refer to a known stage in the job
Equ DSJE.NOTINSTAGE To -8 ;* StageName was DSJ.ME and the caller is not running within a stage
Equ DSJE.BADLINK To -9 ;* LinkName does not refer to a known link of the stage
Equ DSJE.JOBLOCKED To -10 ;* JobHandle refers to a job that is locked by another user
Equ DSJE.JOBDELETED To -11 ;* JobHandle refers to a job that has now been deleted
Equ DSJE.BADNAME To -12 ;* JobName badly formed
Equ DSJE.BADTIME To -13 ;* A TimeStamp parameter was badly formed
Equ DSJE.TIMEOUT To -14 ;* Given up waiting for something to happen
Equ DSJE.DECRYPTERR To -15 ;* Decryption of encrypted value failed
Equ DSJE.NOACCESS To -16 ;* Cannot get values, Default values or Design Default values
;* for any job except the current job (Job Handle == DSJ.ME)
Equ DSJE.NOTEMPLATE To -17 ;* Cannot find template file
Equ DSJE.BADTEMPLATE To -18 ;* Error encountered when processing template file
Equ DSJE.NOPARAM To -19 ;* Parameter name missing - field does not look like 'name:value'
Equ DSJE.NOFILEPATH To -20 ;* File path name not given
Equ DSJE.CMDERROR To -21 ;* Error when executing external command
Equ DSJE.BADVAR To -22 ;* Stage Variable name not recognised.
Equ DSJE.NONUNIQUEID To -23 ;* Id already exists for a job in this project.
Equ DSJE.INVALIDID To -24 ;* Invalid Job Id
Equ DSJE.REPERROR To -99 ;* general repository interface "other error"