DSXchange

Thank you for posting the resolution. Now please mark the topic as resolved.

Examine the generated OSH to see where the case insensitive property occurs - it's the Caseless property in the Lookup stage. Temporarily try clearing it to see what happens.

The second error may be an artifact.

I totally HATE your stage naming conventions.

Check LD_LIBRARY_PATH environment variable in the "environment variables" message in the job log.

Chances are that it does not include the directories containing DB2 libraries.

You may need to edit dsenv script so that it does.

No. Sparse lookup is documented as only being for DB2 and Oracle.

No, unless you're prepared to spend the time and effort to create a stage with that capability, or spend megabucks paying IBM to do so.

If you only have server edition licensed the decision is a no-brainer. Likewise if you've chosen only to license only enterprise edition. Small jobs - server. Large jobs - parallel (probably). Medium jobs - some other factor needed to make the decision. Nothing quantifiable! There's a lot of paralle...

Not all the changes relate directly to the DSXchange forum.

(Thinks: that's got 'em wondering!)

Perfectly functional, provided your text files meet the requirements of the ODBC text driver (column headings, no "strange" rows).

Just don't complain about the speed.

Suspect I already had it open when you replied.

This is an example of why optimistic locking strategies are not perfect.

Wasted money - she's a graphic designer, has no interest whatsoever in what I do (apart from paying her fee).

Are you sure? Your original post mentioned APT_CONFIG. This is not the same environment variable as APT_CONFIG_FILE. Try removing APT_CONFIG and adding $APT_CONFIG_FILE as the job parameter (click Add Environment Variable). Set the job parameter default value to $PROJDEF. Always do this for $APT_CON...

Please delete duplicate post.

Take a look at the Parallel Job Developer's Guide - in particular number conversion functions. Differentiate ceil, floor, round_inf and trunc_zero.

Please post your research findings.

As noted, 'tis not in DSParams.

Yair, but before I'd seen your post. C'est la vie.

My site is currently being made over by a professional graphical designer. Problem is I'm never in one place long enough for her to ask me questions!

Go to your Administrator client and verify whether APT_CONFIG_FILE is in the list of environment variables and has a pathname of a valid configuration file (probably default.apt) as its default value.

The message suggests that it has been removed.