Archives of the TeradataForum
Message Posted: Fri, 29 Apr 2005 @ 10:01:33 GMT
| 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.