Cougar Mountain Software Support Productivity Tools
For Cougar Mountain Software Support's
Professional Version (V2012, V2011, V2010, V2009, V12-V6)

 

TECH TIP
USING UTICMS TO CORRECT DATA
 for the Reporting to the MAX

 

Use UTICMS to fill-in missing data on a file like xxxINMAS.DBF file and fill-in fields (eg. IN_BUYCON and IN_SELLCON with a 1 or other appropriate factor).   When these fields are missing, it causes division by zero errors 

Use UTICMS, open the file in question.  

 

Locate the rows/records needing to be fixed.  Click on the field in the record needing updating and punch in the correct informat

 

Sometimes a blank record is inserted into a data file, causing (typically) a 910 error.  This blank record is most commonly at the very bottom or very top of the file, making it easy to both find and delete.  A blank record is considered to be any row that has only a Record Number, or only a Record Number and incomplete or corrupted data in the rest of the row.

 

 

Once you have fixed the records  



After using the UTICMS program, you should use the Re-index the files in the module, Options, File Maintenance, Select All to re-index the files.   You should review the Status column for errors.  

Based on contribution by Kay Cook, Information Advantage

 

If you wish to get more information, please email us at

or call us at (714)  228-5444