CA MICS Space Analyzer Option (VCA) Queries › VCACIS– Top 20 CI Splits by DS Type › Query Defaults

Query Defaults

The query defaults are:

• VCA_VS DETAIL timespan file: Cycle 01
• Filters:

  DAANCIS GE 30

• Derivations:

  DATE

  DATEPART(ENDTS)
  

  TOPNN

  %LET TOPNN = 20 ;      /* <------ change if desired */
  

  DSN_CIRK

  DSN_CIRK = DSNAME ;
  /* after input file is sorted by descending DAASCIS the rank is prefixed to the DSNAME and the TOPNN are output  */
  RETAIN TOPNN &TOPNN ;
  RETAIN COUNT 0 ;
  IF FIRST.CPCID THEN COUNT=1 ;
  IF COUNT LE TOPNN THEN DO ;
    DSN_CIRK=PUT(COUNT,Z2.) || ' - ' || LEFT(TRIM(DSN_CIRK)) ;
    OUTPUT FILE2 ;
    COUNT+1 ;
  END ;