DSXchange

Use change capture stage and get the new, deleted , changed and copied ( same info) member and based on the change code do insert delete/update.

I hope you are using surrogate key generator 'using oracle sequence' for
a specific reason. But if you are simply insert into your target table, use <sequence name>.nextval in your insert statement.

I think it occurs due to field name mismatch. Go to the datastage manager. Go to tools---> dataset management.
open the dataset and click on show schema...
Copy the schema definition and search for FILE_CODE.
If it not there change the output column name in your transformer as FILE_CODE.

Hi, Its little bit confusing. What are you doing? Are you writing data into Oracle table from Dataset? If you writing data into oracle table and before that truncating the target table you need to synchronize your process, means truncate first and until and unless truncation finished no data will be...

If you using join stage then the procees will create the tsort file. First of all if you need all the column from your source then use read otherwise better to select the fields. Second your lookup table is very very small and the memory usage and performance of lookup stage doesn't depend on the so...

1. Open the prooerties tab of the seq file
2. Go to Input --> columns tab
3. You see the field # assigned for each field
4. Double click on the field # and set the null value


I hope it will resolve the issue.

Use AsDouble or AsFloat and divide by 100.0. C/C++ syntex.

samba wrote:search for 'double quotes' in dsxchange.

Thanks
samba

So your field separator is , (comma) and data contains " (quote).
Try this ....
Set field separator as ,
and quote as none in the properties tab.

vijayg wrote:

chulett wrote:What stage? The Execute Command stage in a Sequence job pops to mind as the easiest, but there are other ways. ...

Thanks for the reply. I am thinking of doing it from Transformer stage.

Vijay.

And you have to call it from Datastage Sequence.

The user-defined SQL is loading data from DS job only. It just uses a Oracle sequence in it to generate a sequence number. Hope we can use the ODBC stage only if we have an ODBC connection. But we do not have a ODBC connection to the Oracle database. But, I think we could try using DRS stage. DRS s...

Does Remove Duplicates use much scratch space? I would have thought when the data was already sorted it would only need a small amount of scratch space. The Sort stage wont remove the scratch files ... No. The sort using expected scratch space, but I need to know is there any way around in datastag...

Hi All, How do I release the scratch space used by datastage. For example I am using a remove duplicate stage to remove some duplicate row and for this I need to sort the input stream. When I am sorting the input stream, datastage use the scratch space for that ( 20 Million rows). But my requirement...

Hi trobinson,
I never faced this kind of problem and I can't reproduce ( simulate this error). It would be great if you post create script of this table, that might help us to look into details of this problem.

Thanks
Girija

No there is no bug in Join stage. What I think that you must have some duplicate key in the right table. Please check it and I hope you get the answer.