%SYS.PTools.SQLQuery
persistent class %SYS.PTools.SQLQuery extends %Library.Persistent
SQL Table Name: %SYS_PTools.SQLQuery
This is the parent class of %SYS_PTools.SQLStats.This class stores the general info of a query from compile time: QueryText, QueryType, CursorName, RoutineName, and NameSpace. All of the run time data is stored in the %SYS_PTools.SQLStats class.
Error information is stored in ^%sqlcq(NAMESPACE,"PTools","Error",$J).
Property Inventory
- CompileTime
- CursorName
- Hash
- ImportSchema
- InternalQueryText
- NameSpace
- QueryText
- QueryType
- RoutineName
- RunCount
- SQLStatsPointer
- details
Method Inventory
Properties
Methods
##class(%SYS.PTools.SQLQuery).Export(FileName,delim,ExportPlan)
- FileName
- Path and name of the file you want to export to.
- delim
- Default value $c(9) (tab) Delimiter for the columns of the export file.
- ExportPlan
- Optional. Default value = 0 if 1 then the SQL Show Plan will be included as part of the export
This method is used to export data from the %SYS.PTools.SQLQuery class to a delimited text file.
Indexes
Inherited Members
Inherited Methods
- %AddToSaveSet()
- %AddToSyncSet()
- %BMEBuilt()
- %CheckConstraints()
- %CheckConstraintsForExtent()
- %ClassIsLatestVersion()
- %ClassName()
- %ComposeOid()
- %ConstructClone()
- %Delete()
- %DeleteExtent()
- %DeleteId()
- %DispatchClassMethod()
- %DispatchGetModified()
- %DispatchGetProperty()
- %DispatchMethod()
- %DispatchSetModified()
- %DispatchSetMultidimProperty()
- %DispatchSetProperty()
- %Exists()
- %ExistsId()
- %Extends()
- %GUID()
- %GUIDSet()
- %GetLock()
- %GetParameter()
- %GetSwizzleObject()
- %Id()
- %InsertBatch()
- %IsA()
- %IsModified()
- %IsNull()
- %KillExtent()
- %KillExtentData()
- %LoadFromMemory()
- %LockExtent()
- %LockId()
- %New()
- %NormalizeObject()
- %ObjectIsNull()
- %ObjectModified()
- %Oid()
- %OnBeforeAddToSync()
- %OnDetermineClass()
- %Open()
- %OpenId()
- %OriginalNamespace()
- %PackageName()
- %PhysicalAddress()
- %PurgeIndices()
- %Reload()
- %RemoveFromSaveSet()
- %ResolveConcurrencyConflict()
- %RollBack()
- %Save()
- %SaveDirect()
- %SaveIndices()
- %SerializeObject()
- %SetModified()
- %SortBegin()
- %SortEnd()
- %SyncObjectIn()
- %SyncTransport()
- %UnlockExtent()
- %UnlockId()
- %ValidateIndices()
- %ValidateObject()
Storage
Storage Model: CacheStorage (%SYS.PTools.SQLQuery)
^%sqlcq($NAMESPACE,"PTools","RunTime","SQLQueryD")(ID) | = | %%CLASSNAME
InternalQueryText
QueryType
CompileTime
Hash
NameSpace
RoutineName
CursorName
QueryText
ImportSchema
RunCount
details
|