2

My question is very simple, I am trying to print a combination of text and numbers, by using the SELECT statement. However, when I try to print text using this method, I get a lot of miscellaneous - chars.

How can I use the select statement without having it print the - chars?

For example:

SELECT "HELLO WORLD"

Would result in:

---------------------
HELLO WORLD
Danny Beckett
  • 18,294
  • 21
  • 100
  • 129
czchlong
  • 2,294
  • 10
  • 45
  • 61
  • `SELECT` does not print things... Are you talking about output in some sort of client program? – mellamokb Mar 04 '13 at 21:16
  • @mellamokbtheWise, No, if I were to just run the stored procedure from a shell script. The `SELECT` statements that I use to print numbers and text will also produce `----------` – czchlong Mar 04 '13 at 21:27
  • I'm assuming you are running *isql* against ASE, but if that's not the case, then let us know what client program you are running, and what Sybase database product/version you are running. – Michael Gardner Mar 04 '13 at 21:44
  • @MichaelGardner, Hi Michael I am mistaken, but now that you have mentioned `isql`, yes I am using `isql`. How can I remove the `-` chars with `isql`? – czchlong Mar 04 '13 at 21:47

1 Answers1

3

When lauching isql use the -b option to suppress header printing.

isql -Uusername -Sservername -b
Michael Gardner
  • 6,406
  • 5
  • 21
  • 33