niXforums Forum Index
 FAQFAQ   SearchSearch   MemberlistMemberlist   UsergroupsUsergroups   RegisterRegister 
 ProfileProfile   PreferencesPreferences   Log in to check your private messagesLog in to check your private messages   Log inLog in 
·  nixdoc.net ·  man pages ·  Linux HOWTOs ·  FreeBSD Tips ·  Forums
navigation Forum index » Databases » rdb
rdb error
Post new topic   Reply to topic Page 1 of 1 [2 Posts] View previous topic :: View next topic
Author Message
Bob M. Lee
*nix forums beginner


Joined: 07 May 2005
Posts: 2

PostPosted: Sat May 07, 2005 2:20 am    Post subject: Re: rdb error Reply with quote
<beersh@gmail.com> wrote in message
news:1109089174.956248.87500@c13g2000cwb.googlegroups.com...
Quote:
I need to duplicate rows in a table with unique index using sql.
I try to run this statement:

insert into
MINUY_MADRICHIM(TAARICH_MINUY_ME,TAARICH_MINUY_AD,SUG_TEUDA,
ZEHUT_MORE,TAARICH_HAFAKAT_MINUY,MAKOR_TAKZIV,SAL_HADRACHA,MINHAL,
YECHIDA,TCHUM,ZEHUT_MEFAKEACH,STATUS_MINUY_HADRACHA,YOM_HADRACHA,
SEVEV_HADRACHA,MOSAD_HADRACHA,SHAOT_HADRACHA,BASIS_MISRA,
PITZUL_MISRA,TAA_IDKUN,SUG_MAKOR_MEDA,MAKOR_MEDA,MACHOZ_MEADKEN,
MACHOZ_MAAVIR,TAARICH_HAAVARA_ME_MACHOZ,TAHALICH_MAAVIR)
values ('1-sep-2004', '31-aug-2005',(select SUG_TEUDA,ZEHUT_MORE,
TAARICH_HAFAKAT_MINUY,MAKOR_TAKZIV,SAL_HADRACHA,MINHAL,YECHIDA,
TCHUM,ZEHUT_MEFAKEACH,STATUS_MINUY_HADRACHA,YOM_HADRACHA,
SEVEV_HADRACHA,MOSAD_HADRACHA,SHAOT_HADRACHA,BASIS_MISRA,
PITZUL_MISRA,TAA_IDKUN,SUG_MAKOR_MEDA ,MAKOR_MEDA,MACHOZ_MEADKEN,
MACHOZ_MAAVIR,TAARICH_HAAVARA_ME_MACHOZ,TAHALICH_MAAVIR from
MINUY_MADRICHIM where TAARICH_MINUY_ME = '1-sep-2003' and
TAARICH_MINUY_AD = '31-aug-2004'));

And I get this error message:

%SQL-F-SUBTOOVAL, Column select expression specifies too many columns.

Did any one have an idea how can I fix this problem?


The problem is the nested SELECT statement: It does not return an atomic
list value
for the third argument of the INSERT statement's VALUES list.

The nested SELECT returns a ROW of values as the third argument,
when only one atomic value can be accepted.

Here's a possible - though ugly - fix:

SQL> insert into
MINUY_MADRICHIM
(TAARICH_MINUY_ME,
TAARICH_MINUY_AD,
SUG_TEUDA,
ZEHUT_MORE,
TAARICH_HAFAKAT_MINUY,
MAKOR_TAKZIV,
SAL_HADRACHA,
MINHAL,
YECHIDA,
TCHUM,
ZEHUT_MEFAKEACH,
STATUS_MINUY_HADRACHA,
YOM_HADRACHA,
SEVEV_HADRACHA,
MOSAD_HADRACHA,
SHAOT_HADRACHA,
BASIS_MISRA,
PITZUL_MISRA,
TAA_IDKUN,
SUG_MAKOR_MEDA,
MAKOR_MEDA,
MACHOZ_MEADKEN,
MACHOZ_MAAVIR,
TAARICH_HAAVARA_ME_MACHOZ,
TAHALICH_MAAVIR)
values
('1-sep-2004',
'31-aug-2005',
(select SUG_TEUDA from
MINUY_MADRICHIM where TAARICH_MINUY_ME = '1-sep-2003' and
TAARICH_MINUY_AD = '31-aug-2004'
limit to 1 row),
(select ZEHUT_MORE from
MINUY_MADRICHIM where TAARICH_MINUY_ME = '1-sep-2003' and
TAARICH_MINUY_AD = '31-aug-2004'
limit to 1 row),
(select TAARICH_HAFAKAT_MINUY from
MINUY_MADRICHIM where TAARICH_MINUY_ME = '1-sep-2003' and
TAARICH_MINUY_AD = '31-aug-2004'
limit to 1 row),
(select MAKOR_TAKZIV from
MINUY_MADRICHIM where TAARICH_MINUY_ME = '1-sep-2003' and
TAARICH_MINUY_AD = '31-aug-2004'
limit to 1 row),
(select SAL_HADRACHA from
MINUY_MADRICHIM where TAARICH_MINUY_ME = '1-sep-2003' and
TAARICH_MINUY_AD = '31-aug-2004'
limit to 1 row),
(select MINHAL from
MINUY_MADRICHIM where TAARICH_MINUY_ME = '1-sep-2003' and
TAARICH_MINUY_AD = '31-aug-2004'
limit to 1 row),
(select YECHIDA from
MINUY_MADRICHIM where TAARICH_MINUY_ME = '1-sep-2003' and
TAARICH_MINUY_AD = '31-aug-2004'
limit to 1 row),
(select TCHUM from
MINUY_MADRICHIM where TAARICH_MINUY_ME = '1-sep-2003' and
TAARICH_MINUY_AD = '31-aug-2004'
limit to 1 row),
(select ZEHUT_MEFAKEACH from
MINUY_MADRICHIM where TAARICH_MINUY_ME = '1-sep-2003' and
TAARICH_MINUY_AD = '31-aug-2004'
limit to 1 row),
(select STATUS_MINUY_HADRACHA
from
MINUY_MADRICHIM where TAARICH_MINUY_ME = '1-sep-2003' and
TAARICH_MINUY_AD = '31-aug-2004'
limit to 1 row),
(select YOM_HADRACHA from
MINUY_MADRICHIM where TAARICH_MINUY_ME = '1-sep-2003' and
TAARICH_MINUY_AD = '31-aug-2004'
limit to 1 row),
(select SEVEV_HADRACHA from
MINUY_MADRICHIM where TAARICH_MINUY_ME = '1-sep-2003' and
TAARICH_MINUY_AD = '31-aug-2004'
limit to 1 row),
(select MOSAD_HADRACHA from
MINUY_MADRICHIM where TAARICH_MINUY_ME = '1-sep-2003' and
TAARICH_MINUY_AD = '31-aug-2004'),
(select SHAOT_HADRACHA from
MINUY_MADRICHIM where TAARICH_MINUY_ME = '1-sep-2003' and
TAARICH_MINUY_AD = '31-aug-2004'
limit to 1 row),
(select BASIS_MISRA from
MINUY_MADRICHIM where TAARICH_MINUY_ME = '1-sep-2003' and
TAARICH_MINUY_AD = '31-aug-2004'
limit to 1 row),
(select PITZUL_MISRA from
MINUY_MADRICHIM where TAARICH_MINUY_ME = '1-sep-2003' and
TAARICH_MINUY_AD = '31-aug-2004'
limit to 1 row),
(select TAA_IDKUN from
MINUY_MADRICHIM where TAARICH_MINUY_ME = '1-sep-2003' and
TAARICH_MINUY_AD = '31-aug-2004'
limit to 1 row),
(select SUG_MAKOR_MEDA from
MINUY_MADRICHIM where TAARICH_MINUY_ME = '1-sep-2003' and
TAARICH_MINUY_AD = '31-aug-2004'
limit to 1 row),
(select MAKOR_MEDA from
MINUY_MADRICHIM where TAARICH_MINUY_ME = '1-sep-2003' and
TAARICH_MINUY_AD = '31-aug-2004'
limit to 1 row),
(select MACHOZ_MEADKEN from
MINUY_MADRICHIM where TAARICH_MINUY_ME = '1-sep-2003' and
TAARICH_MINUY_AD = '31-aug-2004'
limit to 1 row),
(select MACHOZ_MAAVIR from
MINUY_MADRICHIM where TAARICH_MINUY_ME = '1-sep-2003' and
TAARICH_MINUY_AD = '31-aug-2004'
limit to 1 row),
(select TAARICH_HAAVARA_ME_MACHOZ
from
MINUY_MADRICHIM where TAARICH_MINUY_ME = '1-sep-2003' and
TAARICH_MINUY_AD = '31-aug-2004'
limit to 1 row),
(select TAHALICH_MAAVIR from
MINUY_MADRICHIM where TAARICH_MINUY_ME = '1-sep-2003' and
TAARICH_MINUY_AD = '31-aug-2004'
limit to 1 row)
);
Back to top
beersh@gmail.com
*nix forums beginner


Joined: 22 Feb 2005
Posts: 1

PostPosted: Tue Feb 22, 2005 3:19 pm    Post subject: rdb error Reply with quote
I need to duplicate rows in a table with unique index using sql.
I try to run this statement:

insert into
MINUY_MADRICHIM(TAARICH_MINUY_ME,TAARICH_MINUY_AD,SUG_TEUDA,
ZEHUT_MORE,TAARICH_HAFAKAT_MINUY,MAKOR_TAKZIV,SAL_HADRACHA,MINHAL,
YECHIDA,TCHUM,ZEHUT_MEFAKEACH,STATUS_MINUY_HADRACHA,YOM_HADRACHA,
SEVEV_HADRACHA,MOSAD_HADRACHA,SHAOT_HADRACHA,BASIS_MISRA,
PITZUL_MISRA,TAA_IDKUN,SUG_MAKOR_MEDA,MAKOR_MEDA,MACHOZ_MEADKEN,
MACHOZ_MAAVIR,TAARICH_HAAVARA_ME_MACHOZ,TAHALICH_MAAVIR)
values ('1-sep-2004', '31-aug-2005',(select SUG_TEUDA,ZEHUT_MORE,
TAARICH_HAFAKAT_MINUY,MAKOR_TAKZIV,SAL_HADRACHA,MINHAL,YECHIDA,
TCHUM,ZEHUT_MEFAKEACH,STATUS_MINUY_HADRACHA,YOM_HADRACHA,
SEVEV_HADRACHA,MOSAD_HADRACHA,SHAOT_HADRACHA,BASIS_MISRA,
PITZUL_MISRA,TAA_IDKUN,SUG_MAKOR_MEDA ,MAKOR_MEDA,MACHOZ_MEADKEN,
MACHOZ_MAAVIR,TAARICH_HAAVARA_ME_MACHOZ,TAHALICH_MAAVIR from
MINUY_MADRICHIM where TAARICH_MINUY_ME = '1-sep-2003' and
TAARICH_MINUY_AD = '31-aug-2004'));

And I get this error message:

%SQL-F-SUBTOOVAL, Column select expression specifies too many columns.

Did any one have an idea how can I fix this problem?

Thanks
Back to top
Google
Back to top
Display posts from previous:   
Post new topic   Reply to topic Page 1 of 1 [2 Posts] View previous topic :: View next topic
The time now is Thu Jan 08, 2009 5:07 am | All times are GMT
navigation Forum index » Databases » rdb
Jump to:  

Similar Topics
Topic Author Forum Replies Last Post
No new posts Postfix + MySQL error: very strange variable %s iWarior Postfix 0 Mon Aug 25, 2008 2:01 pm
No new posts ** Postfix error on console every minute or so ** ?? drywash Postfix 0 Fri Jul 04, 2008 8:49 pm
No new posts Postfix error bounce diwash Postfix 0 Fri Mar 28, 2008 3:37 am
No new posts I am getting following error in Aix 5.3 rockcharles1 AIX 0 Tue Aug 28, 2007 11:06 pm
No new posts postfix out of memory error - please help metind Postfix 0 Mon Sep 11, 2006 1:54 am

Bentley Autos | Debt Consolidation | Myspace Layouts | Credit Cards UK | Fish Tank Help
Copyright © 2004-2005 DeniX Solutions SRL
 
Other DeniX Solutions sites: Unix/Linux blog |  electronics forum |  medicine forum |  science forum | 
Privacy Policy


Powered by phpBB © 2001, 2005 phpBB Group

[ Time: 0.1797s ][ Queries: 20 (0.1000s) ][ GZIP on - Debug on ]