DSXchange

Are you able to view those records when you click "view data" in sequential file. What is the job design ?

Try using a join or lookup stage for joining instead of SQL.

Are those columns set as not nullable ? If yes then set them to nullable in seq file and transformer.

What is your job design ?
When you make it as nullable then edit the column and set the null field values = ''.

Try making the column nullable and if it's an integer then make it varchar ....if it suits your requirement..... later do the nullhandling.

Null handling for integer will be ---> if Isnull(col1) = 0 then 'Unknown'......

Are you doing a join ?

Posting the sql you are using will help us to help you.

Thanks for the response Mike actually time stamp field is not a part of key here.

what I am doing right now is extracting the update and insert into two different file and then the updating and inserting the table in two seperate job, which seems to be working good.

Hi, I have a requirement where I want to update the existing records to 'close' which has a status 'open' and I also want to add a new record for the same key with status 'open' and current timestamp. I am using oracle stage. So if there are 5 open records then I should have 10 records in the output...

This is a pivot requirement (rows to columns), search the forum for "Pivot".

Thanks to all for the valuable information.

I am still wondering about those empty files created for same dataset in the same dsn folder (example shown in my first post). If anyone can put some light on it.

Hi All, I am working on datasets and want to clarify some of my doubts, I am running a job that creates a dataset data.ds in my working folder and the data stored in dsn directories (0 -7), but what I see is that all the records (1200 rows) stored in just one dsn folder that is "dsn0" and ...

Is your new job activity in SEQ2 running? If you have added a job activity in SEQ1 and named it SEQ2 then when you run it obviously it will run the old jobs with your new job as per the sequence. If you just want to run your new jobs then you need to create a seperate sequence. if I understood you c...

If you are not using RCP, then check the columns from source dataset to target oracle table if any column is missing.

Did you try clearing the partition from Datasets ?

Make sure the columns you are comparing in CDC are same in both input links.

Just noticed that I don't have 'jre' in java directory for path "/appl/datastage/IBM/InformationServer/Server/DSEngine/java/jre/bin/sovvm/libjvm.a.
"