I've found limited information on the FOC153 verb maximum limitation and understand how/why the error is occurring, but not much in the way of a workaround. Given the procedure definition below, is there a way to consolidate the 15 OVER verb objects into a single VERB object by dynamically setting a DEFINE with each of the CAR attributes and then performing a single OVER verb on that DEFINE field?


TABLE FILE CAR
SUM CAR.CARREC.MODEL
OVER CAR.BODY.BODYTYPE
OVER CAR.BODY.SEATS
OVER CAR.BODY.DEALER_COST
OVER CAR.BODY.RETAIL_COST
OVER CAR.BODY.SALES
OVER CAR.SPECS.LENGTH
OVER CAR.SPECS.WIDTH
OVER CAR.SPECS.HEIGHT
OVER CAR.SPECS.WEIGHT
OVER CAR.SPECS.WHEELBASE
OVER CAR.SPECS.FUEL_CAP
OVER CAR.SPECS.RPM
OVER CAR.SPECS.MPG
OVER CAR.SPECS.ACCEL
OVER CAR.SPECS.BHP
ACROSS CAR.ORIGIN.COUNTRY
ACROSS CAR.COMP.CAR
ON TABLE PCHOLD FORMAT HTML

I found a 'MacGyver' technique ( https://techsupport.informatio...ver/cof_tcn_m07.html ), but am not following where 'counter' is coming from.

Thanks for any help.

This message has been edited. Last edited by: User,

COUNTER comes from table FSEQ in the JOIN, which is an IBI sample file that I believe can be generated during the WebFOCUS install process. You can always create your own version. Here is the master description.

FILE=FSEQ, SUFFIX=FOC, $
SEGNAME=SEG1
 FIELD=BLANK , , A1, INDEX=I, $
SEGNAME=SEG2, SEGTYPE=S1, PARENT=SEG1
 FIELD=COUNTER, ORDER, I4, $

Dan, thanks for the help.