Error getting value from a routine

lakshya · Post by **lakshya** » Tue May 10, 2005 11:03 am

Hi all,

I have a routine that gets a timestamp from a sequential file and this timestamp is used in the next activity where we are comparing it with another field that is a timestamp.The routine is returning a value
MaxTS= 2005-04-29 15:41:46.000000,but i am getting the following error.

AX..JobControl (@Job_Activity_6): Controller problem: Error calling DSSetParam(MaxTS), code=-4
[ParamValue/Limitvalue is not appropriate]

I tried changing the datatype to string as well,but the error is the same.
Anyone has a solution for this?

Thanks in advance

ArndW · Post by **ArndW** » Tue May 10, 2005 11:08 am

This might be superfluous, but you do need to recompile the job to change the parameter type so that a DSSetParam uses the new type. I think you might not have done this, as a type of string doesn't generate that error message.

chulett · Post by **chulett** » Tue May 10, 2005 11:18 am

Timestamps (as a DataStage data type) don't support milliseconds. And as Arnd noted, if you succeeded in changing the type to a string in all of the appropriate places, it would stopped throwing the error.