Code: Select all
CREATE function getPersonDesgId(PersonID Integer)
Returns Integer
Language SQL
Contains SQL
Begin Atomic
Declare PDesgID Integer Default 0;
Set PDesgID = 0;
SELECT PDesgID, DesignId from Person Where PersonId =PersonID;
Return PDesgID;
End
//Error
Running
ADMINISTRATOR.GETPERSONDESGID - Deploy started.
Create user-defined function returns SQLCODE: -579, SQLSTATE: 42985.
ADMINISTRATOR.GETPERSONDESGID: 10: Routine "ADMINISTRATOR.GETPERSONDESGID" (specific name "ADMINISTRATOR.GETPERSONDESGID") attempted to read data but was not defined as READS SQL DATA or MODIFIES SQL DATA.. SQLCODE=-579, SQLSTATE=42985, DRIVER=3.66.46
Routine "ADMINISTRATOR.GETPERSONDESGID" (specific name "ADMINISTRATOR.GETPERSONDESGID") attempted to read data but was not defined as READS SQL DATA or MODIFIES SQL DATA.. SQLCODE=-579, SQLSTATE=42985, DRIVER=3.66.46
ADMINISTRATOR.GETPERSONDESGID - Deploy failed.
ADMINISTRATOR.GETPERSONDESGID - Roll back completed successfully.