DSXchange

Just because it is now an "environment variable" doesn't mean it no longer needs to be passed to the job as a job parameter... you've simply changed the source of the value, not how it is used in the job. Typically, one would now have the value locally as $ENV so that it can come in from t...

Actually, people posting the correct name of the routine is the greatest search easer.

Is there something like commit will not happen for Update activity? No, there isn't. Unless you've found a bug, commits happen when the number of 'transactions' - regardless of what they are - reach your Transaction Size setting in the stage. For grins, what database and stage are we discussing her...

How many hours to process how many records? Unfortunately, pushing a CLOB through the job brings a lot of restrictions along with it, one of which is needing to keep the Array Size at 1... which means it will be "slow". You may be better off converting the file into something that is "...

Hmmm... what did you actually use for the "datehere" part of the posted code? Oconv((Iconv(datehere,"D-YMD[4,2,2]")) ,"D-YMD[4,2,2]") If you used Date() as mentioned in your first post then the inner IConv is actually doing nothing as the conversion cannot be made, mean...

Yes.

Andy - the admin never said there weren't any entries in the logs, just that it's not their problem.

I'm sure it is documented but I don't have access to my docs from here. However, from what I recall both issue an insert for every record but the former will log an error if there is a primary key violation while the latter will ignore (as in not even log) any such thing.

Regardless, this would be a good place to start.

OK... does each one go into its own column in the output or do certain codes aaggregate together? Just trying to make sure we have all of the requirements down. For example, should you actually have all nine as columns in the output but with some number of them empty? I'm envisioning something like ...

C++ routines for use in a PX job? BASIC routines for use in a Sequence or Server job or as a Before/After job subroutine or in Job Control? As noted, you might want to narrow this down a bit...

Pulled this conversation off into a more appropriate forum.

How many different "Data Indicator" values can there be? Just the two which break down to "Payment" and "Charge"? If so, is there any chance of a charge without a payment?

OK... rather than further subvert an already hijacked thread from 2007, let's get you off into your own topic of discussion. I've linked your post back to the one that had "the code" being discussed. However, since there are multiple examples in there... Clarify your requirement for us. Ar...