Container name

subrat · Post by **subrat** » Tue Jul 01, 2008 1:41 am

Hi,

I want to retrive the conatiner name from a list of job name (if it is being used in the job)

Can i do it through DSGetJobInfo. If yes please do let me know how to proceeds..

Thanks
Subrat

ray.wurlod · Post by **ray.wurlod** » Tue Jul 01, 2008 5:46 am

Try it and let us know. You can not use DSJ.STAGELIST (which is only active stages) but DSJ.STAGELIST2 (passive stages) or DSJ.FULLSTAGELIST (all stages) might include container names.

subrat · Post by **subrat** » Tue Jul 01, 2008 8:17 am

Hi,

controllerList=DSGetStageInfo (JobHandle,<StageName>,DSJ.FULLSTAGELIST)

I am using the DSJ.FULLSTAGELIST above but not sure about the 2nd argument.

Can anyone focus some light on it.(i am looking for the container for each job)....

Thanks
Subrat

ray.wurlod wrote:Try it and let us know. You can not use DSJ.STAGELIST (which is only active stages) but DSJ.STAGELIST2 (passive stages) or DSJ.FULLSTAGELIST (all stages) might include container names. ...

chulett · Post by **chulett** » Tue Jul 01, 2008 8:25 am

DSJ.JOBFULLSTAGELIST is a DSGetJobInfo option. Note the 'JOB' prefix which you are missing. Check the online help for the syntax if you are unsure.

ray.wurlod · Post by **ray.wurlod** » Tue Jul 01, 2008 4:16 pm

My bad - I was replying from memory.

subrat · Post by **subrat** » Tue Jul 01, 2008 10:58 pm

Thanks Ray and Craig for your valuable suggestion..

I am getting the whole list of stages(including the container) through the DSJ.STAGELIST or DSJ.FULLSTAGELIST in comma delimited form.

Could you please suggest if i can retirve only the container name from this list. any orther alternative...

Below is how i am getting the result

Ctaar_Mdfy,DwhCtaAr_Cpy,pscHistoryProcess.Difference,pscHistoryProcess.InsertsAndUpdates,dwh__Peek,pscHistoryProcess.HP_Rejects

(pscHistoryProcess is my container here)...

Thanks
Subrat

ray.wurlod wrote:My bad - I was replying from memory.

chulett · Post by **chulett** » Tue Jul 01, 2008 11:44 pm

Looks to me like you can take that list and look for stage names with a 'dot' in them, the portion before the dot seems to be the Container name.

subrat · Post by **subrat** » Wed Jul 02, 2008 12:04 am

Thats correct Craig,

But not sure how to take only the word having end with '.'
(As that is my container)

chulett wrote:Looks to me like you can take that list and look for stage names with a 'dot' in them, the portion before the dot seems to be the Container name. ...

subrat · Post by **subrat** » Wed Jul 02, 2008 12:06 am

Thats correct Craig,

But not sure how to take only the word having end with '.'
I mean how to implement same in BASIC.
(As that is my container)

chulett wrote:Looks to me like you can take that list and look for stage names with a 'dot' in them, the portion before the dot seems to be the Container name. ...

ray.wurlod · Post by **ray.wurlod** » Wed Jul 02, 2008 1:04 am

Code: Select all

SELECT NAME AS CONTAINER_NAME
FROM DS_JOBOBJECTS
WHERE (OBJNAME LIKE 'C_' OR OBJNAME LIKE 'C__')
AND OBJIDNO IN (SELECT JOBNO FROM DS_JOBS WHERE NAME = '<<Job name>>');

subrat · Post by **subrat** » Wed Jul 02, 2008 1:55 am

Hi Ray,

Could you please paste the code once more as i am not a premier customer now(likely to be a soon). or you can email me... in
subrat.ksatpathy@gmail.com

Moreover it seems i need to pass jobname manually everytime in the query. As i have already list of job names can i do it in a better way instead of passing it manually.

Thanks
Subrat

ray.wurlod wrote:

Code: Select all

SELECT NAME AS CONTAINER_NAME
FROM DS_JOBOBJECTS
WHERE (OBJNAME LIKE 'C_' OR OBJNAME LIKE 'C__')
AND OBJIDNO IN (SELECT JOBNO FROM DS_JOBS WHERE NAME = '<<Job name>>'& ...[/quote]

aakashahuja · Post by **aakashahuja** » Wed Jul 02, 2008 2:17 am

you have a handfull of containers.. so just dont grep on the output. Use a pattern file with container names in them.

ray.wurlod · Post by **ray.wurlod** » Wed Jul 02, 2008 4:16 pm

subrat wrote:Could you please paste the code once more as i am not a premier customer now(likely to be a soon). or you can email me

Premium memberships is one of the ways that the hosting and bandwidth costs of DSXchange are funded. I am not prepared to create a precedent that might threaten the existence of this site.

subrat · Post by **subrat** » Wed Jul 02, 2008 11:01 pm

Hi Ray,

Could you please let me know the condition you used in the inline view after

SELECT JOBNO FROM DS_JOBS WHERE NAME = '<<Job name&g ...

Thanks
Subrat

ray.wurlod wrote:
subrat wrote:Could you please paste the code once more as i am not a premier customer now(likely to be a soon). or you can email me
Premium memberships is one of the ways that the hosting and bandwidth costs of DSXchange are funded. I am not prepared to create a precedent that might threaten the existence of this site.

subrat · Post by **subrat** » Wed Jul 02, 2008 11:32 pm

Hi Ray,

Could you please let me know the condition you used in the inline view after

SELECT JOBNO FROM DS_JOBS WHERE NAME = '<<Job name&g ...

Thanks
Subrat

ray.wurlod wrote:
subrat wrote:Could you please paste the code once more as i am not a premier customer now(likely to be a soon). or you can email me
Premium memberships is one of the ways that the hosting and bandwidth costs of DSXchange are funded. I am not prepared to create a precedent that might threaten the existence of this site.