DSXchange

Hi, While compiling a job, i am getting below error on transformer stage:- ---------------------------------------- Compiling: Source = 'RT_BP843/JOB.1339953180.DT.1482146347.TRANS2', Object = 'RT_BP843.O/JOB.1339953180.DT.1482146347.TRANS2' **********************************************************...

Hi, I have a simple load job which loading into a WH table. But continuously i am getting error like "job abort because of time out or table deadlock". I have make sure that the array size and transaction size are correct in target table. But still job is failing... Any suggestion will gre...

Hi, I was going through the DS devloper guide. Here one thing mentioned like "As a rule of thumb, it is recommended that you create one processing node for every two CPUs in an SMP". How can i assure this by looking into configuration file? Moreover if fastname is the indicates the physica...

Hi,

Is number of nodes equals to number partition in DS. if both are same then how? Bit confused...

Thanks

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 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 i...

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 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 i...

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 in...

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. ...

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. ...

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...

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 Try it and let us know. You can not use DSJ.STAGEL...

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

Thanks Ray. Now it is working.... I have one more question.. I have some 1000 DS Jobs. I hav created a simple job where it will take these 1000 jobs in sequential file and in Transformaer of the job i have used the above routine to get the corresponding sequence which will be come in my output seque...

Thanks for the replay. I used the " controllerList=DSGetJobInfo(JobHandle,DSJ.DSJobController)" as well but getting the same output (-1/0 etcc...) Seeking ur suggestion STAGENAME will not retun the sequence name. if you can get the newest event id for and then this command ./dsjob -logdeta...

Hi, Requirement: To get Sequence name(output) corresponding to Job name(input) through below routine. $include DSINCLUDE JOBCONTROL.H JobName=Arg1 JobHandle = DSAttachJob ("JobName", DSJ.DSJ.ERRFATAL) controllerList=DSGetJobInfo(JobHandle, DSJ.STAGENAME) ErrCode=DSDetachJob(JobHandle) Ans=...