SQL Member List

This is the complete list of members for SQL, including all inherited members.

ABS(_.Library.String val)	SQL	static
ALPHAUP(_.Library.String stringexp)	SQL	static
CancelQuery(_.Library.String pid, _.Library.Integer SQLStatementID, _.Library.Integer timeout)	SQL	static
CEILING(_.Library.String val)	SQL	static
CheckPriv(_.Library.String Username, _.Library.String Object, _.Library.String Action, _.Library.String Namespace, _.Library.Integer Grant)	SQL	static
CleanStaleStatements()	SQL	static
ClearStatistics(_.Library.SmallInt Scope, _.Library.String ScopeArgument, _.Library.String Errors)	SQL	static
CONVERT(_.Library.String expr, _.Library.String convto, _.Library.String convfrom)	SQL	static
CreateLinkedProcedure(_.Library.String dsn, _.Library.String externalSchema, _.Library.String externalProcedure, _.Library.String localPackage, _.Library.String localClass, _.Library.String localMethod, _.Library.String localSqlName, _.Library.String description)	SQL	static
CreateLinkedTable(_.Library.String dsn, _.Library.String externalSchema, _.Library.String externalTable, _.Library.String primaryKeys, _.Library.String localClass, _.Library.String localTable, _.Library.String columnMap)	SQL	static
CurrentSettings()	SQL	static
DATE(_.Library.String exp)	SQL	static
DATEADD(_.Library.String datepart, _.Library.Numeric val, _.Library.String dateexp)	SQL	static
DATEDIFF(_.Library.String datepart, _.Library.String startdate, _.Library.String enddate)	SQL	static
DATENAME(_.Library.String datepart, _.Library.String dateexp)	SQL	static
DATEPART(_.Library.String datepart, _.Library.String dateexp)	SQL	static
DAYNAME(_.Library.String dateexp)	SQL	static
DAYOFMONTH(_.Library.String dateexp)	SQL	static
DAYOFWEEK(_.Library.String dateexp)	SQL	static
DAYOFYEAR(_.Library.String dateexp)	SQL	static
DDLImport(_.Library.String DDLMode, _.Library.String SQLUser, _.Library.String infile, _.Library.String outfile, _.Library.Boolean nosup, _.Library.String nosupfile, _.Library.String deos, _.Library.SmallInt errpause, _.Library.String runtimemode)	SQL	static
DDLImportDir(_.Library.String DDLMode, _.Library.String directory, _.Library.String logfile, _.Library.String eosDelimiter)	SQL	static
DefaultSchema()	SQL	static
DropAll()	SQL	static
DropTable(_.Library.String tablename, _.Library.Boolean deldata, _.Library.Integer SQLCODE, _, _.Library.String msg)	SQL	static
DropView(_.Library.String viewname, _.Library.Integer SQLCODE, _, _.Library.String msg)	SQL	static
Execute(_.Library.String SQL, _.Library.String SelectMode, _.Library.String Dialect, _.Library.Integer ObjectSelectMode)	SQL	static
ExecuteCachedQuery(_.Library.String pCQName, _.Library.Integer pNumRowsToDisplay, _.Library.String pArgs)	SQL	static
Explain(_.Library.String sql, _.Library.DynamicObject qualifiers, _.Library.RawString dynArgs, _.Library.RawString plan)	SQL	static
Export(_.Library.String Schema, _.Library.String Table, _.Library.String File, _.Library.String FileOpenParam, _.Library.Boolean Users, _.Library.Boolean Roles, _.Library.Boolean Privileges, _.Library.Boolean SQLSystemPrivileges)	SQL	static
ExportAllSQLStatements(_.Library.String Filename)	SQL	static
ExportSQLStatement(_.Library.String Filename, _.Library.String Hash)	SQL	static
ExportTuneStats(_.Library.String pFilename, _.Library.String pSchemaFilter, _.Library.String pTableFilter, _.Library.Boolean pDisplay)	SQL	static
FDBMS()	SQL	static
FLOOR(_.Library.Numeric val)	SQL	static
FreezePlans(_.Library.SmallInt Action, _.Library.SmallInt Scope, _.Library.String ScopeArgument, _.Library.String Errors)	SQL	static
GetAutoCommit()	SQL	static
GetBitmapFriendlyCheck()	SQL	static
GetCollectionProjection()	SQL	static
GetColumns(_.Library.String tablename, _.Library.String byName, _.Library.String byNumber, _.Library.Boolean skipHiddenFields)	SQL	static
GetCompileMode()	SQL	static
GetIdentityInsert()	SQL	static
GetIsolationMode()	SQL	static
GetLockThreshold()	SQL	static
GetLockTimeout()	SQL	static
GetMapSelectability(_.Library.String pTablename, _.Library.String pMapname)	SQL	static
GetProcessLockTimeout()	SQL	static
GetROWID()	SQL	static
GetRTPCRuntimeQueries(_.Library.String pUtilityCls, pRuntimeCls)	SQL	static
GetSelectMode()	SQL	static
GetServerDisconnectCode()	SQL	static
GetServerInitCode()	SQL	static
GetSQLFunctionArgConversion()	SQL	static
GetSQLStatsFlag(_.Library.Integer flagType, _.Library.Integer returnActionFlag, _.Library.ArrayOfObjects ptInfo)	SQL	static
GetSQLStatsFlagByPID(_.Library.String pid, _.Library.Integer returnActionFlag, _.Library.ArrayOfObjects ptInfo)	SQL	static
GrantObjPriv(_.Library.String ObjPriv, _.Library.String ObjList, _.Library.String Type, _.Library.String User, _.Library.Integer wGrant, _.Library.Integer SQLCODE)	SQL	static
Help(_.Library.String method)	Help	static
HOUR(_.Library.String timeexp)	SQL	static
ImportDir(_.Library.String pDialect, _.Library.String pDirectory, _.Library.String pLogfile, _.Library.String pExtensions, _.Library.String eosDelimiter, _.Library.Integer pRecurse, _.Library.Boolean pMessageMode, _.Library.Boolean pEchoMode, _.Library.Integer pErrorPause)	SQL	static
ImportSQLStatement(_.Library.String Filename, _.Library.Boolean Display)	SQL	static
ImportTuneStats(_.Library.String pFilename, _.Library.Boolean pDisplay, _.Library.Boolean pKeepClassUpToDate, _.Library.Boolean pClearCurrentStats)	SQL	static
Informix()	SQL	static
INSTR(_.Library.String string, _.Library.String substring, _.Library.Integer position, _.Library.Integer occurrence)	SQL	static
InterBase()	SQL	static
IRIS()	SQL	static
IsReservedWord(_.Library.String word)	SQL	static
IsValidRegularIdentifier(_.Library.String identifier)	SQL	static
LASTDAY(_.Library.String dateexp)	SQL	static
MINUTE(_.Library.String timeexp)	SQL	static
MONTH(_.Library.String dateexp)	SQL	static
MONTHNAME(_.Library.String dateexp)	SQL	static
MSSQLServer()	SQL	static
MVR(_.Library.String stringexp)	SQL	static
Oracle()	SQL	static
Prepare(_.Library.String SQL, _.Library.String SelectMode, _.Library.String Dialect, _.Library.Integer ObjectSelectMode)	SQL	static
ProcedureExists(_.Library.String procname, _.Library.String metadata)	SQL	static
Purge(_.Library.Integer days)	SQL	static
PurgeAllNamespaces()	SQL	static
PurgeCQClass(_.Library.String Classlist)	SQL	static
PurgeForRoutine(_.Library.String routine)	SQL	static
PurgeForTable(_.Library.String table)	SQL	static
QUARTER(_.Library.String dateexp)	SQL	static
QueryToTable(_.Library.String query, _.Library.String table, _.Library.Boolean display, _.Library.String error)	SQL	static
RevokeObjPriv(_.Library.String ObjPriv, _.Library.String ObjList, _.Library.String Type, _.Library.String User, _.Library.Integer wGrant, _.Library.Integer Cascade, _.Library.String AsGrantor, _.Library.Integer SQLCODE)	SQL	static
RoleExists(_.Library.String rolename)	SQL	static
SECOND(_.Library.String timeexp)	SQL	static
SetAllowExtrinsicFunctions(_.Library.Boolean flag, _.Library.Boolean oldval)	SQL	static
SetANSIPrecedence(_.Library.Boolean flag, _.Library.Boolean oldval)	SQL	static
SetAutoCommit(_.Library.Integer flag)	SQL	static
SetAutoParallel(_.Library.Boolean flag, _.Library.Boolean oldval)	SQL	static
SetAutoParallelThreshold(_.Library.Integer threshold, _.Library.Boolean oldval)	SQL	static
SetBitmapFriendlyCheck(_.Library.Integer pFlag, _.Library.Integer pOldVal)	SQL	static
SetCachedQueryLockTimeout(_.Library.Integer timeout, _.Library.Integer oldval)	SQL	static
SetCachedQuerySaveSource(_.Library.Boolean flag, _.Library.Boolean oldval)	SQL	static
SetCollectionProjection(_.Library.Integer value)	SQL	static
SetCompileModeDeferred()	SQL	static
SetCompileModeImmediate()	SQL	static
SetCompileModeInstall()	SQL	static
SetCompileModeNocheck()	SQL	static
SetDDLDefineBitmapExtent(_.Library.Boolean flag, _.Library.Boolean oldval)	SQL	static
SetDDLDropTabDelData(_.Library.Boolean flag, _.Library.Boolean oldval)	SQL	static
SetDDLFinal(_.Library.Boolean flag, _.Library.Boolean oldval)	SQL	static
SetDDLIdentifierTranslations(_.Library.String from, _.Library.String to, _.Library.String oldfrom, _.Library.String oldto)	SQL	static
SetDDLPKeyNotIDKey(_.Library.Boolean flag, _.Library.Boolean oldval)	SQL	static
SetDDLUseExtentSet(_.Library.Boolean flag, _.Library.Boolean oldval)	SQL	static
SetDDLUseSequence(_.Library.Boolean flag, _.Library.Boolean oldval)	SQL	static
SetDefaultSchema(_.Library.String schema, _.Library.String oldval, _.Library.Boolean Namespace)	SQL	static
SetDefaultTimePrecision(_.Library.Integer value, _.Library.Integer oldval)	SQL	static
SetDelimitedIdentifiers(_.Library.Boolean flag, _.Library.Boolean oldval)	SQL	static
SetECPSync(_.Library.Boolean flag, _.Library.Boolean oldval)	SQL	static
SetFastDistinct(_.Library.Boolean flag, _.Library.Boolean oldval)	SQL	static
SetFieldSelectivity(_.Library.String schema, _.Library.String tablename, _.Library.String fieldname, _.Library.String selectivity, _.Library.Boolean KeepClassUpToDate)	SQL	static
SetFilerRefIntegrity(_.Library.Boolean flag, _.Library.Boolean oldval)	SQL	static
SetIdentityInsert(_.Library.Integer value, _.Library.Status pStatus)	SQL	static
SetIsolationMode(_.Library.Integer value, _.Library.Status pStatus)	SQL	static
SetLockThreshold(_.Library.Integer value, _.Library.Integer oldval)	SQL	static
SetLockTimeout(_.Library.Integer timeout, _.Library.Integer oldval)	SQL	static
SetMapSelectability(_.Library.String pTablename, _.Library.String pMapname, _.Library.Boolean pValue)	SQL	static
SetProcessLockTimeout(_.Library.Integer value, _.Library.Status pStatus)	SQL	static
SetQueryProcedures(_.Library.Boolean flag, _.Library.Boolean oldval)	SQL	static
SetRetainSQL(_.Library.Boolean flag, _.Library.Boolean oldval)	SQL	static
SetRTPC(_.Library.Boolean flag, _.Library.Boolean oldval)	SQL	static
SetSelectMode(_.Library.Integer value, _.Library.Status pStatus)	SQL	static
SetServerDisconnectCode(_.Library.String code)	SQL	static
SetServerInitCode(_.Library.String code)	SQL	static
SetSQLFunctionArgConversion(_.Library.Integer flag, _.Library.Status pStatus)	SQL	static
SetSQLSecurity(_.Library.Boolean flag, _.Library.Boolean oldval)	SQL	static
SetSQLStats(_.Library.Integer actionFlag, _.Library.Integer returnActionFlag, _.Library.String collectFlag, _.Library.String terminateCond, _.Library.ArrayOfObjects ptInfo)	SQL	static
SetSQLStatsFlag(_.Library.Integer actionFlag, _.Library.Integer returnActionFlag, _.Library.String collectFlag, _.Library.String terminateCond, _.Library.ArrayOfObjects ptInfo)	SQL	static
SetSQLStatsFlagByNS(_.Library.String ns, _.Library.Integer actionFlag, _.Library.Integer returnActionFlag, _.Library.String collectFlag, _.Library.String terminateCond, _.Library.ArrayOfObjects ptInfo)	SQL	static
SetSQLStatsFlagByPID(_.Library.String pid, _.Library.Integer actionFlag, _.Library.Integer returnActionFlag, _.Library.String collectFlag, _.Library.String p5, _.Library.ArrayOfObjects ptInfo)	SQL	static
SetSQLStatsFlagJob(_.Library.Integer actionFlag, _.Library.Integer returnActionFlag, _.Library.String collectFlag, _.Library.String p4, _.Library.ArrayOfObjects ptInfo)	SQL	static
SetSQLStatsJob(_.Library.Integer actionFlag, _.Library.Integer returnActionFlag, _.Library.String collectFlag, _.Library.String p4, _.Library.ArrayOfObjects ptInfo)	SQL	static
SetTCPKeepAlive(_.Library.Integer seconds, _.Library.Integer oldval)	SQL	static
SetToDateDefaultFormat(_.Library.String value, _.Library.String oldval)	SQL	static
Shell()	SQL	static
ShowPlan(_.Library.String sql, _.Library.Boolean array, _.Library.Boolean showstats, _.Library.List packages, _.Library.String schemapath, _.Library.Boolean preparse, _.Library.String selectmode, _.Library.Boolean nofplan, _.Library.Boolean silent, _.Library.Boolean ignoreoutliers, _.Library.ArrayOfObjects dynargs, _.Library.Boolean verbose)	SQL	static
ShowPlanAlt(_.Library.String sql, _.Library.Boolean array, _.Library.Boolean showstats, _.Library.List packages, _.Library.String schemapath, _.Library.Boolean preparse, _.Library.List idList, _.Library.Boolean silent, _.Library.Boolean p10, _.Library.ArrayOfObjects p11, _.Library.Boolean verbose)	SQL	static
SQLCODE(_.Library.Integer SQLCODE)	SQL	static
SQLSTRING(_.Library.String stringexp, _.Library.Integer maxlen)	SQL	static
SQLUPPER(_.Library.String stringexp, _.Library.Integer maxlen)	SQL	static
STRING(_.Library.String stringexp, _.Library.Integer maxlen)	SQL	static
Sybase()	SQL	static
TableExists(_.Library.String tablename, _.Library.String metadata)	SQL	static
TOCHAR(_.Library.String expr, _.Library.String format)	SQL	static
TODATE(_.Library.String dateexp, _.Library.String format)	SQL	static
TOPOSIXTIME(_.Library.String stringexp, _.Library.String format)	SQL	static
TOTIMESTAMP(_.Library.String stringexp, _.Library.String format)	SQL	static
TRUNCATE(_.Library.String stringexp, _.Library.Integer maxlen)	SQL	static
TSQL()	SQL	static
TSQLShell()	SQL	static
TuneSchema(_.Library.String schema, _.Library.Boolean update, _.Library.Boolean display, _.Library.String pMessage, _.Library.Boolean KeepClassUpToDate, _.Library.Boolean ClearValues, _.Library.String LogFile, _.Library.Boolean RecompileCQ, _.Library.String SamplePercent)	SQL	static
TuneTable(_.Library.String table, _.Library.Boolean update, _.Library.Boolean display, _.Library.String pMessage, _.Library.Boolean KeepClassUpToDate, _.Library.Boolean ClearValues, _.Library.String LogFile, _.Library.Integer ExtentSize, _.Library.Boolean RecompileCQ, _.Library.String SamplePercent)	SQL	static
UPPER(_.Library.String stringexp)	SQL	static
UserExists(_.Library.String username)	SQL	static
ValidateTable(_.Library.String tablename, _.Library.TinyInt lockOption, _.Library.BigInt index)	SQL	static
ViewExists(_.Library.String viewname, _.Library.String metadata)	SQL	static
WEEK(_.Library.String dateexp)	SQL	static
YEAR(_.Library.String dateexp)	SQL	static