Hi, this is the part of the log when run from Base SAS. 579 580 /* Local Passthrough query via ODBC to Database */ 581 proc sql; 582 connect to ODBC(dsn="PRPDX" uid = USERID password = XXXXXXXXXX ); 584 create table getPFX(compress = yes) as 585 select * from connection to ODBC(&SQL1); NOTE: Compressing data set WORK.GETPFX decreased size by 76.21 percent. Compressed is 29848 pages; un-compressed would require 125466 pages. NOTE: Table WORK.GETPFX created, with 2634768 rows and 20 columns. 586 disconnect from ODBC; 587 quit; NOTE: PROCEDURE SQL used (Total process time): real time 2:24.17 cpu time 31.83 seconds   And this is the log when run from a DOS batch files. 285        /* Local Passthrough query via ODBC to Performix Database         */ 286        proc sql; 287        connect to ODBC(dsn="PRPDX" uid = USERID password = XXXXXXXXXX ); 289        create table getPFX(compress = yes) as 290        select * from connection to ODBC(&SQL1); NOTE: Table WORK.GETPFX created, with 0 rows and 20 columns. 291        disconnect from ODBC; 292        quit; NOTE: SAS set option OBS=0 and will continue to check statements.       This might cause NOTE: No observations in data set. NOTE: PROCEDURE SQL used (Total process time):       real time           0.39 seconds       cpu time            0.12 seconds   No rows pulled and no errors. ... View more