DSXchange

ray.wurlod wrote:I think what Craig meant was for you to reveal how you have set up connectivity to Oracle from the DataStage server. We're talking environment variables and tnsnames.ora particularly here.

Yes, exactly.

How exactly is "date1 is sysdate"? There's no way that one single select "works fine in Toad" unless you are actually running a PL/SQL block or some such thing to set "date1" to that value first.

And if you have any issues attempting to clear the log from the Director, go to the Administrator and use CLEAR.FILE RT_LOG1731 to do this.

:? Your requirement is... ill informed. There is no "sign" needed for that Oracle NUMBER type other than the "minus" you've already noted works. Your positive values are being stored properly without all this sign nonsense and changing the target to a varchar is absolutely the wr...

I've seen this same behaviour in the OE stage, certain combinations of options will result in issues (like FK constraints) being neither logged nor causing the job to abort. All is green and only a very close examination of the logs shows the issue.

Seems like a 'feature'.

I thought... dsjob -wait option would be applicable for another dsjob command not for script. So its doesnt matter.. whether you are callling DSjob or script Thanks for clearing my doubt... I still have doubt, mostly because I have no idea what you are saying here. The "-wait" option is o...

And when you Reset the aborted job, is there a "From previous run..." log entry added? If so, post the contents of it as well.

Index() will return the position of a substring within a string, but it sounds like you want to Locate() an array element instead. Check the documentation for the difference.

OK... and what have you tried? You should have a job with a Folder stage and an XML Input stage at the very least. You should also have imported the metadata from your source xml (ideally from an xsd) so you have the appropriate XPath Expressions to use in the XML Input stage to parse this. And if y...

Which are apparently Integrated Exchange Format files, "the preferred method for data exchange within the database manager". What kind of "loading" are you thinking about doing here outside of DB2?

dsex100 wrote:I have also set up my environment variables according to documentation.

Please explain what this means, what exactly you set up where.

Is one of the four columns being selected the same column substituted in for the parameter marker? Four columns selected, four columns defined in the stage? Or five?

Can you post the sql you are using? That and verify that any of the columns used in the 'where' clause are marked as Key fields as well.

If DSLink3.DOB_DATE = '0001-01-01' Then StringToDate("1700-01-01 00:00:00","%yyyy-%mm-%dd %hh:%nn:%ss") else DSLink3.DOB_DATE You are mixing dates with timestamps. You'd need to declare the field as a Timestamp and then use StringToTimestamp() above rather than StringToDate() if...

You can use the Sequential File stage and edit the field directly to tell it that it is both 'packed' and 'signed' and it should read it correctly.