SQLCODE==-209

Поиск
Список
Период
Сортировка
От John Summerfield
Тема SQLCODE==-209
Дата
Msg-id Pine.LNX.4.33.0109131736500.30958-100000@dugite.os2.ami.com.au
обсуждение исходный текст
Ответы Re: SQLCODE==-209
Список pgsql-bugs
I'm using 7.2devel from CVS, and as I've already reported, the documentation doesn't build.

Consequently I'm forced to rely on documentation for 7.1.2/3 which does not mention -209, at least in the ecpg
documentationI'm looking at, 

Nore does it appear in the DB2 documentation I'm using as second recourse.

The error text doesn't mean anything to me either:
Search name(/var/share/pgtest/testdata)
Error in statement 'check filename':
 sqlcaid(SQLCA   ) sqlabc(140) sqlcode(-209)  msg(NULL value without indicator in line 121.)
sqlerrp(NOT SET ) OID(%) NROWS(%)
sqlwarn() sqlext()

sql error NULL value without indicator in line 121.
pgtest@possum c$


Here is the relevant code:
        exec sql begin declare section;
        char *name = fileName;
        int  i_filesize;
        int  i_records = transactionRecords;
        exec sql end declare section;
        struct stat fileinfo;
        if (-1 == stat(name,&fileinfo))
        {
            fprintf(stderr, "Error checking file info for %s: %s\n",
                name, strerror(errno));
        }
        i_filesize=fileinfo.st_size;
        printf("name(%s), size(%d) records(%d)\n",name, i_filesize, i_records);
        exec sql insert into tsj0601_loaded_files
            (name, filesize, records)
            values (
                :name,
                :i_filesize,
                :i_records
                );


What I hope for is
a) An explanation as to what's wrong
b) Someone to ensure that it's documented, or correct the code if it should be some other number.

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

Предыдущее
От: Tomasz Myrta
Дата:
Сообщение: dynamic date
Следующее
От: "pie yves"
Дата:
Сообщение: problem with foreign key