DATA Step, Macro, Functions and more

How do I set READBUFF for a ODBC passthru query?

Reply
N/A
Posts: 0

How do I set READBUFF for a ODBC passthru query?

Hello. I have an ODBC passthru query to my DB2 database. How do I set the readbuff on the connection? In either case my trace shows:
ODBC: Fetch time in seconds for 1 row is 0.000045 which looks like only 1 row is fetched

IS it:
proc sql;
CONNECT TO ODBC AS DB2MCMN (NOPROMPT="DSN=&MCV_postdsn; UID=&MCV_postuid; PWD=&MCV_postpwd; DATABASE=&MCV_postdb; READBUFF=500" );

create table work.Detaillevel_report_daily as
select * from connection to DB2MCMN
(Select * from sometable);

OR IS IT
proc sql;
CONNECT TO ODBC AS DB2MCMN (NOPROMPT="DSN=&MCV_postdsn; UID=&MCV_postuid; PWD=&MCV_postpwd; DATABASE=&MCV_postdb; " READBUFF=500 );
/* readbuff is outside string */

create table work.Detaillevel_report_daily as
select * from connection to DB2MCMN
(Select * from sometable);

Thank you
Super Contributor
Super Contributor
Posts: 3,174

Re: How do I set READBUFF for a ODBC passthru query?

Posted in reply to deleted_user
Suggest you visit the SAS support http://support.sas.com/ website (and its SEARCH facility) for SAS-hosted documentation, supplemental technical papers from conferences, and also tech notes that may pertain to your subject.

Scott Barry
SBBWorks, Inc.
Ask a Question
Discussion stats
  • 1 reply
  • 172 views
  • 0 likes
  • 2 in conversation