Fax Appendix 5: Sample Code for Updating the Definitions

Table Of ContentsIT Service Vision Help


We could apply the following CPDDUTL control statement to the PDB after applying the generated control statements in Fax Appendix 4: Sample Table and Variable Definitions to the PDB. This UPDATE statement modifies the lists of BY and CLASS variables for this table, adding further categorization information.

UPDATE TABLE NAME=UFAXES
    DETAIL=(byvars='MACHINE TYPE COUNTRY ACODE DATETIME HOUR SHIFT ' )
    DAY=(classvars='MACHINE TYPE COUNTRY ACODE DATETIME HOUR SHIFT ' )
    WEEK=(classvars='MACHINE TYPE COUNTRY ACODE DATETIME HOUR SHIFT ' )
    MONTH=(classvars='MACHINE TYPE COUNTRY ACODE DATETIME HOUR SHIFT ' )
    YEAR=(classvars='MACHINE TYPE COUNTRY ACODE DATETIME HOUR SHIFT ' )
;

Additionally, we could update variable attributes. A good example of such an update would include updating a variable's display format, as shown in Figure 3 - Updating the Data Dictionary to Associate a SAS Display Format as an Attribute of a Variable in Generic Collector Appendix 4: Other Considerations.

For more information about applying (running) a control statement, see Fax Appendix 3: Sample Code for Generating the Definitions. For more about the %CPDDUTL macro and its control statements, see the Macro Reference documentation for IT Service Vision.