DSXchange

No, not that I've seen yet... you need the job to Abort so the checkpointing can restart at that point. And your issue with 'applying the limits for warning messages to 1 does not help since the server is unable to respond in time' has been discussed here before and seems to be unique to PX jobs. P...

Hi We have a rather unique problem: The design of our restartable suquence is such that if any one of the jobs finishes with a status other than "OK" control branches to a routineactivity (that updates the control table for the sequece) and then a terminator activity aborting the sequence....

When i'm invoking a unix script from Before job sub-routine and attempting to connect to Db2 , it fails.

But when path variable is been set properly it works fine.

Currently the issue is our dsenv file do not export PATH variable.
So i want to know how does the DataStage gets these values ?

The DB2 guys suggested: - Installing a 32-bit DB2 instance, and remotely use the 64-bit instance. We didn't really want to do that, so for now we've gone with the "kludge" in the called unix script that changes the LIBPATH and PATH to point to the 64-bit directories, just prior to running...

Hi We're trying to create a dependancy table - where a user inputs a list of tablenames and the output displays a list of jobs where the table is being used... we could use the usage analysis tool - but for each table this would take allot of time I tried using the export method(as advised in this f...

Which are the tools available for quering on Universe Databse and for making reports out of Metadata?

Is there any mechanism to access Univers database(in both server or Parallel jobs).

Hi all, i am getting a strange error while using OPENSEQ Command in one routine. OPENSEQ '\home\dsa\a.txt' TO FILE ELSE ABORT. Even thought the file is existing it is going to Else part of it and aborting it. Did anyone got this error before? The above abort is intern raising the following error &q...

An OPENSEQ will take the ELSE clause if the file doesn't exist (this is normal behaviour and the file is opened) or if there is no ON ERROR clause and an error occurs. You should add error handling and also display the value of STATUS() to find out what is going wrong. Perhaps you don't have r ead ...

Hi all, i am getting a strange error while using OPENSEQ Command in one routine. OPENSEQ '\home\dsa\a.txt' TO FILE ELSE ABORT. Even thought the file is existing it is going to Else part of it and aborting it. Did anyone got this error before? The above abort is intern raising the following error &qu...