Query Defaults

The following are RMFCWT Query Defaults:

HARCMT DETAIL time span file: Cycle 01
Filters: Empty Filter task provided as placeholder for user HARCMT file filtering to exclude/select specific LPARs
Commented user code, that if uncommented will only accept yesterday’s data
- *IF DATEPART(ENDTS) EQ TODAY()-1 ;
Derivations:

DATE: DATEPART(ENDTS) ;
HHMM: PUT(HOUR(ENDTS),Z2.) || ':' || PUT(MINUTE(ENDTS),Z2.);
DATEHOUR: PUT(DATEPART(ENDTS),YYMMDDD10.) || ':' || PUT(HOUR,Z2.) ;
DATEHHMM: PUT(DATEPART(ENDTS),YYMMDDP10.) || '-' || HHMM ;
WKLDHINT: IF HISCVER2=1 THEN RNI=CMT1RNI ;
ELSE IF HISCVER2=2 THEN RNI=CMT2RNI ;
IF CMTPCL1M LT 3 THEN DO ;
IF RNI GE .75 THEN WKLDHINT=2 ;
ELSE WKLDHINT=1 ;
END ;
ELSE IF 3 LE CMTPCL1M LE 6 THEN DO ;
IF RNI GT 1.0 THEN WKLDHINT=3 ;
ELSE IF 0.6 LE RNI LE 1.0 THEN WKLDHINT=2 ;
ELSE WKLDHINT=1 ;
END ;
ELSE IF CMTPCL1M GT 6 THEN DO ;
IF RNI GE 0.75 THEN WKLDHINT=3 ;
ELSE WKLDHINT=2 ;
END ;
CPI_P: IF CMTP33 THEN CPI_P = CMTP32 / CMTP33;
CPI_S: IF CMTS33 THEN CPI_S = CMTS32 / CMTS33 ;
AVGPCBSY: IF CMTAVIPU THEN AVGPCBSY=CMTPCBSY / CMTAVIPU ;