An Idea Exchange for SAS software and services

Comments
by Super User
on ‎03-16-2017 08:24 PM

Does using either the DBMAX_TEXT or DBSASTYPE settings help?

by PROC Star
on ‎03-16-2017 10:06 PM

Sadly no.

I am not using a library, so can't use DBMAX_TEXT.

I am not reading a table, so can't use BMAX_TEXT or DBSASTYPE.

Also, since there is no table, extended table attributes (SASFMT) are out as well.

by PROC Star
on ‎03-16-2017 10:15 PM

Mmm I tried another syntax and it works .. sort of.

libname HAD001 hadoop &hadoop_connection. DBMAX_TEXT=1024;

proc sql;
  connect using HAD001;
  select * from connection to HAD001 ( describe extended TABLE);   

Does not create a message.

by PROC Star
‎03-16-2017 10:18 PM - edited ‎03-16-2017 10:19 PM

I suppose a workaround is

1- Use the "connect using" syntax instead of the "connect to" syntax.

2- Set DB-MAX_TEXT=32766 to fool the warning generator.

libname HAD001 hadoop &hadoop_connection. DBMAX_TEXT=32766;

proc sql;
  connect using HAD001;
  select * from connection to HAD001 ( describe extended TABLE );   

But really, a better way would be desirable.

Thanks a lot @Tom for getting me out of the rut!

 

Idea Statuses
Top Liked Authors