DSXchange

For using User Defined SQL file you will have to provide its path. Also, whats the complexity of your SQL and how many lines of code is it?

Put a constriant that will Update the Target record only if the Flag is NULL or may be Flag <>'Y'.

Check for <0 for negative and >=0 for positive.

I dont think unless indexing your key col there is any way to improve your time taken here. As such Delete takes more time as it writes to a log and also the number of rows are not few here..

What happens if you change the configuration file. Try running on a single node and see what happens.

Did you set the same on the source side too. It shows import error. Whats the NullFieldvalue you set on the source side..can you set this to \1 and check what happens...

In the format tab of the Oracle Stage and under Field Defaults property and set the Null field value property to the default you want. You have to handle nullable fields.

thumsup9 wrote:select * from TABLE1
where timestampColumn > #PullDate#

and you can always pass the current date to your parameter.

parameter value should be currentdate-1

select * from TABLE1
where timestampColumn > #PullDate#

and you can always pass the current date to your parameter.

Kumar,

Your smileys hide the key information..

Yes I meant the same..HTH

Try this for char and varchar fields

If IsNull(Src.Col) then '' else Src.col Convert(char(000)," ",Src.Col))

You will find more on this in the forum. Your Parent table is missing some key vlaues and you may have to investigate why they are missing in there.

viewtopic.php?t=93704&highlight=parent+key+not+found

DB2 EE works on partitioned database, is the databse partitioned.Check with your DBA also.

Whats happens when you are connecting to DB2. Can you post the error message you are getting. You should have your DSN specified in
.odbc.ini file & ucodbc.config file.