DSXchange

Do you have any idea what it is doing and why it worked?

People, don't just hand out code - at the very least explain what it is you are handing out as well.

It's hard to teach someone XML with a forum post or twelve. Do you have anyone you work with who can help you with the basics? You have a "namespace" issue.

:!: Ask for access. If it is something that you need to do your job there's no reason it won't be granted. Rather than attempting to get the owner's password, what you should see about getting set up is an account for you and then have SELECT access granted on those tables to you. Pretty standard st...

Sorry, I added the code tags so at least it was semi-readable but wasn't in the mood for the tedious 'tidy up' part.

So, none of the twenty other posts here which mention that error helped at all?

Upgrade.

It is exactly like that.

Transformer looping, if your version supports that.

So... a continuation / offshoot of this post it would seem.

OK, so what you tried is in the first post? Group by the account number and aggregate the two values, putting the 'C' values in one field and the 'D' values in the other. If you don't have any for a particular type that sum will be zero or will need to be made zero. I don't see a need to carry the '...

it has not been possible for me to find out the pasword to connect to an oracle instance Why is that... the owner doesn't know it? The DBA? Worst case why not simply have a new one assigned? Yes, the "encryption" DataStage uses for passwords is pretty weak so they can be decrypted and som...

Thank you for posting your solution.

Output order being different from input order is a whole 'nuther kettle of fish, as Eric notes. If all you are doing is reading from and writing to a flat file, what in the heck about that requires a four node parallel job? Server job will be up and out of the house before the PX job finishes putti...

The thing is it's kind of hard to not read a sequential file in order - in sequence - after all that's the very nature of sequential media. What makes you think that isn't happening? Are you sure the data isn't getting sorted / repartitioned after the read in the job? Do things look better if you ru...

What are the rules if there is only one type of transaction? Or if the sum of the credit amount is not higher than the debit amount?