From: | andy rost <andy(dot)rost(at)noaa(dot)gov> |
---|---|
To: | pgsql-admin(at)postgresql(dot)org |
Subject: | sqlstate 02000 while declaring cursor/freeing statement |
Date: | 2005-08-29 19:19:05 |
Message-ID: | 43135FA9.3060807@noaa.gov |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin |
I'm new to the PostgreSQL community so please pardon what is probably a
silly question ...
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(at)nohrsc(dot)nws(dot)gov
http://www.nohrsc.nws.gov
--------------------------------------------------------------------------------
From | Date | Subject | |
---|---|---|---|
Next Message | Thomas F. O'Connell | 2005-08-29 19:58:38 | Re: Numerical variables in pqsql statements |
Previous Message | Antonio Caetano | 2005-08-29 19:18:24 | Unsubscribe |