DSXchange

This may also require SELECT privilege on the system table(s) in which partitioning information is recorded.

udayanguha wrote:CFF stage. Will this take care of everything like packed decimal etc?

Yes. If configured correctly.

IBM will always recommend using IBM drivers. By all means try the Microsoft driver - it may perform better. Or it may not.

srinath0253 wrote:Any update on this post?

Clearly not.

Research about ITAG installation, which is the mechanism for installing side-by-side engine versions, but be aware that not all point versions support ITAG installation.

Or change the value of APT_COMPILER to something innocuous, such as echo Compilation not permitted in production

How soon we forget!

Is the right square bracket in the FROM clause a typo, or the cause of the problem?

It's a network dropout ultimately, which makes it interesting that you're able to reproduce it. I think that you need to go to official support on this one - perhaps the call to SQLEndTran to send the COMMIT is also sending something that causes a network interrupt.

Welcome aboard.

If you have RCP enabled, then DataStage will generate SELECT * FROM source irrespective of which columns are mentioned in the job.

Seems like column siu_key is not present in the production version of the source table.

Even so, sometimes there are dialog boxes that fail to get focus. You may be able to get to them via the task bar, by minimizing all windows (opening the desktop), or (possibly) via context switching (Alt+Tab).

Probably not in version 8.x.

The ideal solution is to prevent the jobs from failing, in which case the temporary files will automatically be removed from the scratch disk. Beyond that there is no "parameter" or any other kind of magic bullet. You need script to delete files with a specified name pattern and older than...

There is a patch for that issue. I'm not on site at the moment, but I installed it as recently as a week ago (on version 11.3.1).

In general a good approach is to begin by eliminating any option that is clearly incorrect. Beyond that, why not contribute your thoughts first, rather than expect to be spoon-fed answers?