Which buffer?
If youre talking about the result set buffer for an ODBC stage type, the default is a maximum of 400 columns or 8192 bytes, whichever comes first. These can be varied using MAXFETCHCOLS and MAXFETCHBUFF, respectively, in the uvodbc.config file. If its not this buffer, please post a more precise question.
====================
I need to know the max buffer size for DataStage 4.0 and how or if it can be increased.
Thanks
Lisa Hamilton
Buffer Size
Buffer Size
Where do I go to increase the buffer size on the datastage server to correct this error:
SQLSTATE=S1000, DBMS.CODE=930122
[Ardent][SQL Client][UNIVERSE]UniVerse/SQL: Row length exceeds buffer size.
SQLSTATE=S1000, DBMS.CODE=930122
[Ardent][SQL Client][UNIVERSE]UniVerse/SQL: Row length exceeds buffer size.
In uvodbc.config file in the project directory on the server, change MAXFETCHBUFF to a larger value. Its default value is 8192; maybe double it.
-----Original Message-----
From: Roosa, Mike [mailto:Mike.Roosa@getronics.com]
Sent: Sunday, 02 September 2001 14:38
To: datastage-users@oliver.com
Subject: Buffer Size
Where do I go to increase the buffer size on the datastage server to correct this error:
SQLSTATE=S1000, DBMS.CODE=930122
[Ardent][SQL Client][UNIVERSE]UniVerse/SQL: Row length exceeds buffer size.
-----Original Message-----
From: Roosa, Mike [mailto:Mike.Roosa@getronics.com]
Sent: Sunday, 02 September 2001 14:38
To: datastage-users@oliver.com
Subject: Buffer Size
Where do I go to increase the buffer size on the datastage server to correct this error:
SQLSTATE=S1000, DBMS.CODE=930122
[Ardent][SQL Client][UNIVERSE]UniVerse/SQL: Row length exceeds buffer size.