DSXchange

You can install multiple client versions, but you can only have one active at once. Switch between them using Multi Client Manager.

The fact that it's -APT_SectionLeaderFlag suggests there's a problem starting/communicating with processes on other nodes, possibly during startup. Enable the reporting environment variable that shows startup to investigate further. I can't see any evidence (yet) that it's memory related. APT_DISABL...

The IBM web site suggests it's 8.1.2

Create stage variables derived using Field() function to extract the two fields.

Create a new output field derived as Use that new field (sorted) as the key on which to remove duplicates.

I gave my solution 40 minutes ago.

What evidence do you have that Oracle is involved?

Funnily enough, not everyone in the world uses Oracle.

The schema equivalent of NVarChar(k) is ustring[max=k]

Do a (range?) lookup against a time dimension table, with multiple row return, constrained on weekday name not being 'Sunday' or 'Saturday' to get a list of dates.

I agree. Use an If..Then..Else construct.

How does the job make use of its invocation ID? What difference does it make whether the last character is Y or N, and how is that handled in the job design?

See this thread
Read UniVerse System Description manual.

I provided a complete solution. And corrected your erroneous syntax. You need to obtain premium membership to see my complete reply. Premium membership is one of the ways that the hosting and bandwidth costs of DSXchange are funded. It's not expensive, at less than 30c per day, and the benefits do o...

There is no problem with your VOC file. You have not understood the syntax and requirements. 1. You need to copy not only hOCC_FACT but also D_hOCC_FACT to the other directory. 2. You need to delete a record from VOC, not construct a command. Use a standard SQL statement such as DELETE FROM VOC WHER...

Either you have not fully/properly configured UniODBC or you have not converted the Unidata account for ODBC access. The latter is the more likely.

A communication error has been detected.

Involve your network administrator and DB2 DBA.