 |
 |
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
| |
