DSXchange

Or figure out what part of the file load is "consuming a lot of time" and optimize it. Then perhaps start some form of multi-looping if it needs further optimization.

Examples here: viewtopic.php?t=124375

As noted (twice now) you must include the text {FILE} before the pathname... otherwise all you have is an invalid SQL statement.

Ah, ok. Your problem is your Cmd3 string is built inside a pair of quotes so no variable substitution is done. Keep the string sections in quotes and concatenate the variables into it: Cmd3="SELECT MAX(ZONE_AVG) FROM MDR.ZONE_CONTROL WHERE ZONE_ID = '" : p_ZONE_ID : "' and ZONE_CD = '...

You cannot pass anything from a before routine to the job as it is already running. What you can do is use a Sequence to run the routine, then the output can be passed to any downstream activity as a job parameter.

Only whatever is documented - did you check? And since I can't tell from your reply, you have to actually include {FILE} at the front of the pathname rather than just the path - did you? Or it might be "{FILE}=", don't recall off the top of my head.

I can't check at the moment but it isn't always a discrete option. In some stages you specify "User Defined" and then put "{FILE} <path to sql file>" in where the SQL itself would normally be. Should be documented if that's how it works there.

1) Do all the files need to be processed individually?
2) Checkpoints in the Sequence should solve that problem.

Are you not familiar with the find command in UNIX? Searching for "PXEngine" should turn everything up. Bare minimum would be:

Sequence as in surrogate key? Will a gap in the numbers actually hurt / break any other processing you'll be doing? The subject has been beat to death here but for one more turn in the barrel check an article like this one. It's a general article with specifics for CA-Ingres but very relevant, if yo...

Don't need to check anything - I know what you posted and what you are seeing and I stand behind the replies I posted. The behavior may be specific to your point release, for all I know. Bottom line, all I'm saying is use at your own risk.

Just locate your "PXEngine/lib" directory and copy it there using the full path.

Sorry but that's not according to me but rather according to the documentation. If you feel that's working for you, that's fine, but don't be surprised if in the future you install a fixpack and it no longer 'works'. And hopefully the only period in the string is in front of "OLD". Just sa...

Perhaps you should reveal your formula and why you are concerned with 'holes' in the numbering.

The Field() function only supports a single character as the delimiter: " delimiter evaluates to any character, including field mark, value mark, and subvalue marks. It delimits the start and end of the substring. If delimiter evaluates to more than one character, only the first character is us...