DSXchange

hi gurus, i went to designer and copied the code of KEYMANAGEMENTGETNEXT VALUES and created a new routine and added lines to it. when i go to director i see the message 13:13:45: Job_Activity_0 (JOB job1) finished, status=1 [Finished OK] 13:13:46: Routine_Activity_1 (ROUTINE DSU.KeyMgtGetNextValue1)...

hi gurus, where should i use this function, i tried to add a column in the routines activity, plz help me where should i use this function. in this case JOB1-----> name of the job activity job3------>name of the sequence. functon format: LOG ERROR=DSlog Event(job1, DSJ.LOGINFO, SEQUENCE GENERATED,JO...

hi, what does status mean, how do we get value. actually i thought status is activity variable. but plz help me in understanding abt the variable status, guru said to hard cord the value of status, how can i hard cord. i know that these questions should be asked earlier itself, i was late in analyzi...

hi Gurus, thanks very much, i got a reply that we can attach the o/p of routine activity to transformer and get connected to sequential file or flat file. but here when used file--->open--->new sequencer job, i can't find transformer or flat file stages, how can i connect the o/p of routine activity...

hi, my design is jobactivity------>routine activity. iam calling keymanagement next value function in the routine activity. In routine activity tab. name value expression ARG1 'job1'. when i go to director, i can view the message, Routine activity started and finished, status=1, executed ok. if i wa...

hi gurus, thanks very much. user variable activity------>job1 nested conditional activity----->job1 user variable activity------>job2 ------>job2 i want to set the value of the variable status as 1. how can i set this. bz as soon as i give the nested condition as User Variable Activity.Status=1. it ...

HI GURUS, i have given sequence a name like job4. this is what iam able to view from the log of this job. JOB4 -> (job2): Job run requested Mode (row/warn limits) = 0/0 Job Parameters ---> DSJobController=JOB4. this is what iam getting. why is it not checking JOB1, its simply starting job2. cheers; ...

HI GURUS, THANKS VERY MUCH. actually when i used 'job1.$userstatus=1' i could validate the expression, but when i see the director log, its simply running the job2, it checking job2 initially, its saying since the result status is 1 finished executing job. is that the expected result, actually it sh...

Hi Gurus, thanks very much.iam only using nested condition. iam going by this design. nested condition--->jobactivity1---->jobactivity2. in the nested condition i have choosen expression type as CUSTOM-(CONDITIONAL) i have declared expression as if job1.$userstatus=1 then job1 else job2. while valid...

Hi gurus, i want to use variables in sequence. so used USER VARIABLE ACTIVITY.Actually i want to declare a variable called status and assign it value . if status =1 then job1 else job2. user variable activity---->jobactivity1---->jobactivity2. is my design correct, plz help me and how can i declare ...

hi,
THANKS VERY MUCH.
cheers;
vijay

hi gurus, thanks very much. i just wanted to analyze how that function works. i didn't make use of that in any one of my jobs wanted to see how this function works. i know its completely wrong to analyze in such a manner, i thought when u dig deep, u can make use of these functions whereever necessa...

hi gurus,
THANKS VERY MUCH.
where should i use this utility RUNJOB(jobname).
my design is ODBC--->TRANSFORMER--->ODBC.
plz help me

cheers;
vijay

hi gurus, my design is ODBC---->AGGREGATOR----->ODBC----->JOB1 i want to make use of aggregator o/p and give it as i/p to job2 . using aggregator stage iam calculating sum(sal). iam bulding up another job in which i want to add extra column called sum(sal) (ie) i want to make use of o/p from job1. i...

hi gurus, iam not creating a batch to run this job, iam just running the job normally. As gurus explained me that we shouldn't use this sub-routine to include in the job-properties of the same job which iam working on. its possible in the before -subroutine. my design is odbc--->transformer--->odbc ...