To resolve my problem I needed to save the parameter passed in a variable first and then use this variable instead of the parameter.
CREATE FUNCTION ISEMPLOYEEINCONTEXT (COMPANYID FIXED(9,0), HUMANRESOURCEID FIXED(9,0), DSTARTCHR TIMESTAMP) RETURNS NUMBER AS VAR RES INT; APPO TIMESTAMP; TRY APPO = DSTRARTCHR; SELECT 1 INTO :RES FROM PSF.COMPANY_HUMAN_RESOURCE A WHERE DATE(:APPO)=DATE(A.D_START); RETURN RES; CATCH IF $RC <> 100 THEN STOP($RC,$ERRMSG) ELSE RETURN 0; // Thanks for your support anyway. Bye, Matteo ----- Original Message ----- From: "Matteo Gattoni" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Thursday, June 17, 2004 1:04 PM Subject: using TIMESTAMP > Hello, > I have the following procedure (in reality, mine is a bit more complex, > but this is usefull). > > DROP FUNCTION ISEMPLOYEEINCONTEXT > // > CREATE FUNCTION ISEMPLOYEEINCONTEXT (COMPANYID FIXED(9,0), HUMANRESOURCEID > FIXED(9,0), > DSTARTCHR TIMESTAMP) RETURNS NUMBER AS > VAR RES INT; > TRY > SELECT 1 INTO :RES > FROM > PSF.COMPANY_HUMAN_RESOURCE A WHERE > DATE(:DSTARTCHR)=DATE(A.D_START); > RETURN RES; > CATCH > IF $RC <> 100 THEN STOP($RC,$ERRMSG) > ELSE RETURN 0; > // > GRANT EXECUTE ON PPORTAL_PERMISSION.ISEMPLOYEEINCONTEXT TO PSF > // > GRANT EXECUTE ON PPORTAL_PERMISSION.ISEMPLOYEEINCONTEXT TO PPORTAL > // > > When i use it in a select like this > > select ISEMPLOYEEINCONTEXT(1, 200046, D_START) from > PSF.COMPANY_HUMAN_RESOURCE > I receive th error > > General error;-9111 POS(1) System error: Move error. > > It's seems that I have problems with timestamp convertion or something like > that. > > What could I do? > > Thank! > > Matteo > > > ************************************* > Matteo Gattoni > ICTeam S.p.A. > Via Azzano S.Paolo, 139 > 24050 GRASSOBBIO (BG) > Tel.: +39 035 4232156 > Fax: +39 035 4522034 > e-mail: [EMAIL PROTECTED] > ************************************* > > > -- > MaxDB Discussion Mailing List > For list archives: http://lists.mysql.com/maxdb > To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] > > -- MaxDB Discussion Mailing List For list archives: http://lists.mysql.com/maxdb To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
