DSXchange

Hi,

Is the package checked into subversion using Information server manager? Or the code is exported to particular path and checked into SVN?

Hi Experts, I have a task of deploying the datastage code from SVN, for which I have integrated Manager and SVN and comitted my codes to SVN. But facing below issues: 1. After deploying the code from SVN to the same region, the jobs are in not compiled state. 2. The SVN repositoy structure is HostNa...

Hi All, I cannot open any Execute Command stage in the sequencers. If i try opening the stage DS hangs. This has been happening for 2 days now. I have tried uninstalling and reinstalling the client, but it does not resolve the issue. Please guide me through this problem. Is there any patch for this?...

Hi All,

Where can one find the Port number of the datastage application that is installed on a server?

I am under the impression that the default port number is 31538. Is it the same for both Unix and Windows versions??


Thanks,

Hi,

Is there a way to get the job names and their scheduling details for an entire project??

The jobs are scheduled to run from the datastage director itself.


Thanks,
Sharad

Hi All,

I have used the OCI8TO9.B for the conversion of the oracle stages from OCI 8 to OCI 9.

How is the conversion process happening? i.e.,what is the internal process involved in the conversion of the stages??


Thanks in advance

Hi, I have a sequencer in which i wait for 19 files. Each file has its own set of jobs(multiple instance) to be triggered, independent of each other. The idea is that if file 1 arrives its set of jobs should be triggered irrespective of the presence of other files. But in my sequencer, even though f...

Hi,

Is the individual job completing successfully or finishing with a log in case of an error?

If the individual job exits with a log the job run status can be captured to identify the success of the script.

Hi, The error is thrown up only in the aggregator stage. The extract happens from a DB thru OCI and then a look up of the data is done. The process data are passed to an aggregator after which we get the error. The job runs for an hour and a half and aborts in the aggregator stage. We do not have an...

Hi All, I am stuck up with the same error. The log after resetting the job is, DataStage Job 297 Phantom 6020 Unhandled exception raised at address 0x1005AAD6 : Access violation Attempted to write to address 0x00000000 Aborting DataStage... Could someone tell me what could be the problem. The job de...

Hi,

Can you post in some more information of the error surrounding it?

This is could be a problem of the datatype from the source.

Hi,

I am not sure whether this will work out. Try converting the column using Iconv(col_name,"MCP"). This converts the non readable characters to "." a period.

EReplace to remove the "." period.

Regards,
Sharad

Thanks Craig.

The DSPrepareJob function did work as it was required Thanks again

Hi All, Is there a command equivalent to the sequence trigger option "Reset if required then run"?? I tried using the DSJ.RUNRESET option in the DSRunJob function,but the job is reset even if the previous run is a success. As an interim solution, the job status is captured and based on the...

Hi Vishal, To make multiple rows to the hashed file use composite key. But if the requirement is to have duplicate data in the hash file (which I presume will not be the case) then hash file cannot be of use. Also in the previous posts, there is a mention of not using keys in the lookups. Wondering ...