Re: [sqlalchemy] Column alias created by SQLAlchemy is exeeding max column length of db2.

2012-04-21 Thread Yap Sok Ann
On Wednesday, June 24, 2009 10:25:09 PM UTC+8, Michael Bayer wrote: Beeno wrote: Hello Sqlalchemy appears to be aliasing each column in a SELECT statement as a concatenation of the schema, table name and column name. The resulting alias exceeds DB2's 30 character limit for a column.

Re: [sqlalchemy] Column alias created by SQLAlchemy is exeeding max column length of db2.

2012-04-21 Thread Michael Bayer
On Apr 21, 2012, at 7:04 PM, Yap Sok Ann wrote: Sorry to dig up an old thread. On DB2 for z/OS, the identifier length limit is 30 for column and column alias, and 128 for almost everything else:

[sqlalchemy] Column alias created by SQLAlchemy is exeeding max column length of db2.

2009-06-24 Thread Beeno
Hello Sqlalchemy appears to be aliasing each column in a SELECT statement as a concatenation of the schema, table name and column name. The resulting alias exceeds DB2's 30 character limit for a column. For example: If the name of the schema was 'myshemaname', the table was called

[sqlalchemy] Column alias created by SQLAlchemy is exeeding max column length of db2.

2009-06-24 Thread Beeno
Hello Sqlalchemy appears to be aliasing each column in a SELECT statement as a concatenation of the schema, table name and column name. The resulting alias exceeds DB2's 30 character limit for a column. For example: If the name of the schema was 'myshemaname', the table was called