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

Reply via email to