Icon ODBC Interface - Function Reference

dbproduct()

Description: returns information about the DBMS accessed by the driver

Syntax: dbproduct(f)

Parameters:

f: ODBC file previously opened with open()

The return type is a record with the following fields:

"name": DBMS product name
"ver": DBMS version

Code Example

procedure main()
 f:=open("mydb","O","test","fbalbi","mypasswd") # open a table

 p:=dbproduct(f) # get DBMS product information

 write("product name: ", p["name"]) # print product name
 write("product ver : ", p["ver"])  # print product version

 close(f) # close table
end