DSXchange

Have you tried searching the forums? I got 14 other hits on "Null archive", did none of them help?

SeeBeyond? Is that the product (ICAN, I believe) that Sun acquired a couple of years ago and calls Java CAPS now? I really don't know much of anything about it, but thought it was more healthcare related for some reason.

Umm, no. All you managed to accomplish by not stating your problem accurately was cause two pages of thrashing to occur when it could have been solved in one or two responses had you correctly described what you were doing. Please keep that in mind in the future. The more information and the more pe...

True, you should. What I've had issues with is cat file* in the Filter.

Try using a LongVarchar rather then a Varchar for the output field.

As a general rule of thumb I don't enable that option. For whatever that is worth.

It means you need to protect them. Try putting either a back-slash or another quote in front of each one - for example:

AND col_2 IN (\'A\', \'B\', \'C\')

I'm curious why everything (subject, first post, etc) states you were having a problem with a hashed file lookup and now suddenly it works if you use a hashed file?

It's probably our old friend where the quotes get stripped. Try escaping them.

Let us know.

Turn off Write Caching.

Shocking.

If you want to concatenate the files, that's not a Filter thing - do that before job using command line functions or write a script. What you may be able to do is 'cat' (or perhaps 'type' on Windows) multiple files to 'standard out' via the Filter option and then have the stage read them as if they ...

Hmmm... have you tried as dsadm using the Multi-Job Compiler from the Manager against the protected project?

Any 'migration' tools would come from IBM, and they won't make them generally available but will instead leverage them as part of a consulting arrangement. In other words, you'd pay them to automate as much of the migration as possible. You'd still need to put a bow on it after they were done. You'd...