Home > Class Reference > ENSLIB namespace > %UnitTest.DSQL
Private  Storage   

%UnitTest.DSQL


The methods in this class are used by the SQLRegression class to execute SQL files using dynamic SQL and return results in a stream. They are subject to change, and not intended to be called directly.

Inventory


Parameters Properties Methods Queries Indices ForeignKeys Triggers
2


Summary


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
FindClass Occurs convertSQL countCachedQuery
countGlobalRefs crossVerify describe diffData
diffExpectedByStream diffPlan genPlan getColumn
getData getFromPlan getSqlCode getSqlExec
ltrim processDRSToStream rewindLine rtrim
runDSQL stripChar trim typeNameByType


Methods


• classmethod processDRSToStream(ByRef rs As %ResultSet, ByRef output As %Stream) as %Status
Process each result set to a stream
• classmethod runDSQL(sqlfilename As %String, verbose As %Boolean = 0, genplan As %Boolean = 0) as %FileCharacterStream
Execute sql from sql file against dynamic SQL and return results in a stream If verbose is true, write verbose information to terminal If genplan is true, generate information and write it in stream for appropriate sql statements SQL statements are delimited by "####"