Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Fri, 29 Apr 2005 @ 10:01:33 GMT


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


Subj:   Re: Queryman vs interagate and ODBC
 
From:   Victor Sokovin

  This explaination was provided by Mike Dempsky & if it comes to SQL Assitant I just take his word for it ;)  


Who is Mr Dempsky? Sounds like Mike has moved to Poland and changed the name?


  The upside I'm seeing is that one could better develop queries intended to run in BTEQ on SQL Assistant. With the format-clause not being honored people tend to explicitely cast the data to char just to see the results in the format they whish. Obviously this is not necessary when running on BTEQ, but it's easy to forget & just keep the cast in (thus consuming resources on the RDBMS unnecessarily.)  


Jokes aside, I must admit I could not get interagate working last time I tried (it was quite some time ago, so this remark is not intented for any current version and perhaps it is worthless even for the version I was using back then), and as I never touched it ever since I cannot compare it with SQLA. My understanding is that it is almost inevitable to switch once in a while between Bteq and SQLA. I am used to it, and do not expect a one-for-all tool. Just my feeling on this.


Regards,

Victor



     
  <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: 27 Dec 2016