DSXchange

Undoubtedly. Your procedure code as written will ONLY work if the date is passed in as coded in the TO_DATE function call: YYYY-MM-DD. Are you certain it throws the ORA error when your XML element looks like "<DATE>2011-01-01</DATE>"? No extra spaces, just a 10 character date string betwee...

Yes. Search and ye shall find.

I'm thinking you should be contacting your official support provider on this one...

As to your other questions: 1. No. Look up what the CENTURY PIVOT option controls. Or you may be able to supply the pivot year with the function call, I don't recall but it should all be documented. 2. My rule is to never rely on a "default date format" when loading to a database table. St...

He's saying there's no need for your cut/paste rearrangement of the parts, simply convert it to a date "as is".

No, this is a new topic... we've seen plenty of examples of compiler issues when a transformer is involved but not one where it fails the first attempt and then succeeds after that. I honestly have no idea here but wanted to point that out. For the record, what exact 8.x version are you running and ...

It's not a TCL command, it's something you run from the command line.

How are you counting the records: wc -l? Do you have any binary data in the record? All it takes is something that looks like a linefeed to change your line count.

Not that I'm aware of. That 4K sounds like a limitation on a single field size - is your record one long CHAR field?

There isn't one. Why from the command line? And then you'll do what - compile them? The Multi-Job Compiler supports compiling on uncompiled jobs from what I recall. While there isn't a specific command, pretty sure you should be able to leverage dsjob for this. Script something to list all of the jo...

In other words, there's nothing to convert here.

The fundamental problem here is the fact that dates have no format. A date is a date is a DATE and are stored internally as a number, an offset from a zero date. External string representations of dates are what have formats like your mm-dd-yy. You convert a string in a specific format to a date in ...

Split to your own post from this original thread.

Sorry, missed the fact that you started a new post as well as jumped on the old one. Anyone wanting to help should do so in your post on the subject as there's no need to two conversations. I'm locking this one.

Forgot to mention one bit of information here - the issue with doing those "after" routines is the fact that anything "after" has no access to row data flowing through the job. I'll admit that I have no idea what Set_Stage_Variable.StageVar is but I doubt it changes that fact.