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] *************************************
