%Library.SQLAPI
hidden class %Library.SQLAPI extends %Library.RegisteredObject
This is a system class that allows control of the Cache SQL environment.Used by SQL Manager.
Method Inventory
- AddUser()
- AltUser()
- CheckFileReadOnly()
- CheckIdentifier()
- CheckPriv()
- CheckRoutine()
- ChkChr()
- ChkClassName()
- ChkIndices()
- CreateLinkTable()
- CreateRole()
- DropTable()
- DropUser()
- FindClassName()
- GetCachedQueryInfo()
- GetDatatype()
- GetDays()
- GetDrives()
- GetPassword()
- GetQueryHistory()
- GetServerPlatForm()
- GrantRole()
- HasGrPriv()
- HasPriv()
- HasRvPriv()
- KillQueryHistory()
- OpenClassDefinition()
- PurgeAllQueries()
- PurgeQueriesForTable()
- PurgeQuery()
- RebuildIndices()
- RevokeRole()
- SQLLogin()
- SaveObjPriv()
- SaveQueryHistory()
- SaveSysPriv()
- SetServerInitCode()
- TableInfoClose()
- TableInfoExecute()
- TableInfoFetch()
- ValidUser()
Methods
Returns true or false.
Check each property name. If the property name is a reserved word,
then set appropriate delimited identifier around it.
The propertylist will be updated and returned.
Parameters:
Create a new table from TableLink Wizard based on external datasource Parameters: dsn - Datasource connection name tname - table names delimited by ^ external table name ^ new table name (user can modify) cols - for each field delimited by @ external column name^column caption^iType^iMaxLen^iPrecision
Parameters: droptype - "TABLE" for table, "VIEW" for view tablename - name of the table to delete (required) SQLCODE - Passed by reference. Returns SQLCODE contains 0 (success) or number < 0 (error) %msg - Passed by reference. If SQLCODE<0, contains error message.
Parameters: user - user or role name to be dropped droptype - "USER" or "ROLE" SQLCODE - Passed by reference. Returns SQLCODE contains 0 (success) or number < 0 (error) %msg - Passed by reference. If SQLCODE<0, contains error message.
Returns a string containing the query text for the cached query. Returns the create and last prepare times by reference.
Source indicates that there is source for the routine and QueryType indicates whether it is a ODBC query or a Dynamic query.
NOTE: LastPrepareTime is obsolete and will not be set
Return a Caché datatype based on an ODBC datatype Parameters: name - Character or integer ODBC type precision - ODBC precision scale - ODBC scale parms - array, passed by reference, which will be filled with parameters
Return Days Before Purge value. Use value set for this namespace if it exists, else use server setting.
Returns a string containing all the available drives.
Given a user name, return the user's password. Return null if nothing is found.
Get the next query text searching backwards or forwards depending on direction given and the base point is the current index location. Parameters: glbIndex - The global index for this SQLMgr session. If it's not greater than 1 then set it and return. currentIndex - where we are in the history list, refence updated. direction - search direction (forward = 1, backward = -1) atend - at the top = -1, at the bottom = 1, in the middle = 0 QueryText - Passed by reference. If it's not null when passed in, then save it. At the end, return array with all history.
Returns a string containing the server name, current directory and the platform (VMSDSM, WIN, UNIX, VMS, or DSM).
Parameters: Username - the login name Privs - a list of privileges in the form of 1 or 0 seperated by commas
Parameters: Username - the login name Privs - a list of privileges in the form of 1 or 0 seperated by commas Admin flag - 0 or 1 for GRANT system privileges.
Parameters: Username - the login name Privs - a list of privileges in the form of 1 or 0 seperated by commas
Kill of QueryHistory upon exiting from SQL Manager. Parameters: glbIndex - The global index for this SQLMgr session. If it's not greater than 1 then set it and return.
The caller is responsible for closing the returned object.
Parameters: acts - actions to grant. * for all actions a for Alter s for Select i for Insert u for Update d for Delete r for References or any combination type - "1" for table, "3" for view objs - name of the table or view users - comma delimited list of users g - 0/1 for WITH GRANT OPTION revoke - 1 if revoke (-1 otherwise) SQLCODE - Passed by reference. Returns SQLCODE contains 0 (success) or number < 0 (error) %msg - Passed by reference. If SQLCODE<0, contains error message.
Parameters: glbIndex - The global index for this SQLMgr session. If it's not greater than 1 then set it and return. QueryText - Passed by reference. If it's not null when passed in, then save it. At the end, return array with all history.
Queries
Inherited Members
Inherited Methods
- %AddToSaveSet()
- %ClassIsLatestVersion()
- %ClassName()
- %ConstructClone()
- %DispatchClassMethod()
- %DispatchGetModified()
- %DispatchGetProperty()
- %DispatchMethod()
- %DispatchSetModified()
- %DispatchSetMultidimProperty()
- %DispatchSetProperty()
- %Extends()
- %GetParameter()
- %IsA()
- %IsModified()
- %New()
- %NormalizeObject()
- %ObjectModified()
- %OriginalNamespace()
- %PackageName()
- %RemoveFromSaveSet()
- %SerializeObject()
- %SetModified()
- %ValidateObject()