Hello everyone I'm running into a big problem, it seems DB2 doesn't support table names longer than 30 characters, is there anyway to override this setting?

The problem is I'm mapping another database and its table names are quite long for instance I'm getting this error:
SQL0107N The name "DetailLayoutParmListForSelectedResource" is too long. The
maximum length is "30". SQLSTATE=42622

I can't change the name of this table or else it will mess up a lot of data, any ideas on how I can get around this issue?

I'm loading in DB2 DDL when I get this errror from the command line editor.

Thanks.

-Cory

DB2 supports table names of 128 characters. Schemas, authorization names, and columns can only be 30 characters in V8 (not sure about 9).

Ah your right Marcus, I meant column names, thats a column name:
DetailLayoutParmListForSelectedResource


So there is no way to change the field name max length, it must be <= 30 characters in length?

Looks like the original maker of these tables went a little name crazy :P

If you don't already have V9, check the manual to see if it increased. I only know about DB2 V8.

I believe V9 stays on 30.

Yes it seems there is no way around it so I just added a section of code to my program to rename the massive field names that are longer than 30 characters and fixed the issue.

Please, How did you fix it?

column name is limited to 128 in 9.7
with this remark
The SQLDA structure is limited to storing 30-byte column names, 18-byte user-defined type names, and 8-byte schema names for user-defined types.
see
SQL and XML limits - IBM DB2 9.7 for Linux, UNIX, and Windows

thanks for support.