DSXchange

Yes, you can call a parameter inside another. Just make sure both the calling & the called parameter are given values at environment level or job level.

Regards,
Divya

No. The problem still exists while Validating

But the confusing part is, the job RUNS fine if we skip VALIDATING part.

Regards,
Divya

You can use the substring or left function and fetch the first character of your date field. Then based on that, you can default the date to the required date. For eg: a. if your input date is '3/14/2005', then your substr or left function will give the reply as '3', then you can default the date wi...

Tried with a new transformer, but it didn't help

Regards,
Divya

Hi, A server job threw "Abnormal termination of stage transformer_name detected" error in Dev. We migrated this Server Job from Datastage V7.5.2 to new Datastage v8.5. Job design is DB2 stage(source) --> Transformer --> DB2 Stage(target) & DB2 Stage (rejects) It is a direct pass throug...

Thanks Mansoor.

Will check the options as per your advise.

Thanks,
Divya

To add on to the previous post, I have only two tabs in my notification stage. One is 'General' which accepts the general stage name and description. The other is the 'Notification' tab, where we can feed the following details: a. Server name b. Sender email c. Recepient email d. Subject e. Attachme...

Thanks for your inputs Mansoor !! The property "Add Checkpoints so sequence is restartable on failure" is not set in my sequence, but even then my sequence is restartable from the point it fails. So what is the difference between setting the property and not setting it ? Also, I didn't fin...

Hi, I have a sequence which in turn calls 3 other sequences. In each of these sequences, there are : a. 5 job activities which calls respective jobs b. Each job activity attached to a Email notification c. Each Email notification attached to a terminator The problem which I face is that, if a job of...

how can I view your reply without becoming a member

Ray,
I am not able to view your entire reply cause I am not a premium member

Regards,
Divya

Yes. The aborts in jobs are mostly cause of the resources, so it runs fine the next time. So I want to know the entire procedure (step-by-step) to a. Reset the job which gets aborted. b. Restart the sequence which got aborted cause of the job abort. I want the above two things to be done automatical...

I want to re-start the sequence from the point it stopped. Which means :
a. The job which aborted should be reset.
b. The sequence should be restarted.

Guess you got confused between restart and reset.

Regards,
Divya

I want to restart it automatically.

Till date, if the sequence aborts cause of a job abort, then I generally reset the job and the restart the sequence manually.

So just wanted to know how to automate it.

Regards,
Divya

Hi, I want to know how a sequence can be restarted if a job in the sequence aborts. And if the restart is done, what is the process/sequence in which datastage does it? I searched the forum regarding this, but not sure about the procedure to do it. Can anyone let me know the way to do it without usi...