Datastage project wise folder name

sourabhverma · Post by **sourabhverma** » Tue Jun 12, 2012 5:55 am

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.

chulett · Post by **chulett** » Tue Jun 12, 2012 6:49 am

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

ray.wurlod · Post by **ray.wurlod** » Tue Jun 12, 2012 4:31 pm

What is the NAME of the aberrant job?

sourabhverma · Post by **sourabhverma** » Tue Jun 12, 2012 10:11 pm

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.