DSXchange

I have a Sequential file source and target server job. I am making one column in the target as Key column. But it is easily inserting any duplicate values there.

May I know what is the use of Key column in a sequential file stage?

But it is automaticalling adding by the job controller in a server job when I add any job using job controller of job properties.

Why it is so? I am using Datastage server edition.

Can anyone tell me whats the use of these two functions ? When I add a job to a job control, these two functions automatically adding and I doono wht is the use of it.

DSSetDisableProjectHandler(hJob1, @FALSE)
DSSetDisableJobHandler(hJob1, @FALSE)

In another way.

Can we attach an aborted job using DSAttachJob() ?

If it is not possible what is the alternative for that. I want to run the job from a controller job , no matter waht the status of this job

I have a Job JobA which is in aborted status. I am having a controller job JobB where I am trying to attach JobA to reset it and run using hJob1 = DSAttachJob("JobA", DSJ.ERRFATAL) But it is throwing me exception that the job is not in the run mode. Can anyonehelp whet need to be done? I w...

Sorry. I got answer for this problem. The code should be like this hJob1 = DSAttachJob("TestJob", DSJ.ERRFATAL) If NOT(hJob1) Then Call DSLogFatal("Job Attach Failed: TestJob", "JobControl") Abort End ErrCode = DSSetParam(hJob1, "inFile", inFile) ErrCode = DSS...

I have a job "JobA" which is calling from many sequncers. Its function is to update a log file. When multiple sequncers running at a time and by chance a run request for jobA is triggering by two sequncers at a time. What will happen? Whether the calling sequncer will get aborted? If that ...

In the above code I modified the IF condition like the following . But still it is not resetting. Any help? If Status = DSJS.RUNFAILED Or Status = DSJS.CRASHED Then Call DSLogInfo(Status,"Custom program calling":Status) Call DSDetachJob(hJob1) hJob1= DSAttachJob("TestJob", DSJ.ER...

I am having a controler job with the following code. If it abort it should reset the job but not working. hJob1 = DSAttachJob("TestJob", DSJ.ERRFATAL) If NOT(hJob1) Then Call DSLogFatal("Job Attach Failed: TestJob", "JobControl") Abort End ErrCode = DSSetParam(hJob1, &q...

I have a controller job where I call many jobs using the code. I am using a for loop in which I repeatedly calling a job and incase it abort , resetting it and running agian in the loop. My requirement is, after each itration of the loop it should wait for 30 seconds. Is there a sleep or any functio...

Can I pass job parameters as the parameter value in this function?

I got a problem in updating file by multiple sequncers. Enviorment ======== JobA open sequnetial FileA and hash in to HashA then using a transformer increment a field value then update FileA again. When I run jobA individually, there is no issue. Its running successfully. But this JobA is a common j...

I have fixed length seq file and it has a column of 10 character length. Its datatype is char.

incase the source data dont have 10 character legth input... will the target column will automatically paded with spaces

m done!

Thanks for the reply

I have a basic doubt.

Whenever I run a single datastage job, is the datstage process create a separate process for my job in the unix server?

Whenever I run a sequncer, whether the datastage create separate process for each job in that sequncer?