DSXchange

No Leo. Is there a specific directory that you need to write all sequential files in? In your earlier post, you mentioned that the value of the parameter needs to be the path where the target sequential file needs to be written. I put in the path but I still get the same error. According to the des...

Hi, I getting the below errors when running job(processing 5 million records) in DataStage 7.5.1A on GRID Production Environment: Unexpected termination by Unix signal 10(SIGBUS) Error in writeBlock - could not write 131063. When i restart from this job alone in the sequence job executes to completi...

Hi,

I am getting the below when running a job

" Fork failed: Not enough space" but when i retrigger the same job with out any change after the intial abort job runs successful.

I observed this behaviour for 4-5 runs

Job uses deduplicator,sort,aggregator, lkp

Any thoughts!

Hi, I am doing direct lookup to an oracle table (having userdefined Query with multiple unions) when i run the job with out giving bind variable "the first row value of lookup is repeated for the remaining rows". when i use a bind variable i am getting the following error "ORA-01036: ...

Hi,

In my after job routine i want to capture the status of my running job.
If the status code is any value other than 1 i want to abort the job.
How can i achieve this fuctionality in my after job routine.

Any help is appreciated

hi,

how to execute shell script from a basic routine.

I have a routine is doing a string comparision after that i want to execute a shell script.

How can i achieve this

kumar_s wrote:Hi,
Can you be bit more specific on what you need.
You can attache the job using job handler though DSAttachJob().

-Kumar

DSJ.ME gives me the current job handle but i want the previous job handle

Hw to get JobHandle for any job other than current job.

Hi,

How can i insert into Orcale table from a server routine
Any help is appreciated

Hi,

I want to write to an hash file from BASIC routine how can i achieve that .
Any help is appreciated

Hi all,


How can i pass the output(3 columns) of a job as parameters to other job.

Working on DS7.5 EE.

Hi,

Is DataSets DS7.5 EE equivalent to server HashFiles.

Hi,

Is DataSets in DS7.5 EE equivalent to server HashFiles .If not any other stage in DS 7.5 EE that have the functionality of Hashfiles.

HI, I have to select data from Fact and dimension table which appraoch is better.Is it Better to use a user defined sql (having decode,sum,groupBy,Orderby )having a join of Fact table and Dimension table which runs in to GB or do a simple select on the fact table and compare with dimesions as lookup...

Hi,

We are devloping jobs in DS EE 7.5 solaris.If i have to export all the jobs and test in windows 2000 server what are the things i have to look into.

what r the disadvantages of developing jobs in solaris version of DS EE 7.5 and run them on windows 2000 version of DSEE