DSXchange

Hi,

I have to develop the job sequence which checks in the dependency with the first job data.

I have only two jobs in my sequence.

Job A loads the data in to table. If count is more then 0 in the table then only i have to run job B otherwise I have to quiet from sequence.

Please suggest

But when we will change the seting in DataStage level that will be applicable for all the projects.Please correct me if i am wrong.

We want to use NLS functionality in some other project .

We don't want to use NLS functionality for prticular project.please suggest how we can disable the same.

I am able to do it in job level. i have change in the job property

default map to the stage :- NONE
default locale category :- default.

Please suggest how we can do the same in project level.

We have upgraded our server edition from 7.5 to 7.5.2. What is the difference between these two versions? We have checked all the possibilities suggested by chulett and ray but did't get nay set up difference with our existing system. We have the prob only with whenever we are calling the oracle seq...

We have upgraded our server edition from 7.5 to 7.5.2. What is the difference between these two versions? We have checked all the possibilities suggested by chulett and ray but did't get nay set up difference with our existing system. We have the prob only with whenever we are calling the oracle seq...

We have upgraded our server edition from 7.5 to 7.5.2. What is the difference between these two versions? We have checked all the possibilities suggested by chulett and ray but did't get nay set up difference with our existing system. We have the prob only with whenever we are calling the oracle seq...

surprisingly the same job is working fine in our old machine .but when we are trying to run in our new machine it's hanging. what i found is all the job where we are using oracle sequence through oracle OCi stage is giving the prob.

(BDW_Driver) <- BDW_Load_Customers: Job under control finished. From previous run DataStage Job 17 Phantom 22194 *** glibc detected *** free(): invalid pointer: 0xfffd2930 *** Abnormal termination of DataStage. Resetting Job BDW_Load_Customers. Fault type is 6. Layer type is BASIC run machine. Fault...

Job name:BDW_Load_Customers Message: BDW_Load_Customers: Set NLS locale to US-ENGLISH,US-ENGLISH,US-ENGLISH,US-ENGLISH,US-ENGLISH Project:Premium_Service_DM (etl7.data.corp.sp1) Job name:BDW_Load_Customers BDW_Load_Customers..t1xfmLoadSIDS: DSD.StageRun Active stage starting, tracemode = 0. BDW_Load...

SELECT BDW_CUST_SID2_SQ.NEXTVAL FROM DUAL we are calling the above select statement in the oracle OCi stage.We are able to view the data from oracle stage where we are using this sequence. For any new record ,we are giving the new sequence no from the above statement. But the same job is running fin...

Hi,

We have migrated our datastage jobs from one machine to another machine.all the jobs are working fine but the jobs where we are using ORACLE SEQUENCE that job is hanging and finally aborting.

Can you please suggest,what needs to be done.

Our DataSatge server installed in unix box. and they have created the headless accounts.

I want to associate those headless account to the projects.Can u please sugest what are steps to associte these headless account to the projects and how to set the password for those account.

Hi

By writing fatal/warning/info entries in the sub sequence log about underlying job status, will that information avaiable to the main sequence?, if so how?

And also I want by writing either of the fatal/warning/info into subsequence, I dont want to abort that sub sequence.


Thanks
Sai

we have many projects.for one projects i want to create the location in different machine itself.is it possible??

Hi ,

I am trying to create my project in different location. while trying to add the ptoject i am getting the following error 'DSR.ADMIN: The project location is invalid.'

I am not using the default directory /home/dsadm/Ascential/DataStage/Projects.