User`s guide

Retrieving Object Properties Using the get Function
6-71
Property Value
'Type' Object type, specifically Database Object.
'URL' For JDBC connections only, the JDBC URL object
jdbc:subprotocol:subname, as specified by database.
'UserName' User name required to connect to a given database, as
specified by database.
'Warnings' Warnings returned by database.
You cannot use the get function to retrieve the password property.
Cursor Objects
Allowable property names and returned values for cursor objects appear in the following
table.
Property Value
'Attributes' Cursor attributes. This field is always empty. Use the
attr function to retrieve cursor attributes.
'Data' Data in the cursor object data element (the query
results).
'DatabaseObject' Information about a given database object.
'RowLimit' Maximum number of rows returned by fetch, as
specified by set.
'SQLQuery' SQL statement for a cursor, as specified by exec.
'Message' Error message returned from exec or fetch.
'Type' Object type, specifically Database Cursor Object.
'ResultSet' Resultset object identifier.
'Cursor' Cursor object identifier.
'Statement' Statement object identifier.
Note: If you specify a value (in seconds) for the timeout
argument, queries time out after the time exceeds the
given value.