All,
I can't see the result of a count statement because the result is too large to display. As a result, it overflows and displays asterisks. What can I do to fix the size of the result? The table that I am getting the count for has more than 80 million rows, but I am using the readlimit to control the run time.

Here is the script:

 

TABLE FILE MY_TABLE
COUNT *
WHERE READLIMIT EQ 1000
END

Thank you,

Seyed

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

 
SET COUNTWIDTH=ON
TABLE FILE GGSALES
COUNT *
END

-* Option 2 (shows thousands separator)
TABLE FILE GGSALES
COUNT SEQ_NO/I11C 
END

Thank you very much. Your solution worked.

Seyed

You can also use SUM and CNT. with the format specified.

TABLE FILE MY_TABLE
SUM CNT.{Field}/I9
END

Waz,
Thank you for your help. Your suggestion is very helpful.

Seyed