Archives of the TeradataForum

Message Posted: Thu, 15 Feb 2007 @ 19:25:16 GMT

	<Prev	Next>		<<First	<Prev	Next>	Last>>

Thanks Rommel. The 'Substr(SqlTextInfo, 1, 16000)' works fine.

Actually, We tried doing a Cast the column and ended up with a max value of 2886 in the query as given below.

     Select Cast(SqlTextInfo as Varchar(2886))
     from dbc.QryLogSQl group by 1;

Even having 2887 charactes gives the error 'A Data row is too long'. Not sure, what is this limit of 2886 values being allowed.

I would appreciate if somebody can let me know where and how you can change the SysMaxRow value.

Regards,

Sam

	<Prev	Next>		<<First	<Prev	Next>	Last>>