maya
.public
Tables
(current)
Columns
Constraints
Relationships
Orphan Tables
Anomalies
Routines
ot_rw_setjpodbus(integer)
Parameters
Name
Type
Mode
in_iddevice
integer
IN
Definition
/* to set the bus 1 = j1939, 2 = j1708 to extract EMS info de the DW */ DECLARE BEGIN PERFORM 1 from device d JOIN port p ON p.iddevice = d.iddevice JOIN serialcfg s ON s.idport = p.idport WHERE s.bus = 2 and d.iddevice = in_iddevice; IF FOUND THEN RAISE NOTICE 'Found'; ELSE RAISE NOTICE 'Not found'; END IF; RETURN true; END;