Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

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

Status
Not open for further replies.

bobk5444

Programmer
Joined
Jan 28, 2005
Messages
17
Location
US
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
 
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.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top