CA MICS Space Analyzer Option (VCA) Queries › VCAT2C– VCA Daily top 20 STORCLAS Space Used › Query Defaults

Query Defaults

The query defaults are:

• VCADAA DETAIL timespan file: Cycle 01
• Derivations:

  DATE

  DATEPART(ENDTS)
  

  TOPNN

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

  STCRANK

  STCRANK = STORSTGC ;
  IF STCRANK=' ' THEN STCRANK='**blank**';
  /* after descending sort by space used, the top 20 are selected for charting */
  RETAIN TOPNN &TOPNN ;
  RETAIN COUNT 0 ;
  IF FIRST.CPCID THEN COUNT=1 ;
  IF COUNT LE TOPNN THEN DO ;
    STCRANK=PUT(COUNT,Z2.) || ' - ' || LEFT(TRIM(STCRANK)) ;
    OUTPUT FILE3 ;
    COUNT+1 ;
  END ;