DSXchange

Oh, sorry... you specifically meant a direct path sqlldr type load. There's some useful information here* which may help. Oracle will disable constraints (etc) during a direct path load but PX may not like it. Was the message from DataStage or Oracle? Can you post the complete, unedited message and ...

Sure... just make sure you don't violate any of the constraints. What have you tried? What issues are you having?

Exactly! And thanks for posting the links here. Can you also mark the post as Resolved using the button at the top of the screen? That would be

Haven't tried but you should be able to use the External Source stage to return all of the filenames (using a *.xml pattern) making sure the XML Input stage is set to the URL/Filepath option.

Can you answer my "Are you trying" question please?

I poked around and every link I could find that alleged to be the free 2005 version led to 2008 or 2010 beta downloads instead.

It's in there.

So, no actual error - you've just never seen that before and thought there was something wrong with it? Are you trying to send that to the webservice or getting it back from the webservice? Assuming the latter, just strip the "zulu" part and replace the "T" with a space.

[sigh]

None of those belong in your LIBPATH. Remove them and replace them with either $ORACLE_HOME/lib32 (just that, no "base", no "tns", just that) if that exists on your system or $ORACLE_HOME/lib if the other doesn't exist.

Then restart DataStage again and let us know.

OK, if your target is XML for a webservice the original format posted should work fine, I would think. Have you tried actually using it yet?

No, what is your target - a flat file, database table, what? What happens if you declare it as a Varchar there?

What problem? And where are the Oracle libraries in your LIBPATH?

Not that helpful, perhaps, but you really should be skipping 8.0.anything and installing the latest 8.1 version. And is that an official release? RC typically stands for Release Candidate which is not the same as a GA or official release.

Seems it is way past time to involve your official support provider. Getting nothing back when you echo $DSHOME or $LIBPATH after sourcing dsenv makes zero sense. You need professional help... so to speak.

First off, those are not "junk" values. The 'T' marks the date/time boundary and the 'Z' means Zulu time, a UTC offset of "00.00" in an ISO 8601 timestamp. See here for the standards, especially pages 2 and 7. What is your target?