DSXchange

Hi,

I have written a DS sub-routine to get the job wise Category/Folder name & writting into a sequential file. following is the query I am using for this purpose:

SELECT JOBNO FMT '5L', NAME FMT '100L' AS JNAME,CATEGORY FMT '100L', JOBTYPE FMT '5L' FROM DS_JOBS WHERE NAME NOT LIKE '\\%';

I tried to run this Routine in 2-3 different datastage project, The folder names are coming absolutley correct for all the jobs of a project except one job.

For one of the jobname the folder name & jobtype are coming as :

FolderName = "JOBTYPE".
JobType = JOBTYPEIND

whereas the jobname & job number values are fine.

Can anybody give an insight on this.

As a guess, the project may have some manner of corruption in it and be a candidate for a REBUILD.

What is the NAME of the aberrant job?

Thanks for the reply.
I ran the same sub-routine once again in the same project withou doing any changes and this time every thing was perfect, The jobnames which were having issues last time retrieved folder name correctly.


I am not sure what the issue is.