DSXchange

1. Test 418 - IBM Information Platform Solutions Certification
2. Test 416 - WebSphere IIS QualityStage v7.5
3. Test 415 - IBM WebSphere IIS DataStage Enterprise Edition v7.5
4. Test 417 - IBM Certified Solution Developer - WebSphere Information Analyzer v8.0

Hi Ray,

Thanks for your support. I did exactly the way you told me and its working now.

I am a bit new to Datastage. Can you please eloborate a bit because i am not able to make out how you can call just the routine in a job.

I just want to execute the routines in parallel. What would be the design of my job to call these 6 routines in 6 different jobs.

Thanks for all the support.

The problem is that if RTN3 is looking for file "ABC" and it hasn't arrived then the sequence just waits for the RTN3 to complete but i want that all RTN1 to RTN6 should execute in parallel and if there are source files for all of them except RTN3 it should go ahead execute their individua...

I tried using a Sequencer with "ALL" option but its not working.........

Hi, I have sequence having following flow RTN1----------------------->Job1 RTN2----------------------->Job2 RTN3----------------------->Job3 RTN4----------------------->Job4 RTN5----------------------->Job5 RTN6----------------------->Job6 RTN1 to RTN6 are the routine activity which looks for the So...

MailArg<-1> = "To : " : VarToAddress MailArg<-1> = "From : " : VarFromAddress MailArg<-1> = "Subject : " : VarSubject MailArg<-1> = "Server : " : VarServer MailArg<-1> = "Body : " : VarMsgBody Code = DSSendMail(MailArg) This is how we have to paramet...

Hi I did the following activities to get this working after going through the various posts. !!!!!!!!Thanks a lot for all your Timely Support in resolving this problem well in time. When we use Routines in our Sequence and if we are triggering any further Activities then the Return Value of a succes...

Hi I have a sequence with the following flow. Routine1 ------>JobA----------->JobB---------->Routine2 Exception_Handler---------->Email------------>Terminator Routine 1 Returns a value which is something like 20070303#15:45#0 or 20070303#15:45#1. In the Trigger option of the routine i am saying that...

Hi, I have created a sequence with the following flow. Routine A------>Job A--------->Routine B------->Job B------->Job C--------> I want that if the Sequence Fails at Job A or Routine B it should start from Routine A. But if it fails at Job B or Job C it should start from the point of failure it se...

Thanks Ray, My problem is that if say there are 10,000 records in the source file with pipe as delimiter then if there is are few records where pipe is a part of value its causing the whole job to abort. and it becomes very difficult to identify those few culprit records. Isn't there a way to separa...

Hi, I have Server job with the following flow. Seq. File Stage --------------->Transformer---------------->Dataset Please let me know how can i capture the reject records from Seq. File Stage. In parallel job i can have a reject link coming out of Seq. File stage but since this is a server job its n...

There was problem with the directory path. The path was corrupted. Admin has re-started the box and its working now.

I am reading xml file data and writing it to the sequential file. The job design is External Source Stage-->XML Input Stage-->Sequential File. Source program path mentioned in External SOurce Stage is ls \\Svkcdisd01\Projects\EDW\Outputs\sample.xml-----and it is returning me one row in the output co...

nani0907 wrote:hi,

iam unable get 3 records for each key column.
Its showing only for some key values.
Please guide me.

Ensure that you have partitioned the data "only" on Column A in the Sort Stage and have kept the partitoning "Same" in the Head Stage.