code=-4

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
Christina
Participant
Posts: 34
Joined: Wed Sep 06, 2006 11:50 am

code=-4

Post by Christina »

Hi,
i am using a routine in my sequence which will return date/count and i need to pass this as a parameter to the next activity. while testing the routine alone it is returning a correct value but while running through sequence i am getting the following error.

code=-4
[ParamValue/Limitvalue is not appropriate].

i am using a user variable activity to get value from this routine
chulett
Charter Member
Charter Member
Posts: 43085
Joined: Tue Nov 12, 2002 4:34 pm
Location: Denver, CO

Post by chulett »

It may look ok when testing, but it really isn't which is why you get the error. This is typically because of @FM characters in the returned value. Without knowing exactly what you are doing, a couple of suggestions:

1) Either take only the first element of the dynamic array by putting '<1>' at the end of your varaible name, i.e. VariableName<1>

2) Strip @FM from the value using EReplace(VariableName, @FM,"")

One of the two should solve your problem.
-craig

"You can never have too many knives" -- Logan Nine Fingers
ArndW
Participant
Posts: 16318
Joined: Tue Nov 16, 2004 9:08 am
Location: Germany
Contact:

Post by ArndW »

Craig - doesn't this also occur when you try to set an integer parameter to the value "Hello World"?
chulett
Charter Member
Charter Member
Posts: 43085
Joined: Tue Nov 12, 2002 4:34 pm
Location: Denver, CO

Post by chulett »

Sure. I made the assumption that the types are matching and it's not something really basic like that.
-craig

"You can never have too many knives" -- Logan Nine Fingers
Post Reply