| Author |
Message |
major

Group memberships: Premium Members
Joined: 26 Nov 2007
Posts: 91
Points: 670
|
|
| DataStage® Release: 7x |
| Job Type: Parallel |
| OS: Unix |
|
Hi all,
I have a Job sequence , i need to get the link count for reject file and if is 0 then i need to run the next activity else i need to send an email
For this purpose i wrote a routine to get rowcount RoGetLinkCount
In the triggers of job activity i put like RoGetLinkCount("ToRejectFile","Funnel","J002HeaderFooterValidation") = 0
for triggering next activity and
RoGetLinkCount("ToRejectFile","Funnel","J002HeaderFooterValidation") > 0
for sending email.
the code for routine is as below
| Code: |
$INCLUDE DSINCLUDE JOBCONTROL.H
vJob1 = """:vJob:"""
hJob1 = DSAttachJob (vJob, DSJ.ERRFATAL)
vLinkCnt = DSGetLinkInfo(hJob1,vStage,vLink,DSJ.LINKROWCOUNT)
vErrC = DSDetachJob(hJob1)
Ans = vLinkCnt |
the above routine is perfectly working
when i try to compile the job sequence i get the below compilation error
| Code: |
Compiling: Source = 'RT_BP94/JOB.1711265549.DT.1554838280', Object = 'RT_BP94.O/JOB.1711265549.DT.1554838280'
************************************************************************************************************************************?********************************************************************
0296 If (RoGetLinkCount("ToRejectFile","Funnel","J002HeaderFooterValidation") > 0) Then GoTo L$V9S0$START
^
',' unexpected, Was expecting: '!', ')', '=', "AND", "OR", "LT", "LE",
"GT", "GE", "NE", "EQ", "MATCH"
0298 If (RoGetLinkCount("ToRejectFile","Funnel","J002HeaderFooterValidation") = 0) Then GoTo L$V0S2$START
^
',' unexpected, Was expecting: '!', ')', '=', "AND", "OR", "LT", "LE",
"GT", "GE", "NE", "EQ", "MATCH"
Array 'RoGetLinkCount' never dimensioned.
3 Errors detected, No Object Code Produced.
(SeqTradeFileValidations) |
Please help me in fixing this.
Many thanks,
|
|
|
|
|
 |
ArndW
Participant
Group memberships: Premium Members, Inner Circle, Australia Usergroup
Joined: 16 Nov 2004
Posts: 14022
Location: Germany
Points: 79230
|
|
|
|
|
|
|
major wrote:
...vJob1 = """:vJob:"""...
is syntactically incorrect, use
Code:
vJob1 = '"':vJob:'"'
.
Actually, that statement should be deleted, since the job ...
|
_________________
|
|
|
|
 |
|
|
|