JOBTYPEIND is a "raw" identifier, empty for server jobs.
JOBTYPE is a virtual field that replaces "" with 0.
Try, for example,
Code: Select all
SELECT JOBTYPEIND,COUNT(*) FROM DS_JOBS GROUP BY JOBTYPEIND;Code: Select all
SELECT JOBTYPEIND,COUNT(*) FROM DS_JOBS GROUP BY JOBTYPEIND;Code: Select all
apux19::/appl/asudtstg/Ascential/DataStage/DSEngine> . ./dsenv
apux19:ASUPMDEV:/appl/asudtstg/Ascential/DataStage/DSEngine> bin/dsjob -server apux19 -lprojects