DSXchange

Most of my clients are risk-averse, and will not be early adopters. Even when they do, the majority are planning a goodly period of parallel running. This is just such a big change. Some of the FUD from IBM sales reps hasn't been helping either. One of my clients was informed that "server jobs would...

My error. Should have been:


The default trimmable character is APT_STRING_PADCHAR which, unless you've changed it, is Char(0), not space.

Why not put MAXFETCHCOLS=2500 into your uvodbc.config file, at least for this particular data source? You'll probably need a larger MAXFETCHBUFF as well.

The Join stage requires its inputs to be sorted, so that it can employ an efficient memory management algorithm. If you don't specify sorted data the composed score will have tsort operators inserted on the input links so that the data will, in fact, be sorted. It is far better technique to retain c...

Welcome aboard. :D

Most folks use the Complex Flat File stage to read these data; it has the conversion capabilities built in.

Job sequence with StartLoop activity based on the regular expression?

Another approach would be a filter command in the Sequential File stage that generated (echo) a dummy row if the file were empty or absent, and the contents of the file (cat) otherwise.

I doubt that it's possible using StartLoop and EndLoop activities, which is what you seem to be asking. The StartLoop activity only effects a counted loop or a "list of things" loop; it does not effect an uncounted loop, and this is where your proposed algorithm fails. I'm surmising that you also pr...

There's no exposed function that can return DSE.NO.MORE.DATA. It's only used in "internal" functions as far as I am aware.

Even without searching here, the manual (or online help) specifically states that the Link Colletor stage requires that inter-process row buffering be enabled. Since this is mutually exclusive with in-process row buffering (being chosen with option buttons), it follows that the source of your error ...

In particular observe that what you want to do is NOT a UNION, it is a full outer join. You could effect this in Oracle OCI stage, by specifying the full outer join in the Table Name field. A lookup won't do it - you would need two lookups, which would be inefficient.

Theoretically there is nothing wrong with what you are doing. Have you reported this to your support provider? If they support the locale, then they must support the character set!

Search is your friend. When you do, you will find out that some of the compilation of a job sequence takes place on the client machine, and that you probably do not have the requisite write permissions there.

Yes.

The Lookup stage generates a composite operator. The first loads the contents of the reference source into a virtual Data Set and constructs a hash table with which to index it. The second performs the actual lookups against the virtual Data Set.

It is not possible to prescribe storage order in a hashed file, for exactly the same reasons it is not possible to do so in a database table. The database controls where records are stored. In the case of hashed files, it's the hashing algorithm. You can sort upon retrieval either by retreiving with...