“Informix” SPL-funktion, Exempel

CREATE FUNCTION owner(company1 company, company2 company)RETURNING BOOLEAN;

DEFINE result BOOLEAN;DEFINE own_coll SET(company);

LET result = “false”;SELECT * INTO own_coll FROM company WHERE cname = company1;

IF company2 IN own_coll THEN LET result = “true”

ELSE FOREACH comp IN own_coll

IF owner(comp, company2)  THEN LET result = “true”

END FOREACH;

RETURN result;END FUNCTION

Previous slide

Next slide

Back to first slide

View graphic version