From: | Dragan Matić <mlists(at)panforma(dot)co(dot)yu> |
---|---|
To: | pgsql-admin(at)postgresql(dot)org |
Subject: | Re: PG 7.3.4 VS PG 8.0.3 Problem |
Date: | 2005-08-10 10:22:45 |
Message-ID: | 42F9D575.5010103@panforma.co.yu |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin pgsql-odbc |
Chris Hoover wrote:
>Sorry, I should have given some setup details.
>
>
>When this query is run against either version of PG, it does not
>return any rows (obviously due to the issue with hdr_create_dt). I
>actually walked through the code using our cobol debugger to find this
>issue. When it checks the sqlca.sqlcode record returned by this query
>in 7.3.4, it has a 0. In 8.0.3, it has a 100.
>
>
>
We are also using Cobol (Micro Focus NetExpress) and we haven't noticed
any changes when moving from version 7.x to version 8.
Another question is whether sqlcode was returning good result until now?
As far as I know (and it works that way with us) sqlcode _should_ have a
value of 100 when query returns no rows. Value of 0 indicates there were
no errors, and value of 100 means 'no rows found'.
With Regards
Dragan Matic
From | Date | Subject | |
---|---|---|---|
Next Message | James Thompson | 2005-08-10 13:36:43 | Re: problem during amrestore |
Previous Message | Tom Lane | 2005-08-10 02:27:57 | Re: problem during amrestore |
From | Date | Subject | |
---|---|---|---|
Next Message | Josef Springer | 2005-08-10 11:58:28 | Re: psqlodbclibpq 8_1_03 unicode problem |
Previous Message | Oliver Elphick | 2005-08-10 09:42:20 | Re: Updates to page on using psqlodbc with Debian |