DSXchange

The function does not include any filtering capability. But your routine could easily process the list to retain only those that match your pattern.

Which path? In particular, DSEngine and the contents of its bin subdirectory. The permissions here have to be very specifically correct.

Yes, availability began in 8.5.

Tip: Connectors are available in server jobs as well as in parallel jobs.

If the data type is string it's more efficient to provide a quoted value, thereby avoiding the overhead of the implicit conversion (which nevertheless requires some processing).

Server job (as marked) or parallel job (as posted)?

From memory you can't install directly using an Oracle RAC - you have to install using one node then configure to inform Information Server that it's actually a cluster. Contact your support provider or search the IBM website.

Curiously you can use both pipeline and partition parallelism in server jobs but, in your case (with small volumes) you don't need to.

If you set partitioning unwisely you will get incorrect results and possibly degraded performance as well. (Auto) is guaranteed to give correct results. It may not be optimal in all cases (for example Entire on reference inputs to Lookup stages, Hash in other cases where key-based partitioning is ne...

One of the many reasons that a zero-length Data Set descriptor file will not work is that the descriptor file includes not only the pathnames of the segment files (on the resource disk), but also the record schema that describes the records in those files. The record schema is required even if there...

What value did you use for the default block size? Did you look at any of the other transport block size settings?

You might also look at the BUFFER environment variables; it may be one of these that is filling. By default you have pairs of buffers, each 3MB, with switching occurring at 50% full.

Are the permissions correct on the DSEngine directory and its subdirectories?

Then you can log an enhancement request, either through DSXchange or through your official support provider.

Are you attempting to run this job from the dsjob command line, from the Director client, from the Designer client or by some other means?