HP MPE/iX 6.x Operating System Display tables and table structures, Exit program, SQL Select

ODBCLink/SE Reference Manual Troubleshooting

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	Database	Type
Dataset/Table
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	1
CLUBPHONE	SMALLINT	2	16
ACTIVITY	CHAR(18)	18	20	1
Indexed field	Index Type	Index Name
CLUBNAME	CONSTRAINT PRIMARY	CLUBS_PK

ODBCLink/SE
©M.B. Foster Associates Limited 1995-2000	61