DSXchange

Parallel and Server jobs are two vastly different technologies incorporated into DataStage 6+. You are getting a lot of responses from Oliver watchers who are not fully aware of the difference. A Server job is a single threaded compiled BASIC program using the founding technology of the DataStage pr...

Lawrence If you backed up or restored while jobs were running or any activity in DataStage then this could be the cause of your problems. You are better off doing full exports. If someone is in the Designer while you export then this could be an issue as well but it will tell you about as it exports...

try this KeyMgtGetNextValue(the name you want) it is a unique sequence keys cheers >>> Babatunde.Ebohon@target.com Wednesday, June 18, 2003 16:57 >>> Can someone help me out on this. i want to assign surrogate keys ( unique sequence keys ) to my table. How do i go about this. Ds does not seem to hav...

Can someone help me out on this. i want to assign surrogate keys ( unique sequence keys ) to my table. How do i go about this. Ds does not seem to have a sequence generator within a parallel Job. Again, what is the difference btw a parallel job and a server job and in what scenerios can they be used...

Ettiene, What we did was to create a batch job with the following job control code in : For Counter = 1 to 8 *Setup Batch::??????? ??????????????? ??????????????? Sleep 3600 Next Counter We start the batch_job once a day and it will repeat the job thats being called within, every 3600sec / hour Hope...

Theres been discussion about this one before - try checking out the datastagexchange forum. In a nutshell, the approach we used is to have a control job which is scheduled to run once per day. Parameters are use to tell it how often to run the repeated job and when to stop doing it. -----Original Me...

Hi, I have been reading various mails about DataStage and SAS. I think the origional mail was how to read a SAS DataSet. >From my understanding (limited) the capability that Parallel Extender has with SAS is to allow some SAS executables to run in a parallel way. I am not sure, but I dont think that...

Hello !

I would like to run a DS job every hour
Im using DS 4 on Windows NT.

What way do you thing is the best one ?

Any advice would be appreciated.

Thanks a lot.

Etienne
Emersys

Weve got a situation where we have restored the Datastage folder which contains all the project information on our unix box, and now have a small number of jobs giving various "job corrupted" type errors. When we go into DS.Tools and clear the processes down we get a "blink numbers do not match" err...

Hi All I have a client that upgraded their DataStage server in windows with the active directory structure. This has to do with security. DataStage is suddenly behaving strange and we cant access the server with the clients. Is DataStage compatible with the active directory security protocols? Do I ...

This is a topic for an orphaned message.

Hi Rahim, there is also an other way to add parameters. (versions 5 and up) (1) Build a shared container from the whole job with the parameters (2) Insert the shared container in the target job (3) convert the shared container to local (4) deconstruct the local container (5) Delete (or keep if you n...

Hi Rahim, (1) Export the Job, where you want to copy the parameters from as for example JOB1.dsx (2) Export the Job, where you want to copy the parameters to as for example JOB2.dsx (3) Locate in JOB1.dsx the part after: Parameters "CParameters" (4) One complete Parameter looks for example like this...

Hi One of my paramaters in that stored proc is a IN OUT parameter. That makes me to declare a variable that I am passing to the stored proc. How can this be done in Datastage ?? -----Original Message----- From: Wilcy William [mailto:wilcy@rediffmail.com] Sent: Tuesday, June 17, 2003 11:10 PM To: dat...

This is a topic for an orphaned message.