how to use routine?

[qutesanju]

I have written a routine
to get records passed from that stage
for auditing purpose,but how can use this routine?

I know in master SEQ i can call the routine,but not exactly sure where and how to use this routine?

My requirement is to write a routine and get count ,Write counts to a seq/flatfile

routine is as below

$INCLUDE DSINCLUDE JOBCONTROL.H

Equate RoutineName to 'StageRowCount'
Handle = DSAttachJob ("JobName", DSJ.ERRNONE)
Count = DSGetLinkInfo(Handle, "StageName", "LinkName", DSJ.LINKROWCOUNT)
Ans = Count

[rameshrr3]

you can include it either in a routine activity stage ( use custom trigger in the activity o/p link) or , what may work better is to use an user variables activity - In case you need to pass the output of this routine to another downstream activity .

[qutesanju]

I know I can access routine into seq job at the end using routine activity.

but how to modify it to write the counts into a file?
I'm newbie for routine ,so not sure how to call and use routine

[SURA]

My requirement is to write a routine and get count ,Write counts to a seq/flatfile

1. To know how many records to that file alone?

If you use the link to get the counts may not be correct all the times. If the records got rejected due to any reasons may not be reflect in the link.

Rather than that, you can use a wc -l kind of OS command to get the number of records in the file.

Code: Select all

FileName ="FILEPATH"
CMD = "wc -l" : FileName : " > filename.txt"
Command = CMD
SystemReturnCode = 0
Call DSExecute (Shell, Command, Output, SystemReturnCode)

I havent tested this code as i typed in notepad.