sql error -750

Dear all, OS: Solaris 2.6 IDS: 7.31.UC2 Problem: SQL statement error number -750. Invalid distribution format found for sn I have shopfloor application (with multiple executable 4gl programs) running on the IDS database engine (7.31.UC2). Some of the 4gl programs always hitting the sql error -750 on those highly used tables. I know one of the method to resolve the error is to re-build the data distribution by running update statistics. I have a script to run the update statistics for all the tables with the following format. update statistics low for table <tabname> dropdistributions; update statistics medium for table <tabname>distributions only; Although the above update statistis method is running on daily basic, but the programs still hitting the -750 error. Is there other method to resolve the error?? Any recommendation and advise are highly appreciated. Thanks & regards, Miyaki __________________________________ Do you Yahoo!? SBC Yahoo! DSL - Now only $29.95 per month! http://sbc.yahoo.com