maya
.public
Tables
(current)
Columns
Constraints
Relationships
Orphan Tables
Anomalies
Routines
ot_rw_ovmrecon_inactivestatus()
Parameters
Name
Type
Mode
serialnumber
character varying
OUT
Definition
DECLARE BEGIN DROP TABLE IF EXISTS t; CREATE TEMPORARY TABLE t (serialnumber varchar, ns_servicestatus varchar); COPY t FROM '/db/ovm_recon/reason_servicestatus.csv' header csv; return query UPDATE device d SET status = 2, enabled = true FROM t WHERE t.serialnumber = ltrim(d.serialnumber,'0') AND t.ns_servicestatus = 'Inactive' RETURNING d.serialnumber; END;