Home Page for the TeradataForum
 

Archives of the TeradataForum

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


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


Subj:   Re: Queryman is not showing entire text
 
From:   Dempsey, Mike

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>>
 
 
 
 
 
 
 
 
 
  
  Top Home Privacy Feedback  
 
 
Copyright for the TeradataForum (TDATA-L), Manta BlueSky    
Copyright 2016 - All Rights Reserved    
Last Modified: 15 Jun 2023