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!

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

Search results for query: *

  1. tbrock03

    isql output file - Getting rid of (return status = 0)

    Thank you!!!! It works-
  2. tbrock03

    isql output file - Getting rid of (return status = 0)

    I am running on Sybase, but through a Smartstream job. My command line is as follows: isql -U (user) -P (password) -i xxx/sqlfile -o xxx/outputfile.txt -w 2000 Does grep -v 'return status =' get rid of the line?
  3. tbrock03

    isql output file - Getting rid of (return status = 0)

    Does anyone know how to get rid of the (return status = 0) on the bottom of my output text file when running my sql job? I have tried to 'set nocount on' but it doesnt seem to work.
  4. tbrock03

    iSQL output file - getting rid of [end of job] comment

    Maybe I am adding the set nocount on line in the wrong place. Do i add it to my sql script or on the isql command line? My sql is>> declare cursor a_csr for Select .... go
  5. tbrock03

    iSQL output file - getting rid of [end of job] comment

    I've tried adding this line Set nocount on to my sql but I still receive (Return Status = 0) at the bottom of my output file.
  6. tbrock03

    iSQL output file - getting rid of [end of job] comment

    When I run this SQL to a text file, it prints out fine, but contains a End of Job Successful [or something similar] at the bottom of my text file. Is there any way to get rid of this? I am using Sybase.

Part and Inventory Search

Back
Top