Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Fri, 05 Dec 2003 @ 13:08:32 GMT


     
  <Prev Next>   <<First <Prev Next> Last>>  


Subj:   Re: Response buffer size is insufficent to hold one record >32KB
 
From:   David Wellman

Hi Carmelo,

You're correct, it is a setting on your client. Oe of the parameters in cliv2 determines the maximum size of row that Teradata can send back to the client. In your case it looks like it's not large enough.

If you can change the code, you need to set the Response_Buffer_Length value to a bigger number. Also look at what you've got set for Maximum_Parcel, you probably need a value of 'H'.

If you can't change the code, you need to modify file clispb.dat. This is normally in the directory where you installed the cliv2 software. The parameters that you need to change are: resp_buf_len - give it a bigger value, maximum_parcel = H.


Cheers,

Dave



     
  <Prev Next>   <<First <Prev Next> Last>>  
 
 
 
 
 
 
 
 
  
  Top Home Privacy Feedback  
 
 
Copyright for the TeradataForum (TDATA-L), Manta BlueSky    
Copyright 2016 - All Rights Reserved    
Last Modified: 23 Jun 2019