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