Appendix B Creating a DBEnvironment

ODBCLink/SE Reference Manual

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 '/users/hpsql/sampledb/PartsDBE’; 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

74

©M.B. Foster Associates Limited 1995-2000

Page 84
Image 84
HP MPE/iX 6.x Operating System manual ODBCLink/SE