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

%SQL.Manager.Wizard.Util


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

SQL Manager CSP Wizard Utility Methods

Inventory


Parameters Properties Methods Queries Indices ForeignKeys Triggers
12


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
CancelButton ChangeNamespace DisplayTextFile ExitButton
NextButton PreviousButton listDSN listExtSchemas
listExtTables listProperties listSchemas listTables


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 (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 (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 (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