ODBCLINK/SE Reference Manual (36217-90410)

ODBCLink/SE Reference Manual Troubleshooting
ODBCLink/SE
©M.B. Foster Associates Limited 1995-2000 61
You should now be connected to the database. To see a menu of available commands, enter HELP:
0>HELP
SHOW Display tables and table structures
EXIT Exit program
SELECT SQL Select
FETCH SQL Fetch [ALL|##]
INSERT SQL Insert
UPDATE SQL Update
DELETE SQL Delete
SQL Execute immediate SQL command
COMMIT SQL Commit
PARAM Parameter substitution on a prepared statement
STMT Change current statement/cursor number
ROLLBACK SQL Rollback
EXECUTE Execute stored procedure
QUIT Exit program
FOREIGN Display foreign Keys
TABPRIV Display table privileges
0>
Enter the command you wish to use. For example, enter SHOW to see a list of available tables:
>show
Dataset/Table Database Type
MANUFDB.SUPPLYBATCHES partsdbe.sql.mbftest ALLBASE TABLE
MANUFDB.TESTDATA partsdbe.sql.mbftest ALLBASE TABLE
PURCHDB.PARTS partsdbe.sql.mbftest ALLBASE TABLE
PURCHDB.INVENTORY partsdbe.sql.mbftest ALLBASE TABLE
PURCHDB.SUPPLYPRICE partsdbe.sql.mbftest ALLBASE TABLE
PURCHDB.VENDORS partsdbe.sql.mbftest ALLBASE TABLE
PURCHDB.ORDERS partsdbe.sql.mbftest ALLBASE TABLE
PURCHDB.ORDERITEMS partsdbe.sql.mbftest ALLBASE TABLE
PURCHDB.PARTINFO partsdbe.sql.mbftest ALLBASE VIEW
PURCHDB.VENDORSTATS partsdbe.sql.mbftest ALLBASE VIEW
RECDB.CLUBS partsdbe.sql.mbftest ALLBASE TABLE
RECDB.MEMBERS partsdbe.sql.mbftest ALLBASE TABLE
RECDB.EVENTS partsdbe.sql.mbftest ALLBASE TABLE
To see the list of columns and indexes for a table, enter SHOW followed by the name of the table. For example:
>sho recdb.clubs
Field ODBC-Datatype HP-Datatype Length Offset Nulls
CLUBNAME CHAR(15) 15 0
CLUBPHONE SMALLINT 2 16 1
ACTIVITY CHAR(18) 18 20 1
Indexed field Index Type Index Name
CLUBNAME CONSTRAINT PRIMARY CLUBS_PK