Appendix B Creating a DBEnvironment | ODBCLink/SE Reference Manual |
⊗Plan the security structure of the DBEnvironment. Decide which users will be granted access to the DBEnvironment, databases within the DBEnvironment, and tables within the databases.
⊗Create the account where the DBEnvironment is to reside.
⊗Grant authorizations to users who will be using the test DBEnvironment.
⊗Create the DBEnvironment, including databases and tables.
After you setup the DBEnvironment, ensure that you can connect to it. For example,
: isql
isql=> CONNECT TO 'PartsDBE.SomeGrp.SomeAcct'; isql=> SELECT * FROM SYSTEM.TABLE;
:
At this point you should see the system table information.
:
U[p],d[own],l[eft],r[ight],t[op],b[ottom],pr[int]<n>,or e[nd]
>e;
isql=> exit;
| ODBCLink/SE |
72 | ©M.B. Foster Associates Limited |