DSXchange

hi,

I would like to know what is the command I can use to "select/find" the jobs which are not in complied state inside a category, using the SQL command, I mean from the Datastage adminstrator.

Thanks in advance,
Vij

The status of each job is recorded in a separate table.

Therefore, at the innermost level, you need a separate query for each job.

Wrap that how you will, the bottom line is one query per job.