This is documentation for Caché & Ensemble.

For information on converting to InterSystems IRIS, see the InterSystems IRIS Adoption Guide and the InterSystems IRIS In-Place Conversion Guide, both available on the WRC Distributions page (login required).

Home > Class Reference > %SYS namespace > %SQL.Manager.Wizard.Util

%SQL.Manager.Wizard.Util

class %SQL.Manager.Wizard.Util extends %Library.RegisteredObject

SQL Manager CSP Wizard Utility Methods

Method Inventory

Methods

classmethod CancelButton()
Write out generic Cancel button
classmethod ChangeNamespace(Namespace As %String) as %String
Change namespace if the current namespace is not the desired namespace
classmethod DisplayTextFile(FileName As %String)
Display A TEXT file
classmethod ExitButton()
Write out generic Cancel button
classmethod NextButton()
Write out generic Cancel button
classmethod PreviousButton()
Go back to the previous page
classmethod listDSN(pagename As %String, Wizard As %String, Namespace As %String, Page As %Integer = 2)
Set up DSN names for Link Table, Link Procedure and Data Migration Wizards
classmethod listExtSchemas(pagename As %String, Wizard As %String, Namespace As %String, dsnname As %String, Page As %Integer)
list schemas based on cache gateway connection - you must have a DSN (Cache configuration name) passed in.
classmethod listExtTables(pagename As %String, Wizard As %String, Namespace As %String, dsnname As %String, schemaname As %String, Page As %Integer)
List SQL Gateway tables given by Namespace and DSN (Cache configuration name)
Input: pagename by value (this is used for building links)
Input: Wizard by value ("LinkTable", "LinkProcedure", or "DataMigration")
Input: Namespace by value (current connected Namespace)
Input: dsnname by value (DSN connected)
Input: schemaname by value (schema selected from DSN)
Input: Page by value (page number) list external tables based on cache gateway connection - you must have a DSN (Cache configuration name) passed in.
classmethod listProperties(Namespace As %String, SchemaName As %String, TableName As %String, ByRef properties As %String) as %String
This is the normal (not SQL Gateway) properties for a table
Input: Namespace by value
Input: SchemaName by value
Input: TableName by value
Output: array properties by reference
Return: longest property name
classmethod listSchemas(Namespace As %String, ByRef schemas As %String)
This is the normal schemas for a given Namespace, not SQL Gateway.
Input: Namespace by value
Output: array schems by reference
classmethod listTables(Namespace As %String, SchemaName As %String, ByRef tables As %String) as %Status
This is the normal tables given by Namespace and Schema
Input: Namespace by value
Input: SchemaName by value
Output: array schems by reference

Inherited Members

Inherited Methods

FeedbackOpens in a new window