SysDataUpgradeSCscTPT2TPH Class [AX 2012]

A framework class to generate Transact-SQL scripts for reallocating data from the multi-table to the flat single-table physical format, for table inheritance hierarchies (SCsc).

class SysDataUpgradeSCscTPT2TPH

Run On

Called

  MethodDescription
JJ844613.pubmethod(en-us,AX.60).gif cancelTimeOut Cancels a previous method call to the setTimeOut method. (Inherited from Object.)
JJ844613.pubmethod(en-us,AX.60).gif checkFieldConflict Check whether there's fieldID within each table inheritance hierarchy.
JJ844613.pubmethod(en-us,AX.60).gif convertTPT2TPH The main method to call for generating the data conversion T-SQL scripts.
JJ844613.privmethod(en-us,AX.60).gif doCheckFieldConflict Reports error messages to the Infolog if any fieldID is duplicated within the table inheritance hierarchy derived from the input root table.
JJ844613.protmethod(en-us,AX.60).gif doConvertTPT2TPH Generate data conversion T-SQL statements for a given table hierarchy.
JJ844613.privmethod(en-us,AX.60).gif doPrintSqlDictionary Print SqlDictionary entries for a given table inheritance hierarchy.
JJ844613.pubmethod(en-us,AX.60).gif equal Determines whether the specified object is equal to the current one. (Inherited from Object.)
JJ844613.privmethod(en-us,AX.60).gif getAddColumnStatement Generate the T-SQL statement that can add a column (field) to the root table to match the column on the obsolete derived subtype table.
JJ844613.privmethod(en-us,AX.60).gif getAddIndexStatement Generate T-SQL statements to add subtype indexes to the root table.
JJ844613.protmethod(en-us,AX.60).gif getDIOTFix Retrieves the special patch-up script for table DIOTAddlInfoForNoVendorLedger_MX, to change the ID value of field LedgerJournalTrans to avoid a duplicate key error in SqlDictionary.
JJ844613.protmethod(en-us,AX.60).gif getDirPartyTableFixes Retrieves the special patch-up script for table CompanyInfo, to change the ID value of field DEL_CCMNum_BR to avoid a duplicate key error in SqlDictionary.
JJ844613.pubmethod(en-us,AX.60).gif getHierarchies Retrieve all root table IDs for all table inheritance hierarchies.
JJ844613.protmethod(en-us,AX.60).gif getModelDbPatchStatement Retrieves the special patch-up script, that you must run against the SQL Server model database, for table DIOTAddlInfoForNoVendorLedger_MX and CompanyInfo.
JJ844613.protmethod(en-us,AX.60).gif getModelElementPatchStatement Helper method to generate a T-SQL statement to update a fieldID in the model database.
JJ844613.protmethod(en-us,AX.60).gif getSqlDictionaryPatchStatement The helper method to update the fieldID in a SqlDictionary table entry.
JJ844613.privmethod(en-us,AX.60).gif getSqlDictionaryUpdateStatement Generate T-SQL statements that update the rows in table SqlDictionary for a subtype table.
JJ844613.protmethod(en-us,AX.60).gif getStoredProcCleanupStatement Removes a special T-SQL stored procedure that indicates the system has not yet been converted from multi-table to single-table inheritance hierarchies.
JJ844613.pubmethod(en-us,AX.60).gif getTimeOutTimerHandle Returns the timer handle for the object. (Inherited from Object.)
JJ844613.pubmethod(en-us,AX.60).gif handle Retrieves the handle of the class of the object. (Inherited from Object.)
JJ844613.privmethod(en-us,AX.60).gif isInPlaceUpgradeFrom62
JJ844613.pubmethod(en-us,AX.60).gif new Initializes a new instance of the Object class. (Inherited from Object.)
JJ844613.pubmethod(en-us,AX.60).gif notify Releases the hold on an object that has called the wait method on this object. (Inherited from Object.)
JJ844613.pubmethod(en-us,AX.60).gif notifyAll Releases a lock on the object that was issued by the wait method on this object. (Inherited from Object.)
JJ844613.pubmethod(en-us,AX.60).gif objectOnServer Determines whether the object is on a server. (Inherited from Object.)
JJ844613.pubmethod(en-us,AX.60).gif owner Returns the instance that owns the object. (Inherited from Object.)
JJ844613.pubmethod(en-us,AX.60).gif parmSkipFilteredIndex Gets or sets the SkipFilteredIndex parameter.
JJ844613.pubmethod(en-us,AX.60).gif printSqlDictionary Prints SqlDictionary entries for all the table inheritance hierarchies, to the Infolog.
JJ844613.privmethod(en-us,AX.60).gif printString The helper method that writes a given message into the target file.
JJ844613.pubmethod(en-us,AX.60).gif setFirstFile Sets the first target file.
JJ844613.pubmethod(en-us,AX.60).gif setSecondFile Set the second target file.
JJ844613.pubmethod(en-us,AX.60).gif setTimeOut Sets up the scheduled execution of a specified method. (Inherited from Object.)
JJ844613.pubmethod(en-us,AX.60).gif toString Returns a string that represents the current object. (Inherited from Object.)
JJ844613.pubmethod(en-us,AX.60).gif usageCount Returns the current number of references, that is, the value of the reference counter, that the object has. (Inherited from Object.)
JJ844613.pubmethod(en-us,AX.60).gif wait Pauses a process. (Inherited from Object.)
JJ844613.pubmethod(en-us,AX.60).gif xml Returns an XML string that represents the current object. (Inherited from Object.)
JJ844613.pubmethod(en-us,AX.60).gif JJ844613.static(en-us,AX.60).gif ::isInUnFlattenMode Indicates whether Dynamics AX has yet been converted to the flat single-table physical format for table inheritance hierarchies.
JJ844613.pubmethod(en-us,AX.60).gif JJ844613.static(en-us,AX.60).gif ::Main Provides an entry point for the SysDataUpgradeSCscTPT2TPH class when it is called from a menu item.
Top

The methods on this class are to be run only on Dynamics AX systems that still use the older nonflat multi-table physical format for table inheritance hierarchies. Do not customize.

SCsc loosely stands for supertype and subtype, and means table inheritance in AX.

TPT stands for table per type. TPH stands for table per hierarchy.

Object Class
  SysDataUpgradeSCscTPT2TPH Class

Community Additions

ADD
Show: