RE: ODBC buffer size.... ???

Hi Norma. Probably an ODBC fetch buffer size same as FET_BUF_SIZE environment variable. See refer to Informix Client SDK manual. Regards. -- Tsutomu Ogiwara from Tokyo Japan. ICQ#:168106592 >From: "NormaJean" <normajean.sebastian@tellabs.com> >Reply-To: "NormaJean" <normajean.sebastian@tellabs.com> >To: informix-list@iiug.org >Subject: ODBC buffer size.... ??? >Date: Wed, 1 Jun 2005 18:24:14 -0500 > >update..... > >what does an ODBC fetch buffer size of 32,767 mean? > >does that mean MSAccess will bring back 32,767 characters in one select and >that's it? >for example, if i use dbaccess to dump a list of owner.table names from the >IDS7 engine below, and do a character count on the file, it is very large, >... surpasses 32,767 characters. >but the IDS9 engine below ... while it has 20,000+ tables, the owner.table >names are smaller in size, potentially fitting in the 32,767 fetch buffer >size...... > >i don't know enough about this ODBC stuff. I know i can not increase the >fetch buffer size in the ODBC setup, but it appears that the MSAccess >session can't bring back the entire table list because the select output is >larger than 32,767 characters? > >help? >thanks, >NJ > > > sending to informix-list