Try OpenEdge Now
skip to main content
Multi-tenancy Overview
Multi-tenancy and OpenEdge SQL : SQL utility use cases : Loading tenant data as a super tenant or a DBA
 

Loading tenant data as a super tenant or a DBA

To load the data from a formatted file into all the tenant partitions of a multi-tenant table:
sqlload -u dbaUser -a dba -t mttab1 progress:T:localhost:9999:mtdb
For this operation, the user, dbaUser, must be mapped to a DBA or a super tenant.