What does a -1 value on CARDF in SYSIBM.SYSTABLES

Raphael Bacay · Posted: Mon Sep 10, 2007 2:18 pm

Hello,

CARDF is a field in SYSIBM.SYSTABLES that seem to say the nuber of rows for a table. What does a -1 value on this field mean?

Regards.

dbzTHEdinosauer · Posted: Mon Sep 10, 2007 2:38 pm

Mr Bacay,
you are going to have to learn to look for this stuff yourself. The info you need is about 3/4 of the page down on the link - or do a page find for CARDF.

Raphael Bacay · Posted: Tue Sep 11, 2007 9:16 am

Thanks for the reply. I needed it to compute for database optimization.
I just had to know how many rows a -1 CARDF has. A SELECT COUNT(*) on the table with the -1 CARDF did the trick.

Regards.