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:
>
> http://publib.boulder.ibm.com/infocenter/dzichelp/v2r2/index.jsp?topic=%2Fcom.ibm.db2z9.d
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 f
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
'mytablename'
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
'mytablename'
