Re: Insert into ... select from ... creates error -284

If the statement is indeed as you outlined it (no subqueries) it could be a trigger on T1 performing some actions that lead to this error. Octav On Tue, Nov 09, 1999 at 08:01:05PM +0000, joel_anderson@prosolution.com wrote: > I have a simple insert statement that loads about 60,000 rows of 1.5 > million rows and then aborts with the error: > (-284) A subquery has returned not exactly one row. > > The statement looks like this: > > INSERT INTO T1 (C1, C2, C3) > SELECT X1, X2, X3 > FROM T2;> > I have run this and similar statements many times before without errors. > > Any ideas on what could be causing this? > > I am running IDS 7.3 TC7 on an NT. > > > Sent via Deja.com http://www.deja.com/ > Before you buy. -- Octav Chiriac Phone: (373) 2 22 99 67 NetInfo S.R.L. Fax: (373) 2 21 36 59 Chisinau (373) 2 22 84 88 Moldova, Republic of mailto:com@netinfo-moldova.com

Octav Chiriac wrote: > > If the statement is indeed as you outlined it (no subqueries) > it could be a trigger on T1 performing some actions that lead to > this error. Or even a check constraint performing a query. Art S. Kagel > Octav > > On Tue, Nov 09, 1999 at 08:01:05PM +0000, joel_anderson@prosolution.com wrote: > > I have a simple insert statement that loads about 60,000 rows of 1.5 > > million rows and then aborts with the error: > > (-284) A subquery has returned not exactly one row. > > > > The statement looks like this: > > > > INSERT INTO T1 (C1, C2, C3) > > SELECT X1, X2, X3 > > FROM T2;> > > > I have run this and similar statements many times before without errors. > > > > Any ideas on what could be causing this? > > > > I am running IDS 7.3 TC7 on an NT. > > > > > > Sent via Deja.com http://www.deja.com/ > > Before you buy. > > -- > Octav Chiriac Phone: (373) 2 22 99 67 > NetInfo S.R.L. Fax: (373) 2 21 36 59 > Chisinau (373) 2 22 84 88 > Moldova, Republic of mailto:com@netinfo-moldova.com