maya
.public
Tables
(current)
Columns
Constraints
Relationships
Orphan Tables
Anomalies
Routines
ot_rw_gen_devmessageid()
Parameters
Name
Type
Mode
Definition
/* v20151130 RRB To generate a message sequence to be used by gnx and fs v3 routes*/ DECLARE upperlimit int; _idmodeldevice int; BEGIN /* There are a set of devices that don't require resequencing (devices used for testing) */ PERFORM 1 FROM device d JOIN tmp.noresequence n ON d.serialnumber = n.serialnumber WHERE d.iddevice = NEW.iddevice; IF FOUND THEN RETURN NEW; END IF; /* For all remaining devices resequence if they are gnx or calamp */ upperlimit := 65535; SELECT idmodeldevice into _idmodeldevice FROM device d WHERE iddevice = NEW.iddevice; IF _idmodeldevice IN (1,4) THEN NEW.devmessageid := NEW.idmessage % upperlimit; END IF; RETURN NEW; END;