how to export file to unix

Database
Fan

how to export file to unix

hi,

I am trying to run the queries from a file and capture the result in an another file.
the queries are typically show view or show table sort of queries.

The result file however has DDL's cut in the middle of words, could someone tell me how to avoid this? i am working on sun Solaris unix.

or a better approach to get DDL's of all table or views in a database.

this is the code snippet i am using.

bteq <<!
.LOGON $username,$password
.EXPORT REPORT FILE=sample.txt
.RUN FILE=queries.txt
.LOGOFF
.QUIT
!

Thanks
2 REPLIES
Enthusiast

Re: how to export file to unix

Hi,
You can use below to set the width so the text will not be cut in middle of word

.SET WIDTH 3000 ;
.SET TITLEDASHES OFF;

hope this will work.
Fan

Re: how to export file to unix

Thanks rupesh, it works.