DSXchange

Can you post the text from your constraint link and hopefully you dont have the rejects checked for any of the links above.

We had this issue and it was resolved by replacing the OCI stage with ODBC stage try using that

I am getting an abnormal termination of stage and when I do a reset of the Aborted job this is what I get "From Previous Run" ------------------------------------------------------------------------------------ From previous run DataStage Job 1833 Phantom 21779 Abnormal termination of Data...

Thanks Ray I was able to get what I wanted but not 100%, when i use the Reporting Assistant in the DsJobs table I only see the "Server" jobs but none of the "Job Sequencer" where in reporting Assistant would I find the listing of the sequencers

TIA

I have to compile a list of all the jobs and the transformations in the job is there any simple way of achieving this ?

DS_JOBS will give me the names of all the jobs in the PROJECT but how do I get the transformations in the job ?

Any IDEA/thoughts

Thanks

Thanks KC will try that. Would you know what this message means ? ##W TFPA 000002 21:57:49(006) <main_program> Warning: the value of the PWD environment variable (/) does not appear to be a synonym for the current working directory (/export/interface/etldata/CMIS/project). The current working direct...

I am using the same file with the same table definition on a server job and it works fine.

Is there any special precaution to take while importing a Server Job Table Defn into a Paralell Job ?

Thanks

I am trying to code my first Paralell job what I am trying to do is simply read from a flat file and write out to a flat file. The job is simply 2 Sequential File Stages and one transformer stage. When I try to view data I get the following warning message from the DataStage Repository Interface &qu...

I have a Sequential file, and I'm unable to view the data. The error message I get when I click "view data" is " Error executing View Data command: ##E TOIX 000016 13:58:47(0001) <Filename.Link> Error when checking operator: Import validation failed:" Any suggestions on what to d...

Is there anyway to do documentation of the Existing DataStage jobs I have seen the Manager's -> Reporting Assistant what I am more interested in is something that can give me a flow of logic like a flowchart.

Thanks

Check the decimal precision of the numeric value too

Congrats Ken on the new arrival that's quite a good average you have :D

Jim It's all in the documentation for Link Collector Stage.

Here is what you need to do

Goto the Job Properties

1. Click on the Performance Tab
2. Un-check the "Use project defaults
3. check the "Inter Process" radio button.

Re- compile your job.

All the best.

Could you post the warning message too ?