DSXchange

Hi, I tried to use this modified code , to shift the pointer to new line and continue writing... but now the loop exits at encountering the EOF and does not go to WriteFile... OpenSeq "C:\FileTest\Test.txt" To MyFile Then Call DSLogInfo("MB Successfuly Opened File","FileTest...

Hi, I am trying to open, read and append to an existing sequentila file. Below is the code I am trying to use. OpenSeq "C:\FileTest\Test.txt" To MyFile Then Call DSLogInfo("MB Successfuly Opened File","FileTest") WriteSeq "First Line" to MyFile Then WeofSeq My...

Hi Raftsman,

Even I tried to implement the same logic.. but it did not workout by using the SQLSTATE at the constraint.

As a workaround, I fetched the keys for the table into a Hashed file and then in the job determined whether it is an Update ( i.e already existing ) or an Insert.

HTH,

Regards.

How many fields are there in the input ?

Hi,

Where may I find the size in bytes for the various data types of Datastage ?

Regards,
Asit

DSguru2B wrote:Wrong forum.
Search on "Unable to allocate memory".

Ooops, I am sorry...

Hi, In my Job, I am reading a flat file (containing 7 key flds + 4 flds), and writing into 4 Hashed file. Each hashed file will contain the 7 key flds and 1 out of 4 flds, hence 4 Hashed files. There will be approx 20 Million rows which will go into the Hashed file. The command fired to create the H...

We have checked the Logs..but nothing is coming related to Checkpoints. In job control also...i m not very clear what to see...or check...can u explain me what to Check in job control. Job Design : MasterSequence -> (Add Checkpoints - ON , Automatic Handle of Activity that fails - ON) Routine(Runnin...

I have 'Reset if Required then Run' Mode set for all the Jobs inside the Job Sequence.Although this mode is set for all the Jobs/Job Sequence in the Master Sequence.

Waiting for ur Reply!!!

Job Design : MasterSequence -> (Add Checkpoints - ON , Automatic Handle of Activity that fails - ON) Job1 (Reset if Required and then Run) StartLoop Activity (From = 1 To = 35) Job2 (Reset if Required and then Run) JobSequence1 (Add Checkpoints - ON , Automatic Handle of Activity that fails - ON) Jo...

Instead of using ranges of rows, use a small partitioning calculation, such as MOD, which will keep like values together on the same instance. For example, if you want all rows for a given "customer" to stay together on the same job instance, then pick a column that you can use in a const...

Are the different instances using the same keys? If so, your problem is obvious. Use different hashed files (note: it's not "hash file") or unique keys. ... Hi Ray, Am sorry for giving a poor, rather wrong example. Its like, The each occurence of input, say A1, will be given an incrementa...

Hi, In my job, I have a hashed file , which gets updated and referenced in the same job. I am running multiple instances of this job , with different set of input data, say 1st 1000 into 1st instance, next 1000 into 2nd instance and so on., like wise I am running just 4 insatnces. The hashed file co...

Don't send your Otherwise link through the Sequencer to Job2, that defeats the whole purpose of it. Send it to another Sequencer, that will 'dead end' the link and the Sequence job will stop. Remove the Sequencer from the Job2 link, you don't need it after that change. So what u mean to say is that...

Job1>>>RoutineActivity>> Two output links Link1(return value=1) to Job2 Link(Any) to EmailActivity or Whatever you want to do if routines return value is other than one. I dont want to do any activity if a value other than, say 1, is returned. it is like if return value = 1 the Job 1 else the seque...