Need table names to be 8.3 format.

Someone wrote: >Is there an environmental setting or anyway to force Informix to allow >you to have table names that are 8.3 format? In other words, when I >create a table called 'abcdefgh', I would like it to be 'abcdefgh.xxx' >and not 'abcdefgh__123.xxx". I assume you are refering to standard engine .dat/.idx filenames. Have you tried using the IN "pathname" syntax when creating the tables? ie create table fred (x int) IN "/usr/dbtest/fred"; I am pretty sure this does what you require, but do not have SE to check it. Mark Denham BBC London, UK Mark.Denham@bbc.co.uk