Re: Why can't this work? (select first N into temp t1)

Posted in 2000

Topics: SQL Development & Query Writing, Platform-Specific Issues, Versions, Editions & End-of-Life

Obnoxio The Clown — Tue, 18 Jul 2000 19:55:04 BST — source: Informix-list mailing list archive (1991-1998)

From: Zandy <zandymNOzaSPAM@yahoo.com.invalid> > >IDS 7.31 UC6 on Solaris > >SQL: select first N into temp temp1 > >I was wondering if someone could provide me a logical >explanation as to why this isn't possible. > >I'm gettting a 944 error saying: > >"Cannot use "first" in this context. >This statement uses FIRST N inside a subquery. This action is >not supported. >Review the use of FIRST N and check that it is applied only to >the outer main query SELECT clause." Did you actually read the error message? I believe the answer is in there somewhere... ________________________________________________________________________ Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com

↪ replying to Obnoxio The Clown

Zandy — Wed, 19 Jul 2000 08:58:28 -0700 — source: Informix-list mailing list archive (1991-1998)

I know, i know, it isn't supported yet. But what would it take to support this particular feature? I don't think it would be that hard to implement it. But what do I know? :-) Also, I've tested this with 9.2 and it still doesn't work. Maybe I'll call them for a feature request. Thanks anyway, Zandy ----------------------------------------------------------- Got questions? Get answers over the phone at Keen.com. Up to 100 minutes free! http://www.keen.com