Try OpenEdge Now
Multi-tenancy Overview
Multi-tenancy and OpenEdge SQL
:
Super tenant use cases
:
Update rows of a tenant partition
Update rows of a tenant partition
To update rows of a tenant,
SNCSoftware
, in a multi tenant table,
mtcustomer
:
UPDATE pub.mtcustomer
SET postalcode = '99999'
WHERE custnum = 1428 AND tenantName_tbl (pub.mtcustomer) = 'SNCSoftware';