RE: UCI Error
Hmmm, your client-side C program should have UCI configuration file too. Options: a) turn on client side debugging and b) creating a UCI configuration file on the client side, increasing the values I posted earlier (may help, not sure what the issue you're having is though). BTW...Did you read the UCI manual about client-side debugging logs? See page 47. <http://publibfi.boulder.ibm.com/epubs/pdf/25119060.pdf> http://publibfi.boulder.ibm.com/epubs/pdf/25119060.pdf Regards, David Logging Client Connections Beginning at UniVerse 10.0, a server-side debugging log is available for tracking client connections. The debugging log is located in the /tmp/ directory on UNIX, or C:\tmp on Windows platforms, by default. Complete the following steps to set up the debugging log:1. Edit the serverdebug file in the UVHOME directory. 2. In the first column, enter uvcs, indicating that you want to log the connection progress for both uvapi_server and uvapi_slave. 3. In the next column, enter an integer indicating the level of logging infor-mation you want to maintain. The valid integers are: 0 - No debugging. 1 - Captures information about the startup connection only. 9 - Captures information about every call. 4. In the third column, enter the full path for the log file location. If this value does not exist, the logs are written to /tmp/uvapiserver_###.log as the default on UNIX systems, or C:\tmp\uvapiserver.log as the default on Windows systems. is the uvapi_server process ID. -Original Message- From: [EMAIL PROTECTED] [ <mailto:[EMAIL PROTECTED]> mailto:[EMAIL PROTECTED] Behalf Of David Sidhu Sent: Thursday, February 05, 2004 5:58 AM To: 'U2 Users Discussion List' Subject: RE: UCI Error Would this be in my UCI directory on the Oracle Server - if so, then I don't have the file. It does exist on the UniVerse Server and looks like this: ** * * Allow access to local host * * Module%M% Version %I% Date%H% * * (c) Copyright 2002 IBM Corporation. - All Rights Reserved * This is unpublished proprietary source code of IBM Corporation. * The copyright notice above does not evidence any actual or intended * publication of such source code. * * This is the configuration file for the BCI and the UCI. For more * information, see either the BASIC SQL Client Interface Guide or the * UniVerse Call Interface Guide. * * This file is NOT part of UV/ODBC. However, it can affect UV/ODBC, * becuase UV/ODBC communicates with UniVerse using the UCI. For more * information, see the UV/ODBC Server Guide. * * *** * * Maintenence log - insert most recent change descriptions at top * * Date GTAR# WHO Description. * 10/14/98 23801 SAP Change copyrights. * 05/09/97 20582 MJC Add comment at top * 04/26/95 15921 ENF Initial submission * *** [ODBC DATA SOURCES] DBMSTYPE = UNIVERSE network = TCP/IP service = uvserver host = localhost Thanks, Dave -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
RE: UCI Error
Would this be in my UCI directory on the Oracle Server - if so, then I don't have the file. It does exist on the UniVerse Server and looks like this: ** * * Allow access to local host * * Module %M% Version %I% Date%H% * * (c) Copyright 2002 IBM Corporation. - All Rights Reserved * This is unpublished proprietary source code of IBM Corporation. * The copyright notice above does not evidence any actual or intended * publication of such source code. * * This is the configuration file for the BCI and the UCI. For more * information, see either the BASIC SQL Client Interface Guide or the * UniVerse Call Interface Guide. * * This file is NOT part of UV/ODBC. However, it can affect UV/ODBC, * becuase UV/ODBC communicates with UniVerse using the UCI. For more * information, see the UV/ODBC Server Guide. * * *** * * Maintenence log - insert most recent change descriptions at top * * Date GTAR# WHO Description. * 10/14/98 23801 SAP Change copyrights. * 05/09/97 20582 MJC Add comment at top * 04/26/95 15921 ENF Initial submission * *** [ODBC DATA SOURCES] DBMSTYPE = UNIVERSE network = TCP/IP service = uvserver host = localhost Thanks, Dave -Original Message- From: Hona, David S [mailto:[EMAIL PROTECTED] Sent: Tuesday, February 03, 2004 11:33 PM To: 'U2 Users Discussion List' Subject: RE: UCI Error Ah, forgot to ask what your uvodbc.config (or is called uci.config in UV 10.x?) file looks like on the client side (your Oracle server). On one of our client servers the uvodbc.config has this section at the end of the file... these parameters are documented in the UCI manual (somewhere). [UNIVERSE] MAXFETCHBUFF = 32768 MAXFETCHCOLS = 1000 -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of David Sidhu Sent: Wednesday, February 04, 2004 5:04 AM To: 'U2 Users Discussion List' Subject: RE: UCI Error UV version? UniVerse version - 10.0.6 OS version? UniVerse Box OS - HP/UX 11.0 What is the "different server"? Oracle Box OS - HP/UX 11.0 Does this query complete from the TCL prompt on the UV server? YES -Original Message- From: Hona, David S [mailto:[EMAIL PROTECTED] Sent: Monday, February 02, 2004 9:32 PM To: 'U2 Users Discussion List' Subject: RE: UCI Error UV version? OS version? What is the "different server"? Does this query complete from the TCL prompt on the UV server? -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of David Sidhu Sent: Tuesday, February 03, 2004 10:11 AM To: 'U2 Users Discussion List' Subject: RE: UCI Error Does anyone know if there is some time out variable in Universe that would cause this or maybe something that kicks my connection after a certain time (only a couple minutes) or kicks me due to memory faults? I'm connecting from a different Server to the Universe Server. I've never worked with Universe before so anything would help, Thanks, Dave -Original Message- From: Logan, David (SST - Adelaide) [mailto:[EMAIL PROTECTED] Sent: Monday, February 02, 2004 3:03 PM To: U2 Users Discussion List Subject: RE: UCI Error Hi David, The docs say IM985 Error in RPC interface I think I would be checking the network and/or ensuring your rpc daemon is still running. The error 81002 is a universe system error >ED SYS.MESSAGE 081002 The file "SYS.MESSAGE" is read-only and cannot be updated. 2 lines long. : P 0001: unirpc: No Connection 0002: Bottom at line 2. : EX > Hope this helps Regards David Logan Database Administrator HP Managed Services 139 Frome Street, Adelaide 5000 Australia +61 8 8408 4273 +61 417 268 665 -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of David Sidhu Sent: Tuesday, 3 February 2004 9:23 AM 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 = 'X*01'; Where the X's is the id number. Thanks, Dave ___ u2-users mailing list [EMAIL PROTECTED] htt
RE: UCI Error
Ah, forgot to ask what your uvodbc.config (or is called uci.config in UV 10.x?) file looks like on the client side (your Oracle server). On one of our client servers the uvodbc.config has this section at the end of the file... these parameters are documented in the UCI manual (somewhere). [UNIVERSE] MAXFETCHBUFF = 32768 MAXFETCHCOLS = 1000 -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of David Sidhu Sent: Wednesday, February 04, 2004 5:04 AM To: 'U2 Users Discussion List' Subject: RE: UCI Error UV version? UniVerse version - 10.0.6 OS version? UniVerse Box OS - HP/UX 11.0 What is the "different server"? Oracle Box OS - HP/UX 11.0 Does this query complete from the TCL prompt on the UV server? YES -Original Message- From: Hona, David S [mailto:[EMAIL PROTECTED] Sent: Monday, February 02, 2004 9:32 PM To: 'U2 Users Discussion List' Subject: RE: UCI Error UV version? OS version? What is the "different server"? Does this query complete from the TCL prompt on the UV server? -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of David Sidhu Sent: Tuesday, February 03, 2004 10:11 AM To: 'U2 Users Discussion List' Subject: RE: UCI Error Does anyone know if there is some time out variable in Universe that would cause this or maybe something that kicks my connection after a certain time (only a couple minutes) or kicks me due to memory faults? I'm connecting from a different Server to the Universe Server. I've never worked with Universe before so anything would help, Thanks, Dave -Original Message- From: Logan, David (SST - Adelaide) [mailto:[EMAIL PROTECTED] Sent: Monday, February 02, 2004 3:03 PM To: U2 Users Discussion List Subject: RE: UCI Error Hi David, The docs say IM985 Error in RPC interface I think I would be checking the network and/or ensuring your rpc daemon is still running. The error 81002 is a universe system error >ED SYS.MESSAGE 081002 The file "SYS.MESSAGE" is read-only and cannot be updated. 2 lines long. : P 0001: unirpc: No Connection 0002: Bottom at line 2. : EX > Hope this helps Regards David Logan Database Administrator HP Managed Services 139 Frome Street, Adelaide 5000 Australia +61 8 8408 4273 +61 417 268 665 -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of David Sidhu Sent: Tuesday, 3 February 2004 9:23 AM 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 = 'X*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 -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
RE: UCI Error
UV version? UniVerse version - 10.0.6 OS version? UniVerse Box OS - HP/UX 11.0 What is the "different server"? Oracle Box OS - HP/UX 11.0 Does this query complete from the TCL prompt on the UV server? YES -Original Message- From: Hona, David S [mailto:[EMAIL PROTECTED] Sent: Monday, February 02, 2004 9:32 PM To: 'U2 Users Discussion List' Subject: RE: UCI Error UV version? OS version? What is the "different server"? Does this query complete from the TCL prompt on the UV server? -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of David Sidhu Sent: Tuesday, February 03, 2004 10:11 AM To: 'U2 Users Discussion List' Subject: RE: UCI Error Does anyone know if there is some time out variable in Universe that would cause this or maybe something that kicks my connection after a certain time (only a couple minutes) or kicks me due to memory faults? I'm connecting from a different Server to the Universe Server. I've never worked with Universe before so anything would help, Thanks, Dave -Original Message- From: Logan, David (SST - Adelaide) [mailto:[EMAIL PROTECTED] Sent: Monday, February 02, 2004 3:03 PM To: U2 Users Discussion List Subject: RE: UCI Error Hi David, The docs say IM985 Error in RPC interface I think I would be checking the network and/or ensuring your rpc daemon is still running. The error 81002 is a universe system error >ED SYS.MESSAGE 081002 The file "SYS.MESSAGE" is read-only and cannot be updated. 2 lines long. : P 0001: unirpc: No Connection 0002: Bottom at line 2. : EX > Hope this helps Regards David Logan Database Administrator HP Managed Services 139 Frome Street, Adelaide 5000 Australia +61 8 8408 4273 +61 417 268 665 -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of David Sidhu Sent: Tuesday, 3 February 2004 9:23 AM 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 = 'X*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
Re: UCI Error
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 = 'X*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 = 'X*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
RE: UCI Error
UV version? OS version? What is the "different server"? Does this query complete from the TCL prompt on the UV server? -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of David Sidhu Sent: Tuesday, February 03, 2004 10:11 AM To: 'U2 Users Discussion List' Subject: RE: UCI Error Does anyone know if there is some time out variable in Universe that would cause this or maybe something that kicks my connection after a certain time (only a couple minutes) or kicks me due to memory faults? I'm connecting from a different Server to the Universe Server. I've never worked with Universe before so anything would help, Thanks, Dave -Original Message- From: Logan, David (SST - Adelaide) [mailto:[EMAIL PROTECTED] Sent: Monday, February 02, 2004 3:03 PM To: U2 Users Discussion List Subject: RE: UCI Error Hi David, The docs say IM985 Error in RPC interface I think I would be checking the network and/or ensuring your rpc daemon is still running. The error 81002 is a universe system error >ED SYS.MESSAGE 081002 The file "SYS.MESSAGE" is read-only and cannot be updated. 2 lines long. : P 0001: unirpc: No Connection 0002: Bottom at line 2. : EX > Hope this helps Regards David Logan Database Administrator HP Managed Services 139 Frome Street, Adelaide 5000 Australia +61 8 8408 4273 +61 417 268 665 -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of David Sidhu Sent: Tuesday, 3 February 2004 9:23 AM 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 = 'X*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
RE: UCI Error
Hi David, I would be checking the timeout value (field 6) in the unirpcservices file. I have cut and pasted the appropriate bits out of the manual. This is available at http://www-306.ibm.com/software/data/u2/pubs/library/100univ/univ_100.ht ml the manual that you need is the Administrative Supplement for Client APIs Hope this is of assistance. Regards About the unirpcservices File Each process that uses the UniRPC automatically configures the unirpcservices file when it first starts up. If no unirpcservices file exists, it is created in the unishared directory. On UNIX systems the default location of this file is /usr/ibm/unishared/unirpc. On Windows NT systems the default location is :\ibm\unishared\unirpc. To determine the location of the unirpcservices file on your system, do the following: On UNIX systems, execute the command: $ cat /.unishared On Windows NT systems, find the registry entry under the subkey \HKEY_LOCAL_MACHINE\SOFTWARE\ibm\unishared. When a client system requests a connection to a service on a server system, the UniRPC daemon (unirpcd) on the server uses the unirpcservices file to verify that the client system can start the requested service. The UniRPC software uses field 3 of the unirpcservices file to verify that a machine making a request for a service is allowed to do so. The following table lists the fields in the unirpcservices file: UniVerse Systems On UniVerse systems the unirpcservices file might contain entries such as the following: uvnet /usr/ibm/uv/bin/uvnetd host1,host2,host3 TCP/IP 3 3600 uvdrsrv /usr/ibm/uv/bin/uvdrsrvd * TCP/IP 0 3600 uvcs /usr/ibm/uv/bin/uvapi_server * TCP/IP 0 3600 uvfilefix /usr/ibm/uv/bin/uvfilefix_server * TCP/IP 0 3600 uvserver /usr/ibm/uv/bin/uvsrvd * TCP/IP 0 3600 The version of uv.rc shipped with UniVerse systems (/usr/ibm/uv/sample/uv.rc) contains commands that: Check for the existence of the unirpcservices file Verify that services are defined in it Start the UniRPC daemon if the file contains services The UniRPC daemon is executed as part of the UniVerse reboot procedure Field Contents 1 The name of the UniRPC service (for example, uvserver). 2 The full pathname of the service engine executed by the UniRPC daemon. 3 The names of nodes allowed to execute this service. This field is multivalued, with values separated by commas (no spaces). If the field contains * (asterisk), all hosts defined in /etc/hosts can execute this service 4 The network transport mechanism for the service (TCP/IP). 5 Reserved for future use. 6 The value (in tenths of a second) specifying how long an open connection can be idle before automatic closure from the remote connection. The default is 3600, or 6 minutes. David Logan Database Administrator HP Managed Services 139 Frome Street, Adelaide 5000 Australia +61 8 8408 4273 +61 417 268 665 -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of David Sidhu Sent: Tuesday, 3 February 2004 9:41 AM To: 'U2 Users Discussion List' Subject: RE: UCI Error Does anyone know if there is some time out variable in Universe that would cause this or maybe something that kicks my connection after a certain time (only a couple minutes) or kicks me due to memory faults? I'm connecting from a different Server to the Universe Server. I've never worked with Universe before so anything would help, Thanks, Dave -Original Message- From: Logan, David (SST - Adelaide) [mailto:[EMAIL PROTECTED] Sent: Monday, February 02, 2004 3:03 PM To: U2 Users Discussion List Subject: RE: UCI Error Hi David, The docs say IM985 Error in RPC interface I think I would be checking the network and/or ensuring your rpc daemon is still running. The error 81002 is a universe system error >ED SYS.MESSAGE 081002 The file "SYS.MESSAGE" is read-only and cannot be updated. 2 lines long. : P 0001: unirpc: No Connection 0002: Bottom at line 2. : EX > Hope this helps Regards David Logan Database Administrator HP Managed Services 139 Frome Street, Adelaide 5000 Australia +61 8 8408 4273 +61 417 268 665 -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of David Sidhu Sent: Tuesday, 3 February 2004 9:23 AM 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 = 'X*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
RE: UCI Error
Title: Message Does anyone know if there is some time out variable in Universe that would cause this or maybe something that kicks my connection after a certain time (only a couple minutes) or kicks me due to memory faults? I'm connecting from a different Server to the Universe Server. I've never worked with Universe before so anything would help, Thanks, Dave -Original Message-From: Logan, David (SST - Adelaide) [mailto:[EMAIL PROTECTED]Sent: Monday, February 02, 2004 3:03 PMTo: U2 Users Discussion ListSubject: RE: UCI Error Hi David, The docs say IM985 Error in RPC interface I think I would be checking the network and/or ensuring your rpc daemon is still running. The error 81002 is a universe system error >ED SYS.MESSAGE 081002The file "SYS.MESSAGE" is read-only and cannot be updated.2 lines long. : P0001: unirpc: No Connection0002:Bottom at line 2.: EX> Hope this helps Regards David Logan Database Administrator HP Managed Services 139 Frome Street, Adelaide 5000 Australia +61 8 8408 4273 +61 417 268 665 -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of David SidhuSent: Tuesday, 3 February 2004 9:23 AMTo: '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 = 'X*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
RE: UCI Error
Title: Message Hi David, The docs say IM985 Error in RPC interface I think I would be checking the network and/or ensuring your rpc daemon is still running. The error 81002 is a universe system error >ED SYS.MESSAGE 081002The file "SYS.MESSAGE" is read-only and cannot be updated.2 lines long. : P0001: unirpc: No Connection0002:Bottom at line 2.: EX> Hope this helps Regards David Logan Database Administrator HP Managed Services 139 Frome Street, Adelaide 5000 Australia +61 8 8408 4273 +61 417 268 665 -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of David SidhuSent: Tuesday, 3 February 2004 9:23 AMTo: '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 = 'X*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