This is the result I get from the ?FF in 5.3.2:

 FILENAME=  H1
 SALES         E02           I6

Francis :
Like Scott was saying, you could use E01 as the field-name for the Country-name field.
You can see that for yourself by using the "? HOLD hfilename" command instead of the "?FF hfilename" command. I belive the latter only shows you the original field names and not the temp fields that are built on the fly (in cases like OVER).

-SET &ECHO=ALL;
TABLE FILE CAR
SUM
SALES
BY COUNTRY ROWS 'ENGLAND' OVER 'JAPAN' OVER 'SWEDEN'
ON TABLE HOLD AS H1
END
-RUN
-*
? HOLD H1
-RUN
-*
-EXIT
-* (above code will show you the E01 temp field).
-*
-*
TABLE FILE H1
PRINT
E01
END
-* (will print only the Country column, which you can rename if you want to re-use later).


Sandeep M.

OVER formatting is done after the internal matrix is built. The hold file derives from the internal matrix so you will never get this effect in the hold file.

I tried to do this as well as it would be very useful if it did work!

Francis,

I'm sure that you don't need reminding that you can always issue APP HOLD BASEAPP to have a gander at the FTM and MAS files produced by your HOLD.

It seems as though this works for most others in as much that "we" get the E01 field within the HOLD file, however, from your post you say that you do not. What environmental settings do you have there? Perhaps one of them is preventing the column from being held, although I can't think of one that would.

BTW, ?FF only gives the SALES E02 information on 7.1.3 as well so I would be more inclined to use ? HOLD H1 instead.

T

quote:

BY COUNTRY ROWS 'ENGLAND' OVER 'JAPAN' OVER 'SWEDEN'

This is the same as a FOR statement and thus invokes FML/FRL/EMR or whatever IBI are calling it today.

The FOR field in a HOLD for FML is always converted to alphanumeric format and does not appear in the HOLD file, but as mentioned the E01, alias, does.

Not quite sure why this is done, but there must be some usefulness.

The HOLD file does indeed have bothe the E01 and E02 fields.

It just seems odd that the ?FF and ? HOLD provides different answers.

I wish FML worked like normal WebFOCUS.

Thanks everyone.