Sybase "set optoins" how to turn off header and count info 1

[bobk5444]

Does anyone know how to turn off all of the header and carriage return outputs using a set option and allow for only the actual source to be printed?

Thanks very much
BobK
---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------

CREATE VIEW vw_amt
AS SELECT instmt_id, submitting_entity_id, convert(varchar(8),rpt_dte,112) "r
pt_dte", book_value_amt, face_value_amt, rem_term_qty,
int_rate_amt, counterparty_rating, idx_cde, margin_amt, fas_115_class, ofheo_ledger_cde, comment
s
FROM amt





(2 rows affected)
(return status = 0)
1> exec sp_helptext vw_arm_cmt_data_elements
# Lines of Text
---------------
2

 

[iziki]

Hi Bobk,
I suggest you try using the isql -b switch for removing the headers and the set nocount on command for removing the display of number of rows affected.

hope that helps

iziki.