DSXchange

Globbing. Your 'mask' isn't being read in as a literal but is being expanded or 'globbed' by the shell. I would guess that the values they 'become' are the first values in the file list that matched that wildcard pattern in the working directory. The ones that 'were fine' were probably fine because ...

That should be fine as well, I would imagine, depending on where it was being used.

True. That 'optimal size' varies based on ARL, network packet size, phase of the moon, yada yada yada. So, as you noted, testing is required to find that 'sweet spot' for each stage / job / combination.

Interesting... at the very least this will get me to check out AutoIt and Taskbar Shuffle.

Yes, it controls how often a commit is done and yes, Transaction Size should be (IMHO) an even multiple of the Array Size as a best practice.

Never seen such a thing that I recall. Me, I would run it by my DBA if I was you.

Zeroes are not a valid anything, month or otherwise. What does the output look like if you run that TO_CHAR sql in SQL Developer or Toad? No clue at the moment why that is turning into zeroes... is your source field an actual DATE field or something else?

No.

That's the whole reason why Craig suggested it.

Checking Field[1,4] which disregards anything else that follows in the string is exactly the same functionality as checking for like 'XXXX%'.

Oh my... we're both wrong. I just went back and reread the original post. As in "read read" and looked at the example. Missed this key fact that "all records are in a single record". There is no header record, followed by X detail records, followed by a trailer record. There is a...

Someone else is going to have to help now, my experience with PX on Windows is zero, zip, nada, zilch. Curious though, why are you pointing the compiler variable to something in the MKS Toolkit directory? Is that really where you installed Visual Studio 2005?

Your question is a wee bit too broad... what kind of help do you need? Have you read the docs? Pressed the Help button in the stage? Tried to actually use it?

Do you have any specific questions?

We know.

What's "not working" about it? Show us examples of what a detail (non-header-trailer) record or two look like.

OK... I was hoping you would make the logical leap and see the need to "fix" all pathname pieces with spaces in them, something abhijain specifically noted for you. Now it can't find "MKS" where you have ""MKS Toolkit". The rule is the first six characters plus &qu...

<bzzzztttt> Sorry Andy, thanks for playing.

D'oh... where the heck did Andy go? Silly Wabbit.

Define 'not working', that looks perfectly fine to me. Are you sure you are checking the right 'column name'?