regarding routine activity

[vijaykumar]

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 want to see the o/p data is it possible to view data from sequence.
since i have called the routine , i want to see the sequence numbers generated, is it possible from sequence, is there any way to see the sequence numbers generated.plz help me gurus

cheers;
vijay

[y_suresh]

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 want to see the o/p data is it possible to view data from sequence.
since i have called the routine , i want to see the sequence numbers generated, is it possible from sequence, is there any way to see the sequence numbers generated.plz help me gurus

cheers;
vijay

Where are u using the generated values .. you can add this in ur job transformer out put to Flat File and see as view data .

[I_Server_Whale]

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 want to see the o/p data is it possible to view data from sequence.
since i have called the routine , i want to see the sequence numbers generated, is it possible from sequence, is there any way to see the sequence numbers generated.plz help me gurus

cheers;
vijay

I guess some things are just incorrigible.

No, you cannot view data in a "job sequence".

[DSguru2B]

Inside the routine you can use DSLogEvent() function to spit out the value of KeyMgtGetNextValue() to the job sequence's log.

[narasimha]

I guess some things are just incorrigible.

I guess Whale is referring to this postwhere he took the pain to format your post.

Please format your posts properly and use proper case.
Make it more readable!

[vijaykumar]

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 to falt file, is it possible , plz gurus help me.

cheers;
vijay

[narasimha]

There is no sequential file stage in a Job Sequence.
Why not do a little research on what DSGuru2b said about the DSLogEvent() function

[vijaykumar]

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,JOB1).
plz help me where should i specify the function and is my format of the function used correct.

plz help me gurus.

cheers;
vijay

[kris]

Not sure why do you want to see it from Job Sequence, but If you are interested only in seeing what the current sequence number is:

You can see all the entrees in SDKSequences from a hashed file stage view. Put a hashed file stage on a server job diagram window, In outputs page configure file name to SDKSequences and enter 2 columns(names doesn't matter) seed_name and seed_value and view data.

You can query SDKSequences hashed file from DataStage Administrator command interface too. Search on SDKSequences should give you enough info.

Kris~

[DSguru2B]

inside your routine. Add a line at the end. Something like

Code: Select all

val=KeyMgtGetNextValue('MyJob1') 
EventMsg="The sequence value is :":val
Call DSLogEvent(DSJ.MET, DSJ.LOGINFO , EventMsg)
Ans=Val

[vijaykumar]

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) started

13:13:46: Exception raised: @Routine_Activity_1, BASIC routine is not cataloged: DSU.KeyMgtGetNextValue1
iam getting error BASIC ROUTINE IS NOT CATALOGED.

plz help me gurus

cheers;
vijay

[I_Server_Whale]

hi gurus,
i went to designer and copied the code of KEYMANAGEMENTGETNEXT VALUES and created a new routine and added lines to it.

vijay

WHAT LINES DID YOU ADD? YOU NEED TO MENTION THAT AS WELL.

[DSguru2B]

Did you compile your routine. Did you test it out before using it in the job?

[vijaykumar]

HI,
i created new routine, i just copied the code of KEYMANGEMENTNEXTVALUE, re-named as keymgtnextvalue1 and added extra lines like

val=KeyMgtGetNextValue('job1')

EventMsg="The sequence value is :" :val

call DSLogEvent(DSJ.MET,DSJ.LOGINFO,EventMsg)

Ans=val.

i didn't write arguements.
iam compiling the server routine, iam getting error, referenced by another component.
keymgtgetnextvalue-no object code produced.

cheers;
vijay

[ray.wurlod]

i want to see the sequence numbers generated, is it possible from sequence, is there any way to see the sequence numbers generated.plz

From sequence, no.

There is no View Data capability in a job sequence.