Re: C-ISAM and S.E.

Glen Johnson (grjohn@bga.com) wrote: : Warning: Novice 101 question : Are S.E. files just C-ISAM files with a null primary key? : I have a program that reorganizes C-ISAM files and am wondering : if I use it to reorg a S.E. file can I expect trouble. : Essentially, could you (do you) use BCHECK on S.E. files or is : there a different INFORMIX command. : Thanks, : Glen Johnson Yes, SE files are in C-ISAM format, and yes you can (and probably should) use bcheck on them. You don't say whether your program to reorganise the files is just reorganising the data in the files, or the actual structure of the C-ISAM files, but if it is just dealing with the data there shouldn't be a problem. However, don't even think about using C-ISAM commands to add/delete/modify columns or indexes :-) as SE holds info on the tables in a database in the files beginning with 'sys'. If this data does not reflect the true structure of the tables, SE can do odd things which can be difficult to correct... - Ant.