A. Upgrading from Ingres 6.4 : Considerations for Ingres 6.4 : Application Preparation : 4GL TABLE_KEY Type Conversions
 
Share this page                  
4GL TABLE_KEY Type Conversions
Conversion of 4GL VARCHAR variables to the TABLE_KEY type gives length errors. Avoid this by converting to char first:
TABLE_KEY(CHAR(varcharVariable))
Some 6.4 releases of 4GL had problems with variables of type TABLE_KEY. If you were doing type conversions to avoid the use of TABLE_KEY variables, consider removing the conversion altogether and using the TABLE_KEY type directly.