Morning Hugo, On 15/11/12 23:02, hugo.larson wrote: > Is there any way to execute with isql query and send result to a file without > any headers whatsoever? > Im using FB 1.5.3
I'm not sure about 1.5 but this works on 2.5 with the employee database: SQL> -- Turn headings off. SQL> set heading; SQL> -- Direct output to a file. SQL> output myfile.txt; SQL> -- Run query. SQL> select * from department; SQL> commit; SQL> -- Redirect all further output to the screen. SQL> output; SQL> -- Put headings back on again. SQL> set heading; Watch out though, if the output file exists, it will be appended to, not overwritten. HTH Cheers, Norm. -- Norman Dunbar Dunbar IT Consultants Ltd Registered address: Thorpe House 61 Richardshaw Lane Pudsey West Yorkshire United Kingdom LS28 7EL Company Number: 05132767
