DSXchange: DataStage and IBM Websphere Data Integration Forum
View next topic
View previous topic
Add To Favorites
This topic has been marked "Resolved."
Author Message
major



Group memberships:
Premium Members

Joined: 26 Nov 2007
Posts: 91

Points: 670

Post Posted: Thu Jul 29, 2010 12:22 am Reply with quote    Back to top    

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

Premium Poster
Participant

Group memberships:
Premium Members, Inner Circle, Australia Usergroup

Joined: 16 Nov 2004
Posts: 14022
Location: Germany
Points: 79230

Post Posted: Thu Jul 29, 2010 2:22 am Reply with quote    Back to top    

major wrote: ...vJob1 = """:vJob:"""... is syntactically incorrect, use Code: vJob1 = '"':vJob:'"' . Actually, that statement should be deleted, since the job ...

_________________
Image
Rate this response:  
Not yet rated
Display posts from previous:       

Add To Favorites
View next topic
View previous topic
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum



Powered by phpBB © 2001, 2002 phpBB Group
Theme & Graphics by Daz :: Portal by Smartor
All times are GMT - 6 Hours