sqlstate 02000 while declaring cursor/freeing statement

Поиск
Список
Период
Сортировка
От andy rost
Тема sqlstate 02000 while declaring cursor/freeing statement
Дата
Msg-id 43135FA9.3060807@noaa.gov
обсуждение исходный текст
Ответы Re: sqlstate 02000 while declaring cursor/freeing statement  ("Thomas F. O'Connell" <tfo@sitening.com>)
Список 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@nohrsc.nws.gov
http://www.nohrsc.nws.gov
--------------------------------------------------------------------------------



В списке pgsql-admin по дате отправления:

Предыдущее
От: "Antonio Caetano"
Дата:
Сообщение: Unsubscribe
Следующее
От: Jason Stone
Дата:
Сообщение: Re: password authentication with external passwd file