SQLCODE==-209

From: John Summerfield <pgtest(at)os2(dot)ami(dot)com(dot)au>
To: PostgreSQL Bugs <pgsql-bugs(at)postgresql(dot)org>
Subject: SQLCODE==-209
Date: 2001-09-13 09:42:38
Message-ID: Pine.LNX.4.33.0109131736500.30958-100000@dugite.os2.ami.com.au
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs pgsql-patches

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 documentation I'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(at)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.

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Peter Eisentraut 2001-09-13 18:10:31 Re: SQLCODE==-209
Previous Message pgsql-bugs 2001-09-13 08:54:16 Bug #450: triggered data change violation on relation

Browse pgsql-patches by date

  From Date Subject
Next Message Bruce Momjian 2001-09-13 16:57:43 Re: Bytea string operator support
Previous Message Bruce Momjian 2001-09-12 18:24:31 Re: Configuring fdatasync for Solaris2