Class apptools.core.sql

abstract class apptools.core.sql

Query and SQL statements

Parameters	Properties	Methods	Queries	Indices	ForeignKeys	Triggers
		2	1

Summary

Methods
getSQL	getViewOrQuerySQL

Methods

• classmethod getSQL(name As %String, removeNL=$$$NO, ByRef Description, today=1) as %String

s sql=##class(apptools.core.sql).getSQL("apptools.core.sql:TestXData",0,.desc) w !,sql,!!,desc s sql=##class(apptools.core.sql).getSQL("TestQuery",0,.desc) w !,sql,!!,desc

• classmethod getViewOrQuerySQL(viewOrQueryName As %String, Output sql As %String) as %Status

Queries

• query TestQuery()

SQL Query :
SELECT top 10 * from
apptools_core.Log

test query stored in query

Class Reference IRIS for UNIX 2024.1.2
Documentation Search