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.
Datastage project wise folder name
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 74
- Joined: Thu Jan 05, 2006 2:07 am
Datastage project wise folder name
Thanks,
Sourabh Verma
Sourabh Verma
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
-
- Participant
- Posts: 74
- Joined: Thu Jan 05, 2006 2:07 am