Routine Issue

Post questions here relative to DataStage Server Edition for such areas as Server job design, DS Basic, Routines, Job Sequences, etc.

Moderators: chulett, rschirm, roy

Post Reply
vskr72
Premium Member
Premium Member
Posts: 128
Joined: Wed Apr 28, 2004 9:36 pm

Routine Issue

Post by vskr72 »

I am creating a simple routine in server environment. This work perfectly when I test with Manager. When I start calling it in a sequencer, it acts weird.

Initally I set the stage triggers based on the Return values 1 or 0. Then the routine does not trigger at all. It always used to fail.

Then, I modified the triggers as "OK Conditional" and "Otherwise". At that time the routine got triggerd and I could see only the log messages that I used in the Director. For some reason the file does not get created.

[code]FileName = dirwrk :'/' :dirwrk : '.xivpd508.GenIvp.WeeklyProdPlan'

Call DSLogInfo("Testing Log: " : FileName,"TestDir")

CmdCDArc = ivpDirOutgng : '/' : FileName


Call DSExecute("UNIX", "touch ": CmdCDArc, Output, SystemReturnCode)


Call DSLogInfo("Testing Log: " : CmdCDArc,"TestDir")


If SystemReturnCode = 0 Then
Ans = '1'
Return(Ans)
End Else
Ans = '0'
End [/code]
Any suggestions??

Satish
Last edited by vskr72 on Fri Nov 03, 2006 8:39 am, edited 1 time in total.
narasimha
Charter Member
Charter Member
Posts: 1236
Joined: Fri Oct 22, 2004 8:59 am
Location: Staten Island, NY

Post by narasimha »

What are the arguments you are passing to this Routine?

If your Routine worked correctly in the Manager then the triggers should work fine with its return values in the sequence

Can you edit your post (Format and enclose in Code).

Easier to point out the problem better with these information
Narasimha Kade

Finding answers is simple, all you need to do is come up with the correct questions.
ray.wurlod
Participant
Posts: 54607
Joined: Wed Oct 23, 2002 10:52 pm
Location: Sydney, Australia
Contact:

Post by ray.wurlod »

Try

Code: Select all

Call DSLogInfo("Testing Log: " : CmdCDArc : @FM : Output,"TestDir") 
to work out exactly what's happening.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Post Reply