DSXchange

As Sreenivasulu told its not the variable, you should be using table or file for the purpose.

Datastage provides KeyMgtGetNextValue routine for the purpose. Which anyway uses a file for storing the next value.

Are you running the child sequences in parallel and by any chance more than 1 sequence is calling a same server job.

just a guess.

You would need something like timestamp column (or any other column as an indicator) within your tables which can relate the last entered data into your tables, so that on error in populating any of the table, you can delete the newly entered data using the indicator field, in the other two table.

Hi everyone, I have a job using IPC stage and getting this 'ds_ipcput() - timeout waiting for mutex'. I used default buffer size (128) and time out (10) previously and increased buffer size like 258 , 1000 and tested again. Tried to increased the waiting time as well. But still have this error. Not...

Moreover use intermediate Hashed File for the lookup.

One of the way that I am thinking is --- loading these source tables into source files and using merge stage to get one single file with all the column and map it to the target with hash lookup against the target table Or take any table A, B or C as a source table, The rest of the two tables would ...

We also found similar problem working with CLOB datatype. The workaround was using Longvarchar with a lesser size, in our case we chose 2000, the possible reason of the problem could be of memory (may be Array Size * Record Length )(Experts plz correct me if my assumption is wrong). Try it with Long...

Its not easy even with a single column, since you are not sure of the field boundaries.

Read a whole line as a single column, you can achieve this with having 000 as the quote character and 010 as the delimiter. Now process this single column according to the requirement. hi guru's i have a senerio where in the ", " delimeted seq file ,inside the column contains ","...

Instead of linkname.NOTFOUND(or NOT(linkname.NOTFOUND))
use
isNull with all the lookup keys to see if all are null then no match is found otherwise a match is found.

linkname.NOTFOUND manytimes doesn't work correctly with lookup stages other than Hashed File lookups.

Are you using transaction size as 0 for target (Oracle). Moreover you need not change Siebel, it's the problem with Oracle rollback segment. Solns: 1. Increase the rollback segment size. or 2. Experiment with transaction size other than 0 (but here you would need to be a bit careful since specifying...

Try resetting the job from director and see is there any log entry from previous run pointing to the problem?

I also had a similar requirement, check this post

viewtopic.php?t=96797

Hi suresh, If u want to remove double quote in the Transformer and pass the data,use Ereplace function in the Transformer. Ereplace (string, substring, replacement [ ,number [ ,begin] ] ) Regards kcs What you can do is read a single line of sequential file as one column in the transformer use Erepl...

I think this the link that anand is talking about

viewtopic.php?t=97239