DSXchange

Try trimming the key values, Alain.

In earlier versions of DataStage the Oracle lib32 directory had to be in the path before the lib directory. I don't know if this is an issue with 7.5 or not.

Tony

In earlier versions of DataStage the Oracle lib32 directory had to be in the path before the lib directory. I don't know if this is an issue with 7.5 or not.

Tony

Thanks! I'm reading up on this now. I appreciate your help.

Tony

No, I needed separate key columns and a column containing the entire XML string (including the data in the key columns).

I haven't figured out how to make the XML Output stage pass through a column. I'm reading the documentation now. Can you give me any pointers on how to do this?

Thanks,
Tony

create an XML document in one column and one or more key columns on the same link? The requirement is to read data from a database table, transform the data to XML and insert the XML into a database table with non-XML key data as the Key columns for the row. I appreciate any help you all may give me...

I personally prefer to have hash files in a directory. There are already so many files in the project directory, when it comes time to try to go clean up the partition (you know you'll have to sometime) you're in danger of deleting files that you shouldn't or leaving files that can be deleted becaus...

what is this "DataStage Phantom"??? We see this on many of our jobs - though the jobs seem to complete successfully and the end result is as expected - I don't know what this "Phantom" error is. You should always try to understand why you're getting phantom errors because they m...

Interesting. I was working on the comment in dsenv that says it must be unset on HP/UX 11.00 - and we run 11.11, which I understand is 11i. Ya know. I just looked at our dsenv file and that comment _is_ in there. All this time and issues with Ascential and I didn't even see that comment. <sigh> I'm...

Craig, LD_PRELOAD set? Not sure of your DS and HP rev so canot advise, sheck with support f you can safely unset. I ran into this problem too and was told that I could comment out the LD_PRELOAD stuff in the dsenv if I wasn't using PX, I think. I just converted our scripts to use SH rather than KSH....

Check out your Notification Stage and see if you have the word 'OK' in the subject or body of the email to be sent. I ran into this issue before myself. I can't remember exactly, but I had to change how it was quoted. I think I changed from single quotes(') to double quotes("). Hope this helps,...

'S what I get for replying in a hurry. Yeah, what I meant was the Windows SORT command (open a command window and type 'help sort'). (I have no idea whether the Windows sort command would be faster than the Sort stage or not.... I was just trying to save face )

tony

First make sure you don't have any left over processes for that job on the server. To clear the job status: Open Director, select the job in question, Click on the Job menu and pick the Clear Status File option. Probably be a good idea to do the Clean up Resources first and make sure that all the pr...

If you know that the job isn't running, you can clear the job status from within Director. Make sure that you don't have any left over processes associated with that job from previous runs.

Good Luck,
Tony

One other thing, and it's been recommended in this forum before. The UNIX sort command is a _LOT_ faster than the sort stage, especially with lots of records. If you have more than a few thousand rows, it might be faster to write the data to a seq file and sort it with the UNIX sort command. Good Lu...