Renaming Long Table Names

[Guest.Visitor]

HI, When I use CREATE TABLE to create tables on AS/400, if the table name is longer than 10 characters, the object is automatically generated by AS/400 with 10 chars. For eg., if CUSTOMER_TABLE is the name of the table, then the object name would be CUSTO00001. I am renaming it to be more meaningful. But for table names less than 10 chars, I do not get an alternative name. If the table name is DUMMY, then the object name is also DUMMY. Any ideas how I can force an alternative table name as I am following a standard naming convention for naming objects created thru' sQL and each object will have a long SQL name and a 10-char short AS/400 name. Thanx in advance Arun

[J.Panzenhagen]

Have you tried the CREATE ALIAS statement? That will allow you to assign an alternate name to either a file or a table. John P

[Guest.Visitor]

Hi, I have tried CREATE ALIAS and they create DDM files and since for each table I need to rename, having lots of these DDM files is cumbersome. Regards arun