DSXchange

asorrell wrote:You are encountering a "known issue" - reject links won't work correctly unless the array size is set to 1.

Andy, isn't that strictly a Server issue? I don't see anything like the OCI 'Array Size' option in the OE stage doing Write Method=Upsert. What am I missing?

Because (I assume) the slashes are invalid characters after the quotes are stripped, which DataStage is wont to do. Perhaps? select cast (count(1) as number(15)) as count,cast (sum(TRANSACTIONAMT) as number(21,2)) as amount, '' 1 '' as flag from TST Note those are two single quotes, not double quotes.

It's not that simple. Try an exact search for "Unable to use a record for update" and see if any of the other posts help.

Interesting... and good catch, thanks for posting that. Can you mark your post as Resolved using the button at the top of the screen, please?

I haven't either.

Is this a problem just for you or for everyone?

Can't help you on that one. Perhaps later when I get a chance to build some test cases that I need for my own edumacation.

You must have a rule.

OK, failing that - as noted, give us an exmple. Show a sample of rows from Table A, same for Table B and then what your result for the target table need to look like. We'll attempt to infer the rules from that.

Silly question, perhaps, but did you click on the 'Show all' radio buttons?

I need to get both columns A and B are in the target. Column A is coming from one table,Column B is coming from from different table. Column A is coming by executing a lengthy sql. i have taken Column A in one source stage and Columb B is with one more source stage. eventually i need to populate Co...

Don't do both when you only need one. Choose User-Defined Update Only and put your insert sql in the 'Update SQL' property.

So... what are your join or merge rules for this? In other words, how do you know which record from one table needs to be joined/merged with what row from the other table?

[sigh] So much for a new thread.

The assumption is you have quotes in your quotes, is that the case?

That or one-by-one in a scripted loop.

We can not use server's job component or develop because we do not have client permision I am restricated to parral job only. As Ray would say - resist stupid requirements! You've thrown away a powerful part of your arsenal for no good reason. :evil: How about the other suggestion, a BASIC transfor...

What database is that? Does it work without the 'go'?