DSXchange

Oh... after that, if you still get 'no data' out then you have an XPath Expression issue where they don't match the incoming data. That or you didn't Fully Qualify the pathname in the Folder.

You pick up only the filename by defining one field in the folder rather than two. Mark it as a key. Then chose 'XML/File path' and make that key column the 'XML Source Column' in the XML Input stage.

Interesting solution. So, no issues with quotes disappearing yet? It is notorious for stripping quotes from parameters, which usually means sql snippets are affected the most.

Just the one 'Days' function I mentioned should do it, no need for both like that. Heck, I'm not even sure what that is doing.

Depends on if this is a data field or part of the file's name. For the former, I'd check out 'DateFromDaysSince' with today's date and a "-1".

I guess slower and successful > faster and fatal.

Interesting that they added support for OCCURS DEPENDING ON as well.

Sorry, thought it supported multiple commands much like the before/after sql tabs do in other stages.

Doesn't the CLOSE command support that? There's no direct equivalent to the 'SQL step' you mentioned, in my world this would be a scripted call to sqlplus that executed all of those commands and checked for issues, called as a separate job / step so it can be restarted without being tied to the load...

Craig, CFF stage supports Occurs as well as Redefines. I did not understand what you exactly meant by "not supported"! Well, by 'not supported' I literally meant not supported, as in it didn't support them and you have to remove / flatten them in the CFD before importing. Perhaps that's n...

Sorry, couldn't resist.

Was your original dsenv completely wiped? If you go to $DSHOME and do a "ls -l dsenv*" does more than one file show up?

You bet.

OK. Have you checked your dsenv file?

More than likely an issue with 'dsenv' not having the changes it needs to support Oracle. What exactly do you mean by 'reinstall'?

Sorry, but that didn't really answer either of my questions.