On Tue, Aug 09, 2005 at 01:27:55PM -0400, Chris Hoover wrote: > When I connect to a 7.3.4 database, the query returns 0 rows and a > sqlca.sqlcode of 0 > > However, when I connect to an 8.0.3 database, the query returns 0 rows > and a sqlca.sqlcode of 100. You don't mention it but it sounds like you're using ECPG. Can you post a simple but complete example that works differently in 7.3.4 and 8.0.3? I just did some tests with 7.3.10 and 8.0.3 and both returned a sqlca.sqlcode of 100 for a query that returned no rows. Either something changed between 7.3.4 and 7.3.10 or my test didn't duplicate what you're doing. -- Michael Fuhr
