DSXchange

What routine? Why not leverage USERSTATUS to pass the value, if you think that's the issue?

ps. UtilityHashLookup() will fail silently if not used properly, test your logic elsewhere to ensure it's doing what you think it is doing.

And the resolution was?

Well, well... let's see if I can help. :D On the MD5 front, we implemented that at the O/S level using Java. Basically, we landed a flat file with all of the data to be 'munged' using a Sequential File stage and then using the Filter option on the reading side passed the contents of the landed file ...

Or substring off the first 10 characters (essentially the same thing) or use the Field function:

Sheesh... will have to keep that in mind, it seems, when people post 8.x questions on this topic.

Year or month or day, perhaps? In any case, either substring with [] or use Field() to get just the parts you want.

The property appears to remain unchecked when auto-purge was inherited from the project. :? That's... not really true unless this is changed behaviour in the 8.x version. What I've seen pre-8 is auto-purge always checked when it is on, regardless of how that was set - manually or via inheritance. U...

What do you mean 'keep the date'? A date is a date and is stored in an internal representation, only external (string) formats have display options like that. So use whatever mask matches the incoming date format in the StringToDate function.

I believe you'll find there's a patch for that. What 8.x version are you running? If you're not on 8.1 have you loaded the 'fixpack'?

verify wrote:As i am processing 100 xml files, so i am getting this error as "Consumed more than 100,000 bytes,job aborts"

I don't see one as causing the other, something else must be going on. What exactly are you doing in the External Source stage?

Hmmm... I don't see more questions, I see the same questions we already went over in your other thread on this topic. And I answered them over there. :? Two points: 1) You're still posting in the wrong forum. 2) More questions means adding them to your existing topic, please don't start a new one to...

Well... not sure what all of the dsjob comments have to do with the subject line. The PX Sequential File stage has the ability to read those zoned decimal / overpunched fields without needing any special function like Server does. Set the decimal field Packed attribute to 'Yes' and then a sub-proper...

Buggy Oracle release, it would seem. Hard to imagine, I know, but it does happen. Now, I am expecting you to ask this question of your official support provider as they would be the only ones to truly know.