- proc sql noprint;
- create table b as select distinct * from dictionary.columns where libname='HNLM';
- quit;
- proc sql noprint;
- select distinct memname,count(distinct memname) into :var separated by ',',:num from b;
- quit;
- %put &var.;
- %put &num.;
NOTE: Due to the PRESERVE_TAB_NAMES=NO libname option setting, 1 table(s) have not been displayed/returned.
ERROR: Utility file open failed.
我查了下PRESERVE_TAB_NAMES是用来转换数据库模式大写的,这个设置对于ORACLE与DB2会有很大影响吗?如何解决这个问题?希望高手给予指点。谢谢~~~