The SQL statement is not correct. (However this is not the cause of the 81002 error.)
GROUP is a reserved word, as in GROUP BY. Therefore, the column name GROUP must be a quoted identifier. For example: SELECT A.MEM.ID, A.REG.BEG.DT, A.REG.END.DT, A."GROUP" FROM MEM.REG.HIST A WHERE A.MEM.ID = 'XXXXX*01'; ----- Original Message ----- From: David Sidhu Date: Mon, 2 Feb 2004 14:53:24 -0800 To: 'U2 Users Discussion List' Subject: UCI Error Anyone know what this error is when using UCI? I got it after running a query numerous times with different id's. I checked the sql statement and the ID both are correct. Just after a four thousand iterations I get this error. �ERROR!!!!!! SQLExecDirect �Died in SQLExecDirect with SQLSTATE IM985 �Native error: 81002 [IBM][SQL Client][RPC] error code = 81002 The Query is simply: SELECT A.MEM.ID, A.REG.BEG.DT, A.REG.END.DT, A.GROUP FROM MEM.REG.HIST A WHERE A.MEM.ID = 'XXXXX*01'; Where the X's is the id number. Thanks, Dave � > > _______________________________________________ > u2-users mailing list > [EMAIL PROTECTED] > http://www.oliver.com/mailman/listinfo/u2-users _______________________________________________ u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
