How do I set READBUFF for a ODBC passthru query?

deleted_user — Sat, 04 Apr 2009 18:30:22 GMT

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

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

sbb — Sat, 04 Apr 2009 21:26:45 GMT

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.

topic Re: How do I set READBUFF for a ODBC passthru query? in SAS Programming

How do I set READBUFF for a ODBC passthru query?

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