DSXchange

Interesting, thanks for posting that. Note that the resolution is not to go all #3 on it but rather use the custom truncate option. That or use a native stage if at all possible.

Sorry, but... and? That is the expected behaviour, never mind the fact that you ask no question. For an example, see this randomly chosen page and scroll down to the "5. References" section.

Yikes. If that's true (easily testable) then #2 is living up to its number and should be avoided.

Truncate is truncate. Why complicate things or make them more obtuse? If you always need to truncate each table before it is loaded, go with #2. Never mind the fact that #1 will complicate a restart, meaning without manual intervention of some sort you'd have reload ALL should one fail. And #3 essen...

Mine is not a fixed length file. But its a fixed width column file. If any value is null, then nothing should be populated. Honestly never heard of such a thing. A column can't be any kind of "fixed" in width if the width changes when the value is null. :? But if it is working as you need...

Why, yes there is!

viewtopic.php?t=144212

First off, you cannot have any nullable fields in a fixed-width file unless you also make sure the Null Field Value is all spaces. Also, I seem to recall a property where you specify the number of bytes between columns, you may need to set that to zero. Also think you need to make sure you set the D...

So what was the resolution?

You may want to reconsider using a numeric loop. Rather, can you build a delimited list of the filenames to process first? You can then pass that list to the Start Loop stage and it can loop through the list until it runs out of elements in the list. It can then leverage the built-in loop counter to...

Sorry but I have to ask - why? One would typically do that by building the appropriate parallel DataStage job and letting the product generate that for you. Why do you feel the need to be down at that level building OSH scripts by hand? IMHO - leave that to the experts or people who come from the or...

Not really clear why you are mentioning "by the osh". Is this something you want to do inside a job (while it is running) or outside of a job after it completes?

As a general statement, I would think #2 would be more better.

Welcome aboard. The short answer is 'no'. However, there is a simple way to exit the loop early. Have a trigger path that fires when you would have been setting the counter to 99 and instead have it branch to a stage linked AFTER the End Loop stage. That stage can be anything, including just a stand...

Define 'multiple files' - multiples based on what, a wildcard pattern?

Me, I'd write a script.

... or just continue to wait for divine intervention.