DSXchange

Hi Chulett,
Thank you very much for you reply, I will try to work on all the options that you have specified and I will figure out the error.

Once again thank you very much for you explanation on triggers in Sequencer job.

Regards,
Vijay

Hi All, I found the answer for the issue... It sounds to be simply but its important to note the order of the triggers. The order of the triggers for my issue should be as follows. OnSuccess OnFailure and then UnConditional. If UnConditional is in between then the Unconditional trigger will not exec...

Hi, Here is the exact code: Stage Name is JobActivity Name ExpressionType Expression lnk_Success Custom-(Conditional) JobActivity.$JobStatus>=0 and JobActivity.$JobStatus<=2 lnk_Log Unconditional N/A lnk_Failure Failed-(Conditional) "ExecutionFailed" I am not typing anything under Trigger ...

Hi, To be more specific my job looks like this Job1 : ---->$JobStaus>=0 and $JobStatus <=2 ---> Job2 :----->(Unconditional)----> LogExtractRoutine(custom routine) :------>(On Failure)-------> Terminator Job2 : ---->$JobStaus>=0 and $JobStatus <=2 ---> Job3 :----->(Unconditional)----> LogExtractRouti...

Hi,
Here the issue is that the Unconditional trigger is getting triggered only when the Job runs successfully and it is not getting triggered when the Job fails.

Please refer to my initial post.

Regards,
Vijay

Hi, I have unchecked the checkbox and tried, but no use. I tried to remove the Terminator link and my sequencer is as follows: job1---->($JOBSTATUS >=0 and $JobSTATUS <=2)---Job2 -----> Unconditionla---->rouine When the job1 is aborted the routine is running fine but the sequencer is running success...

Hi, One of the trigger in a job sequence is not getting triggered in the following scenario: Job1 : ---->$JobStaus>=0 and $JobStatus <=2 ---> Job2 :----->(Unconditional)----> LogExtractRoutine(custom routine) :------>(On Failure)-------> Terminator In the above scenario if the job1 fails the LogExtr...

I am trying to do it in a Transformer stage using convert function.
I will check whether convert(char(10),' ',<mapping column>) will work or not.

Regards,
Vijay

Hi, One of the Oracle Field contains new line character as value. When I extract the field from Oracle database and write to a sequential file, a blank line is getting inserted after the record which contains newline character as the filed value. I want to replace the newline charcter in my output w...

Hi, Based on successful execution of a job I want to update an Oracle table. So I want to execute an update query in a new job which will be executed after the First Job. What is the best method to run the update query in a job(for all other jobs which reads data from Oracle I am using Oralce Enterp...

Ray,
NLS is not enabled on our DataStage. Is this might be the reason for the issue???

Ray, The table creation scripts shows it as Varchar2(50 CHAR). Is that Varchar2(50 CHAR) is equal to Varchar(200) in DS because of NLS_CHARCTERSET=ALT32UTF8 settings in Oracle?? If that is the case, then do DataStage process in terms of number of characters or in terms of number of bytes? My Down st...

I made a mistake in my first post, DataStage always thinks and works in terms of characters; but with NLS installed a character can be more than one byte. You declare VarChar(50) for a 50-character ... But If I declare it as Varchar(50) the job log shows warning message. Implict conversion from sou...

Vijay, The datatype you can use in DataStage is VarChar() and DataStage "thinks" in terms of characters unless you have NLS installed. ... ArndW, Do I need to declare Varchar2(50 CHAR) as Varchar(50) or Varchar(200) since NLS_CHARACTERSET=ALT32UTF8 and NLS_NCHAR_CHARCTERSET=ALT16UTF16 in ...

Hi, I require few clarifications in DataStage Data Types and Tranformer functionality 1) Which data type in DataStage represents Varchar2(CHAR)data type in Oracle? 2) will the data get truncated if we assign Varchar2(200) input field to Varchar2(50) output field in transformer stage and write the da...