Michal Wójcik wrote: > I am new with SAP DB, but I found a problem: > When I am executed following query: > SELECT FROM IndexQueue WHERE Car_Id <= 900 AND Car_Id IN > (SELECT Card.Car_Id > FROM Card, DtdForDivision WHERE Int_Id = 2 AND Dii_Id = > Dii_DivisionId) > > I received error: > [SAP AG][SQLOD32 DLL][SAP DB]General error;-9111 POS(1) > System error: Move > error. > > I found that this error is caused by sub query, no matter > what there is, eg: > SELECT FROM IndexQueue WHERE Car_Id <= 900 AND Car_Id IN > (SELECT Card.Car_Id > FROM Card) > > This situation exists, when column Car_Id from IndexQueue has > no primary key > (even if index exists). This problem disappeared when I > created primary key > for Car_Id column.
Please provide the kernel version and the knldiag.err of your database because there is more information about this error. Kind regards, Holger SAP Labs Berlin _______________________________________________ sapdb.general mailing list [EMAIL PROTECTED] http://listserv.sap.com/mailman/listinfo/sapdb.general
