Thread: SQLCODE==-209
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.
John Summerfield writes: > I'm using 7.2devel from CVS, and as I've already reported, the documentation doesn't build. http://www.ca.postgresql.org/devel-corner/docs/postgres/index.html > 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, 7.2 doesn't document it either... -- Peter Eisentraut peter_e@gmx.net http://funkturm.homeip.net/~peter
John Summerfield writes: > I don't normally have web access. You can download the built documentation from ftp://ftp.de.postgresql.org/pub/dev/doc/ Copy the files man.tar.gz and postgres.tar.gz into the doc/ directory of your source distribution and they will be installed automatically. > I'd much prefer the build instructions include how to build the > documentation. cd doc/src/sgml make postgres.html Requires OpenJade 1.3, DocBook DTD 3.1, and DocBook DSSSL stylesheets 1.70 or so, plus the knowledge of how to set all of this up, which in turn can be obtained from the documentation. -- Peter Eisentraut peter_e@gmx.net http://funkturm.homeip.net/~peter
Sorry all. There was a certain amount of nonsence in my previous posting on this topic. The failing sql command is an fact a select into. It fails when trying to retrieve a null value. The insert worked (I can retrieve the record if I don't ask for the null field, so evidently the insert code is correct. -209 is generated by ecpg. I still don't know what "indicator" means though. If I can reasonably be expected to understand the term, there still remains the bug that -209 is undocumented.
On Thu, 13 Sep 2001, Peter Eisentraut wrote: > John Summerfield writes: > > > I'm using 7.2devel from CVS, and as I've already reported, the documentation doesn't build. > > http://www.ca.postgresql.org/devel-corner/docs/postgres/index.html I don't normally have web access. I'd much prefer the build instructions include how to build the documentation. > > > 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, > > 7.2 doesn't document it either... > > I've not had anyone explain what it means yet. I've resorted to examining source code (while it might be the utimate documentation,it's not ideal). I've found several places it can arise, but I still have no idea what the error is. The key seems to be the meaning of the technical term "indicator." On a related matter, (I know it's related because it comes from the code which fails with this error), I think the code generatedby ecpg is wrong: /* exec sql begin declare section */ #line 134 "yahoo.load.pgc" char * name = fileName ; #line 135 "yahoo.load.pgc" int i_filesize ; #line 136 "yahoo.load.pgc" int i_records = transactionRecords ; /* exec sql end declare section */ #line 137 "yahoo.load.pgc" 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); { ECPGdo(__LINE__, NULL, "insert into tsj0601_loaded_files ( name , filesize , records ) values ( ? , ? , ? )", ECPGt_char,&(name),0L,1L,1*sizeof(char), <---- whoops ECPGt_NO_INDICATOR, NULL , 0L, 0L, 0L, ECPGt_int,&(i_filesize),1L,1L,sizeof(int), ECPGt_NO_INDICATOR, NULL , 0L, 0L, 0L, ECPGt_int,&(i_records),1L,1L,sizeof(int), ECPGt_NO_INDICATOR, NULL , 0L, 0L, 0L, ECPGt_EOIT, ECPGt_EORT); #line 152 "yahoo.load.pgc" I think this is not going to pick up the string *name. Either ecpg should reject this, or generate something like ECPGt_char,(name),0L,1L,1*strlen(name)) but then I'm not much of a C programmer. I'm going to assume that my definition of name offends ecpg and gives rise to the error -209, and try to work round it (Ihave another insert working).
I have added documentation for code 209. Looks like there are other undocumented ones. Should we document them all? > John Summerfield writes: > > > I'm using 7.2devel from CVS, and as I've already reported, the documentation doesn't build. > > http://www.ca.postgresql.org/devel-corner/docs/postgres/index.html > > > 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, > > 7.2 doesn't document it either... > > -- > Peter Eisentraut peter_e@gmx.net http://funkturm.homeip.net/~peter > > > ---------------------------(end of broadcast)--------------------------- > TIP 5: Have you checked our extensive FAQ? > > http://www.postgresql.org/users-lounge/docs/faq.html > -- Bruce Momjian | http://candle.pha.pa.us pgman@candle.pha.pa.us | (610) 853-3000 + If your life is a hard drive, | 830 Blythe Avenue + Christ can be your backup. | Drexel Hill, Pennsylvania 19026 Index: doc/src/sgml/ecpg.sgml =================================================================== RCS file: /cvsroot/pgsql/doc/src/sgml/ecpg.sgml,v retrieving revision 1.23 diff -c -r1.23 ecpg.sgml *** doc/src/sgml/ecpg.sgml 2001/09/13 15:55:22 1.23 --- doc/src/sgml/ecpg.sgml 2001/10/11 20:04:49 *************** *** 332,337 **** --- 332,347 ---- </varlistentry> <varlistentry> + <term><computeroutput>-209, NULL value without indicator in line %d.</computeroutput></term> + <listitem> + <para> + <productname>Postgres</productname> returned <symbol>ECPG_MISSING_INDICATOR</symbol> + because a NULL was returned and no NULL indicator variable was supplied. + </para> + </listitem> + </varlistentry> + + <varlistentry> <term><computeroutput>-220, No such connection %s in line %d.</computeroutput></term> <listitem> <para>
> On Thu, 11 Oct 2001, Bruce Momjian wrote: > > > > > > I have added documentation for code 209. Looks like there are other > > undocumented ones. Should we document them all? > > If you're asking me, I'm all in favour of documenting them;-) > > I'm not a fan of "Read the source," though I do it if I'm desperate. I can easily document them all if it would help people. Seems you can't really test error codes in your app unless you know the codes. -- Bruce Momjian | http://candle.pha.pa.us pgman@candle.pha.pa.us | (610) 853-3000 + If your life is a hard drive, | 830 Blythe Avenue + Christ can be your backup. | Drexel Hill, Pennsylvania 19026
On Thu, 11 Oct 2001, Bruce Momjian wrote: > > I have added documentation for code 209. Looks like there are other > undocumented ones. Should we document them all? If you're asking me, I'm all in favour of documenting them;-) I'm not a fan of "Read the source," though I do it if I'm desperate.