|
<< Click to Display Table of Contents >> Navigation: IMS version 21.9 > IMS Basics - User Guide > Telephone Number Management (TNM) > Bulk Loading Telephone Number Details |
As we can imagine, adding new, modifying existing, or deleting data in TNM is not a desirable activity if there are dozens or hundreds of TNM records that need to be attended to. For that reason, in IMS there is a Bulk Loader tool that facilitates loading bulk data at speed. By using column names representing database fields, and SQL instructions like ADD, UPDATE, and DELETE, we can maximize data processing in far less time.
The following is a list of the main database fields that could be needed in the process of bulk loading for the Telephone Numbers of a given Range:
Rownum |
Action |
Entity |
Id |
TelephoneNumberRangeId |
TelephoneNr |
TelephoneNumberStatusId |
PortedToId |
ProjectStatusId |
NiceNumber |
CustomerId |
OrderId |
OrderId |
ExpireDate |