Archives of the TeradataForum

Message Posted: Tue, 12 Aug 2003 @ 19:16:39 GMT

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

If you are storing the complete SQL in the log table (see below) ...

The maximum amount of text you can see (in the answer window) is limited by the width of the column. If you save it to a file (or directly export it to a file) you will see all the text.

You can also highlight the rows you want to look at and copy them to the clipboard - then paste them into notepad (or even back into the query window).

In the next release of SQL Assistant (6.2 due in November) there will be a 'Wrap Text' option that you can turn on for any cell/column/block. This will allow you to see the full text without doing any of the above.

By default, only the first 200 bytes of the query are stored in the log table. This may be your problem. You can specify how much to save when issuing the BEGIN LOGGING statement.

Try

Begin Query Logging LIMIT SQLTEXT=5000 ON username

Mike Dempsey
Teradata Client Tools

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