Why some tables in systables have a partnum of zero?

Question

Running a query on catalog table 'sysmaster' return tables with a value of zero in the partnum column like this :

tabname sysdomains
owner informix
partnum 0
tabid 70
rowsize 167

Answer

The partnum column in systables indicates the identification of the table inside a dbspace, when the value of partnum is zero, this means that it is a :

• fragmented table
• view
• synonym

http://www-01.ibm.com/support/docview.wss?uid=swg21660449&myns=swgimgmt&mynp=OCSSGU8G&mync=E