DSXchange

I have no idea what you mean by 'capture' here. Are you saying you want to use an 'insert else update' action and then know which records were inserted versus updated? :? You can't. Why not do this the right way and prequalify your data via lookup so you know which are which and each can be handled ...

'Not recognizing' as in staying red in the derivation? What does it say if you right-click on the red and select 'Validate Derivation'?

Installing an email client like blat would make that pretty trivial.

Interesting that I'm thanked for my help and yet my attempt to help is rated as 'off-topic/superfluous'. Nice. :? I ask re: the 'bitness' of your O/S as I've seen issues like this in a 32bit environment that did not occur in a 64bit one. I can't imagine any changes to your backup script would genera...

The XMETA database is well and truly obfuscated, so you'd need to involve your official support provider for help with that.

As you've noted, all you know is the number of delete requests sent to DB2, not how many rows were actually deleted. You'll need to count before and after to get that number.

Short answer is yes but you'll have an issue with quotes being stripped from the sql. Might be better to land the sql and then utilize the 'sql file' option in the stage but you won't be able to include any job parameters in the file.

No RCP in Server jobs. And hopefully the O/P isn't asking how to select dynamic columns in OCI as that's not possible. Dynamically building the query - the joins and where clause for example - is perfectly feasible.

Specifically, stages that could be affected by partitioning include the Lookup and Aggregation stages. Sometimes it's about building an efficient job and other times it's about getting the correct results. Both Parallel pdf guides discuss this and it would be well worth your time to read them.

Ah, ok... no problem.

Welcome. :D

First suggestion would be to do an exact search here for "Fault type is 11" and go through the posts that mention seeing this with Oracle to see if any help. Generally seems to be an Oracle client version issue.

Setting it to 'fixed width' for a csv file makes no sense, unfortunately. And neither does it hitting EOF after reading 5 records when there's allegedly 10. We're missing something here.

You can't, it's not a separate app like it is in PX. Why would you want to?

Then just edit the flat file.

If you are using a database Sequence object with the stage, you'll need someone (a DBA) to reset it for you.