DSXchange

I want to know if there is a documented procedure to stop a sequence of jobs which are running and have gone to a hung state. Most of the time even after we initiate a stop request it never stops. Sometimes it shows accessed by other user when we try to edit it. We have a 2-3 level of sequenced jobs...

I think i confused. Here is what i need. I have 2 separate sequence of jobs in a single project. One sequence is scheduled to run everyday and it sends mails to a group of people. The second sequence is scheduled to run once in a week and it has to send mails to a completely disjoint set of people f...

Hi ppl, I have two set of jobs in a project. Each of the set of jobs should send mails to two different set of ppl. Job Set 1 -> send mail to mail ids (abc@abc.com, def@def.com) Job Set 2 -> send mail to mail ids (ghi@ghi.com, jkl@jkl.com) Is it possible to modify and maintain two different template...

It was not 62 seconds. It was just 2 seconds after the Job control routine started. But the JCR aborted mentioning that the job didnt start. The invoked job started and got completed (Status = Ok) within 2 minutes.

I have experienced a similar problem. Batch::MasterJobControl..JobControl (fatal error from DSRunJob): Job control fatal error (-14) (DSRunJob) Job Batch::ETLJobControl appears not to have started after 60 secs But the ETLJobControl job started in the next 2 seconds, i am afraid why i get such a mes...

i have set some parameters in my datastage administrator as Userdefined environment variable. Do i need to have this again declared in my job's properties as a parameter or can i access it directly as #$varname#, where varname is the variable declared in the administrator. if i have to declare it as...

yes i have tried but only errors [:(]

Programmer Analyst,
Cognizant,
Chennai.

hi, the need is to use an UV stage to write a select clause that does a join of 5+ hash files and it also does a concatenation of some of the input fields when providing the output. as we all know oracle has a function called concat to get the purpose solved.but what is that i can do in UV for solvi...

I have used the keymgmtnextvalue routine to create a new server routine of my own. I have copied the code and altered it to take one more param that decides the starting number in the sequnce instead of 1 that he uses by default. iam getting the following error when i try to compile it Unable to wri...

ask a new question after you understand what the problem is

Programmer Analyst,
Cognizant,
Chennai.

sorry guys if my query was diverting, but my requirement is purely not a sequence generation. i already have an input sequential file and wanna add one more record to it with the new key being generated by adding 1 to the max key already available in the file.i cannot be more clearer than this. Prog...

My target is currently a sequential file only..but its enough too always i can load data from my seq. file to Hash or databases.

Also if u can explain me clearly abt the KeyMgmt routines..iam not much clear with their usage.

Programmer Analyst,
Cognizant,
Chennai.

I am dealing with files. I have an input sequential file that has data like 1,AAA 4,DDD 2,BBB 3,CCC and so on my requirement is to add a new incoming data like EEE into this file as 5,EEE that is i want to find the max of the input key (here number) and add 1 to it forming the new key and then appen...

Oracle 9i is my database 9.2

Programmer Analyst,
Cognizant,
Chennai.

Hi ppl, I am trying to use ORABULK stage in datastage 5.2 when i try to load my data which is of this format Colombian|101|7.99|175|175 French_Roast|49|8.99|150|150 Espresso|150|9.99|60|60 Colombian_Decaf|101|8.99|155|155 French_Roast_Decaf|49|9.99|90|90 the ORABULK stage creates a data file and con...