Class Reference
IRIS for UNIX 2019.2
InterSystems: The power behind what matters   
Documentation  Search
  [ENSLIB] >  [%UnitTest] >  [DSQL]
Private  Storage   

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 "####"


Copyright (c) 2019 by InterSystems Corporation. Cambridge, Massachusetts, U.S.A. All rights reserved. Confidential property of InterSystems Corporation.