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.
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 |
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 |