DSXchange

I think you are defining the user defined enviornment varible as parameters in the job also. check your job , dont pass the user defined enviornment variables as parameters in the job , pass the user defined enviornment varibles to only in sequencer and pass them inside the job activity . Please let...

Hi, I am using custom stage as input stage, i am using dsjob -report ProjectName JobName DETAIL command to get report, when i am executing the job , it is issuing the below warning message. Missing record delimiter "\n", saw EOF instead . I dont have any file format options in that custom ...

chulett wrote:No. S1 needs to notice that S2 aborted and then abort itself. ...

how can we implement that Chulett. how can i notice the S1 that s2 is aborted

Thanks

In the S1 sequence, use the a failed trigger from the JobActivity stage that runs the S2 sequence. The failed trigger can be connected to a TerminatorActivity stage, or to a RoutineActivity stage that calls DSLogFatal. The second argument of DSLogFatal() is just text that appears in the log. It doe...

hello all, I have a job design of a sequencer S1 in which i am using one parallel job J1 and one sequencer S2 (audit job +abort routine). incase the job J1 fail, i trigger the sequencer S2, which in turn call one audit job followd by abort routine. when i run the sequecer S1 , incase of failure of j...

Hello Archana, first you need to find out the latest job control event ID. you can use the below command dsjob -logsum -type STARTED -max 2 DSProj DSJobName it will give you two even id, just subtract them and use the result in the below command to get the count of warning messages in the current ru...

dsjob -logsum -type WARNING DSProjectName DSJobName | grep "WARNING" | wc -l

i used this command , but it is count the warning which generated in previous run also.

Thanks

Hi all,


I need to count the no of warning messages which present in the datastage director for the current job run.

Please suggest me some way to count the warning messages.

Regards

Hi I want to do some analyis on the log file and reject file which generated at the time of oracle load.

Please suggest me the path

deep

you cann't make the datastage job password protected, only can make it readonly if you use protected project, or if you promote the same job using version control project with read only permission . any one can access your job ,datstage dont have job level security setting.

I am also facing the same issue. Job is not prcessing any records and issuing the same warning messege.

Please help us to resolve it.

Regards,

Hi

I want to set the NLS_LANG -> AMERICAN.

Please suggest me the way to update it by using datastage
administrator client.

Regards

Hi

I am using the funnel stage to do the lookup with lookup stage. I have tested this with few source records and few reference records, now I want to know if I use the same lookup in production server the performance of the job will be good or bad?

find out all the phantom processes and kill all of them ,then try to run ur job

use #Passord# in the password box in the required stages..