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).
| Method | Description | |
|---|---|---|
| cancelTimeOut | Cancels a previous method call to the setTimeOut method. (Inherited from Object.) |
| checkFieldConflict | Check whether there's fieldID within each table inheritance hierarchy. |
| convertTPT2TPH | The main method to call for generating the data conversion T-SQL scripts. |
| doCheckFieldConflict | Reports error messages to the Infolog if any fieldID is duplicated within the table inheritance hierarchy derived from the input root table. |
| doConvertTPT2TPH | Generate data conversion T-SQL statements for a given table hierarchy. |
| doPrintSqlDictionary | Print SqlDictionary entries for a given table inheritance hierarchy. |
| equal | Determines whether the specified object is equal to the current one. (Inherited from Object.) |
| 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. |
| getAddIndexStatement | Generate T-SQL statements to add subtype indexes to the root table. |
| 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. |
| 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. |
| getHierarchies | Retrieve all root table IDs for all table inheritance hierarchies. |
| getModelDbPatchStatement | Retrieves the special patch-up script, that you must run against the SQL Server model database, for table DIOTAddlInfoForNoVendorLedger_MX and CompanyInfo. |
| getModelElementPatchStatement | Helper method to generate a T-SQL statement to update a fieldID in the model database. |
| getSqlDictionaryPatchStatement | The helper method to update the fieldID in a SqlDictionary table entry. |
| getSqlDictionaryUpdateStatement | Generate T-SQL statements that update the rows in table SqlDictionary for a subtype table. |
| 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. |
| getTimeOutTimerHandle | Returns the timer handle for the object. (Inherited from Object.) |
| handle | Retrieves the handle of the class of the object. (Inherited from Object.) |
| isInPlaceUpgradeFrom62 | |
| new | Initializes a new instance of the Object class. (Inherited from Object.) |
| notify | Releases the hold on an object that has called the wait method on this object. (Inherited from Object.) |
| notifyAll | Releases a lock on the object that was issued by the wait method on this object. (Inherited from Object.) |
| objectOnServer | Determines whether the object is on a server. (Inherited from Object.) |
| owner | Returns the instance that owns the object. (Inherited from Object.) |
| parmSkipFilteredIndex | Gets or sets the SkipFilteredIndex parameter. |
| printSqlDictionary | Prints SqlDictionary entries for all the table inheritance hierarchies, to the Infolog. |
| printString | The helper method that writes a given message into the target file. |
| setFirstFile | Sets the first target file. |
| setSecondFile | Set the second target file. |
| setTimeOut | Sets up the scheduled execution of a specified method. (Inherited from Object.) |
| toString | Returns a string that represents the current object. (Inherited from Object.) |
| usageCount | Returns the current number of references, that is, the value of the reference counter, that the object has. (Inherited from Object.) |
| wait | Pauses a process. (Inherited from Object.) |
| xml | Returns an XML string that represents the current object. (Inherited from Object.) |
| ::isInUnFlattenMode | Indicates whether Dynamics AX has yet been converted to the flat single-table physical format for table inheritance hierarchies. |
| ::Main | Provides an entry point for the SysDataUpgradeSCscTPT2TPH class when it is called from a menu item. |
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.
Community Additions
ADD
Show: