ODBCLINK/SE Reference Manual (36217-90410)

Appendix B Creating a DBEnvironment ODBCLink/SE Reference Manual
ODBCLink/SE
72 ©M.B. Foster Associates Limited 1995-2000
⊗ 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;