ALTER Data Set

Use the ALTER declaration when you want to reformat data items in a data set to different layouts (i.e., data item conversion). If you are using DATABridge Clients, however, it is often less expensive to use the date formats provided by the DATABridge Client software. Common uses of the ALTER declaration include the following:

• Subdividing items. If the target database is a relational database, keep in mind that there is often a limit on the number of columns.
• Merging adjacent items in the same parent group
• Formatting dates that cannot be done with the ALTER REDEFINE

VIRTUAL Data Set

VIRTUAL data sets allow you to create a structure that does not physically reside in the DMSII database, while appearing as normal data sets to the accessories.