function
|
SQLTablePrivileges
|
|
Library: omodbc - low-level ODBC support
Include: omodbc.xin
|
Return type: Integer
Returns: An SQL return code. The following values may be returned:
- SQL_SUCCESS (the list was successfully generated).
- SQL_SUCCESS_WITH_INFO (the list was successfully generated, but a message was issued).
- SQL_ERROR (an error occurred).
- SQL_INVALID_HANDLE (the handle is invalid).
- SQL_STILL_EXECUTING (the program is still executing).
|
Declaration define external integer function SQLTablePrivileges
( read-only SQL_handle_type StatementHandle,
value stream CatalogName,
value integer NameLength1,
value stream SchemaName,
value integer NameLength2,
value stream TableName,
value integer NameLength3 )
Purpose
Returns a list of tables, and the privileges associated with each. The information is returned as a result set on the specified statement.
Input arguments:
- StatementHandle.
- CatalogName. If a driver supports catalogs for some tables but not others, such as when the driver retrieves data from different DBMSs, an empty string ("") denotes tables without catalogs. CatalogName cannot contain a string-search pattern.
- NameLength1. The length of CatalogName.
- SchemaName. A string-search pattern for schema names. If a driver supports schemas for some tables but not others, such as when the driver retrieves data from different DBMSs, an empty string ("") denotes tables without schemas.
- NameLength2. The length of SchemaName.
- TableName. A string-search pattern for table names.
- NameLength3. The length of TableName.
Generated: August 11, 2000 at 3:08:01 pm
If you have any comments about this section of the documentation, send email to docerrors@omnimark.com
Copyright © OmniMark Technologies Corporation, 1988-2000.