DSXchange

Hmmm... I don't think two will help as both can't be used. You'll either need to build a single composite index (trick to that, I think) or first see if one index (over the 'leading' key field) helps.

You only get the InvocationID prompt for jobs that are Multi-Instance enabled. Don't see what looping has to to with InvocationIDs, however.

Define it as a Char(5).

Accommodate what, exactly? Right or left justify it within the field, depending on what they are expecting. And you could use either spaces or zeroes when right justifying, again depending on what they are expecting.

Cool. Time to mark this as Resolved then, using the button at the top of the screen.

That depends on where "you" told the installation software to create the Projects directory. Yes, it should be something like you posted but I don't know what the default for an 8.x installation on Windows is.

That's certainly one variation. Basically, you need to generate the date in the proper YMD format with any delimiter and then strip the delimiter.

Search the forums for CREATE.INDEX and BUILD.INDEX - you'll need to issue both one time in each new Project or if the hashed file gets dropped.

You really want to specify a full path there as any relative path is relative to the "current working directory" of the job - i.e. the Project. And you do not want to be putting files there.

UV over Hashed implies using fewer key fields than were populated in the hashed file to get multiple results back. Did you create indexes over the UV key field(s)? Without them, it will be dog slow.

Sorry, I can't check but believe the file location / directory and pattern are separate properties of the stage. And on Windows with 'long filenames' that contain spaces you may need to quote that part, that or use the 8.3 short name.

Something with a wildcard in it, typically. I supposed it could work without one but what is expected is a wildcard "pattern": "*.txt", "Data*.csv", "???.csv", etc.

Ok. Just curious - what happens when the alpha characters are outside of that range? Are they still just stripped or are they rejected then?

First problem looks like you didn't tell it where to look and second one isn't a file "pattern".

Not getting into the why, but I personally know about half a dozen people that have done both and they all prefer DataStage. No knock on either, but if they had a choice that would be their preference. For whatever that is worth. For all I know it may be heavily influenced by which tool you were exp...