From: andy rost <andy.rost@noaa.gov>
To: pgsql-sql@postgresql.org
Subject: sqlstate 02000 while declaring cursor/freeing prepared statements
Date: Mon, 29 Aug 2005 14:28:24 -0500
Message-ID: <431361D8.8050900@noaa.gov> (raw)
I'm new to the PostgreSQL community so please pardon what is probably a
silly question. Also, this is my first attempt at posting so you might
have seen this already (Sorry!) ...
I'm in the process of porting Informix ESQL to PostgreSQL. I
occasionally get sqlcode = 100 and sqlstate = 02000 when declaring
cursors or freeing prepared statements. Is this normal? For example:
$declare loop1 cursor with hold for
select distinct ( tabname )
from meta ;
results in sqlca.sqlcode = 100 and sqlca.sqlstate = '02000'
--
--------------------------------------------------------------------------------
Andrew Rost
National Operational Hydrologic Remote Sensing Center (NOHRSC)
National Weather Service, NOAA
1735 Lake Dr. West, Chanhassen, MN 55317-8582
Voice: (952)361-6610 x 234
Fax: (952)361-6634
arost@nohrsc.nws.gov
http://www.nohrsc.nws.gov
--------------------------------------------------------------------------------
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: andy.rost@noaa.gov
Subject: Re: sqlstate 02000 while declaring cursor/freeing prepared statements
In-Reply-To: <431361D8.8050900@noaa.gov>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox