Skip site navigation (1) Skip section navigation (2)

sqlstate 02000 while declaring cursor/freeing statement

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 (view raw or flat)
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
--------------------------------------------------------------------------------



Responses

pgsql-admin by date

Next:From: Thomas F. O'ConnellDate: 2005-08-29 19:58:38
Subject: Re: Numerical variables in pqsql statements
Previous:From: Antonio CaetanoDate: 2005-08-29 19:18:24
Subject: Unsubscribe

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group