Regular tenant use case (accessing data)
After connecting to an OpenEdge database as a regular tenant, accessing data is unchanged.
Connect to an OpenEdge database as a regular tenant, regular_tenant, using the SQL explorer tool:
|
sqlexp -user regular_tenant@DomainOne -password abcd -db sports3000 -S 1234 -H localhost
|
Access data from a multi-tenant table, mtcustomer, as shown:
|
SELECT * FROM Pub.mtcustomer;
|
The above select statement returns the column values only from the rows in the regular_tenant partition.
