Archives of the TeradataForum

Message Posted: Wed, 04 Jun 2014 @ 13:36:09 GMT


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

Subj:		Re: How to get complete SQL by Combining DBQLSQLTBL and DBQLOGTBL

From:		Dave Wellman

Hi Sravan,

I think you're saying that the sqltextinfo column gets written if a '.txt' file on your pc. That is happening because the sqltextinfo column is treated by sqla as a 'large object'. What you can do is when the dialog box id displayed that allows you to enter a file name, click 'cancel' and you should get the full sqltextinfo displayed in the normal answer set window.

Cheers,

Dave

Ward Analytics Ltd - Information in motion (www.ward-analytics.com)