 |
 |
Archives of the TeradataForum
Message Posted: Fri, 23 Mar 2001 @ 20:37:56 GMT
| Subj: | | With statement |
| |
| From: | | Frank Martinez |
Hola, amigos de la lista,
Hey, I've got a question that bugs me, but it not really critical. I remember when I first heard of the WITH clause, I thought,
"This is cool", but then couldn't do it in Queryman. In fact QMan gave a specific message saying that it didn't support it. So
then, when playing with inTERAgate at the last place I was at, I finally got to see and appreciate the power of the WITH statement.
So when I got back home to Utah after being in foreign countries like Chile, Argentina, Mexico and New York, I quickly installed
inTERAgate (great free software by Jim Calvert!) and the WITH statement didn't work from there! I thought that I was going crazy,
but then realized that I had set inTERAgate to use ODBC instead of CLI! In fact, inTERAgate bombed (oops, guess I owe Calvert a note
on that one). But when I switched to using CLI, the WITH statement started working. Is this a factor of the ODBC driver I'm using
(whoa, this machine has 2.06, guess I'd better get a more current version)? In other words, is it fixed in new versions? Anybody
know?
iv
Frank C. Martinez IV
| |
