Portal | Manuals | References | Downloads | Info | Programs | JCLs | Mainframe wiki | Quick Ref
IBM Mainframe Computers Forums Index
 
Register
 
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist Profile Log in to check your private messages Log in
 
What does a -1 value on CARDF in SYSIBM.SYSTABLES

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> DB2
View previous topic :: :: View next topic  
Author Message
Raphael Bacay

New User


Joined: 04 May 2007
Posts: 58
Location: Manila, Philippines

PostPosted: Mon Sep 10, 2007 2:18 pm    Post subject: What does a -1 value on CARDF in SYSIBM.SYSTABLES
Reply with quote

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.
Back to top
View user's profile Send private message

dbzTHEdinosauer

Global Moderator


Joined: 20 Oct 2006
Posts: 6968
Location: porcelain throne

PostPosted: Mon Sep 10, 2007 2:38 pm    Post subject:
Reply with quote

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.
Back to top
View user's profile Send private message
Raphael Bacay

New User


Joined: 04 May 2007
Posts: 58
Location: Manila, Philippines

PostPosted: Tue Sep 11, 2007 9:16 am    Post subject: Reply to: What does a -1 value on CARDF in SYSIBM.SYSTABLES
Reply with quote

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.
icon_wink.gif
Back to top
View user's profile Send private message
View previous topic :: :: View next topic  
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> DB2 All times are GMT + 6 Hours
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
No new posts ERM-Diagram of SysIBM-Catalog-Tables Auryn DB2 2 Fri Feb 17, 2017 6:22 pm
No new posts Can not find SQL statement of package... chaoj DB2 2 Wed Mar 11, 2015 12:00 pm
No new posts -551 on SYSIBM.SYSTABLES, SYSIBM.SYST... baramesh DB2 5 Mon Dec 23, 2013 6:29 pm
No new posts SYSIBM.SYSPACKSTMT - DB2 V9 TO V10 gylbharat DB2 22 Fri Oct 25, 2013 3:36 pm
No new posts Copy Pending status flag in the SYSIB... pmvino DB2 1 Tue May 24, 2011 12:34 pm

Facebook
Back to Top
 
Job Vacancies | Forum Rules | Bookmarks | Subscriptions | FAQ | Polls | Contact Us