DEFINE FILE PROD_EDW3EM_INTERACTION_KANA
DIRECTION_1/A20=
DECODE DIRECTION ('O' 'Outbound' 'I' 'Inbound' 'F' 'F Direction' 'R' 'R Direction' 'T' 'T Direction'
ELSE 'Other');
TEST11/I6=EDIT(CHANNEL);
END
TABLE FILE PROD_EDW3EM_INTERACTION_KANA
COUNT
TEST11 AS 'COUNT,TEST1'
BY DIRECTION_1

I am getting the following
DIRECTION_1 COUNT
TEST1
F Direction 8
Inbound *****
Outbound 21272
R Direction 6733
How do I get the figures to appear, I have tried increasing the defined field.

Use

COUNT FLD/I9 to increase the count variable length

quote:

Posted April 16, 2007 06:17 AM Hide Post
Use

COUNT FLD/I9 to increase the count variable length

Plus in addition to Alan's suggestion, if you are summing the information anywhere else, you may find '*' in the totals if the field is not defined large enough as well.

fyi, COUNT gives you an I5 field , by default

I add:
SET COUNTWIDTH = ON
to all my fexes. Changes the default on COUNT from I5 to I9.