CODEWITHSUNDEEP
sqlprintingconsolesybaseoutput
Gaurav
Gaurav

Reputation: 1650

Sybase - Setting console output on for printing log statements

Does somebody know how to turn the console output on in Sybase. The usual statement like print 'Hello', is not working for me, it just says command executed successfully without printing the log statement.

Upvotes: 7

Views: 18113

Answers (3)

Bruno V
Bruno V

Reputation: 1731

It depends on your setup. If you are using SQL Anywhere, PRINT 'Hello' will not be written to the client window if you are connected from an embedded SQL or ODBC application. The printed message will however be visible in the Server Messages in Sybase Central.

In your case, you'll probably need MESSAGE 'Hello' type status to client as @toniedzwiedz mentioned.

Upvotes: 2

Wesam Abdallah
Wesam Abdallah

Reputation: 1180

DECLARE @var1 INT, @var2 INT
SELECT @var1 = 3, @var2 = 5
PRINT 'Variable 1 = %1!, Variable 2 = %2!', @var1, @var2

Upvotes: 0

Will Charlton
Will Charlton

Reputation: 922

Are you using Interactive SQL in sybase? Or are you invoking dbisqlc with -nogui option and passing it an SQL file for it to run?

The 'message' method is only for interactive mode.

I'm trying to figure this out as well, but as far as I can tell the console output doesn't seem to work. I tried using 'select' statement such as:

SELECT "This is my message";

And it seems to work, but is a little too hacky for my tastes.

Please let me know if this works/you figured something better out :)

~Will

Upvotes: 3

Related Questions