Progress
Language Reference


DBTYPE Function

Interfaces
OS
SpeedScript
All
All
Yes

Returns, as a character string, the database type of a currently connected database. Database types include the following: Progress, ODBC, and ORACLE.

SYNTAX

DBTYPE ( integer-expression | logical-name | alias ) 

integer-expression

The sequence number of a database the Progress session is connected to. For example, DBTYPE(1) returns information on the first database the Progress session is connected to, DBTYPE(2) returns information on the second database the Progress session is connected to, etc. If you specify a sequence number that does not correspond to a database the Progress session is connected to, the DBTYPE function returns the unknown value (?).

logical-name or alias

These forms of the DBTYPE function require a quoted character string or a character expression as a parameter. An unquoted character string is not permitted. If the parameter is an alias of a connected database or the logical name of a connected database, then Progress returns the database type. Otherwise, it returns the unknown value (?).

EXAMPLE

This procedure displays the logical name and database type of all connected databases.

r-dbtype.p
DEFINE VARIABLE i AS INTEGER.
REPEAT i=1 TO NUM-DBS:
  DISPLAY LDBNAME(i) DBTYPE(i) FORMAT "x(40)".
END. 

SEE ALSO

ALIAS Function, CONNECT Statement, CONNECTED Function, CREATE ALIAS Statement, CREATE DATABASE Statement, DATASERVERS Function, DBCODEPAGE Function, DBCOLLATION Function, DBRESTRICTIONS Function, DBVERSION Function, DELETE ALIAS Statement, DISCONNECT Statement, FRAME-DB Function, LDBNAME Function, NUM-DBS Function, PDBNAME Function, SDBNAME Function


Copyright © 2004 Progress Software Corporation
www.progress.com
Voice: (781) 280-4000
Fax: (781) 280-4095