Try OpenEdge Now
skip to main content
Multi-tenancy Overview
Multi-tenancy and OpenEdge SQL : Super tenant use cases : Insert rows into a multi-tenant table
 

Insert rows into a multi-tenant table

To insert a new row in a tenant partition of the tenant, SNCSoftware, in the multi-tenant table, mtcustomer:
INSERT INTO pub.mtcustomer TENANT SNCSoftware
(custnum, name)
VALUES
(9999, 'West Side Sports');