Try OpenEdge Now
skip to main content
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';