Can't view all the columns for a query result in BTEQ

Tools
IYA
Enthusiast

Can't view all the columns for a query result in BTEQ

Hi seniors,

I have one problem after I query the system view accesslog. But I can only see 7 colunms instead of 17 colunms in BTEQ. Please advice how can I adjust it?

Thank you in advanced!
3 REPLIES
Enthusiast

Re: Can't view all the columns for a query result in BTEQ


Did you check the .set width ? (do a .show controls in bteq to see all settings) it might be getting truncated to the right ....

.set width ;
Enthusiast

Re: Can't view all the columns for a query result in BTEQ

oops I meant to say type

.set width 300;

(or some larger number)
IYA
Enthusiast

Re: Can't view all the columns for a query result in BTEQ

Thank you very much:)