DSXchange

Yup. Crap, how did I miss that? It's right there in black and white pixels in the documentation of all places: File Pattern: Specifies a group of files to import. Specify file containing a list of files or a job parameter representing the file. The file could also contain be any valid shell expressi...

You'll need to wait for someone way more smarter to come along, someone like Ernie who is intimately familiar with the new way XML is generated in these later releases. I was going to post something and then realized that what I used back in the day may no longer be relevant. About all I can add is ...

I suggest turning it over to an Admin. Or you can try "2" again but that must be run with no other users connected nor any jobs running, otherwise (as you've found) it makes all of the jobs 'disappear'.

No, file pattern means you'd need to supply a wildcard pattern that would match all of the files you'd want to process, not a specific list of filenames. Typical solution for a 'list of files' would be a looping Sequence job that runs a single job once per filename.

Find out what happened over the weekend - patches, upgrade, reboot, something obviously changed and there's no way anyone outside of your company can know what that is.

What was meant is that when you have an issue or question, you should create a new post on the subject. If you find an older conversation that seems related, link to it. We'd like you to 'own' your own issues so you have control over the fate of the thread and can decide when your questions have bee...

You were 'unsuccessful' how? A full explanation of what you tried and what happened when you tried it can go a long way towards getting a resolution out sooner rather than later.

Please start by creating your own post with a meaningful subject in the proper forum - either the Server forum if you need help with a Server job or the Enterprise Edition forum for help with a PX job.

First order of business would be to tell us (or find) where you are using "DifferentKey". For example, is it the name of a routine you are trying to call? Worst case go to the Project's RT_BP5267 directory noted in your message, find the "TRANS1" file there and search through it ...

A "sparse" lookup would trigger individual queries against the table.

(moved from the TX forum)

Are they text files?

REINDEX was one of the "go to guys" before the 8.x release but now with information spread across two repositories it can't fix everything. Sounds like your repositories may be out-of-sync now and to fix that you'd need to contact your official support provider and enlist their help.

PhilHibbs wrote:There's no way for the Transformer to know that the current row is the last one.

Actually, that was added in the 8.5 release, from what I recall.

As you noted, we'd still like to know the "why" of all this, then perhaps we can give a cogent answer.

Sorry, I don't know squat about DB2 but don't sequences there support the caching concept that others like Oracle do? Specifically, if a sequence will need to be leveraged in large chunks (like your tens of thousands at a time) then you set a high cache value and the first NEXTVAL call reserves that...

File extensions are pretty much meaningless in the UNIX world. Regardless of extension, it will read 'flat files'... text files, if you will.