dbTalk Databases Forums  

Question: What is wrong with this statement

sybase.public.sqlanywhere.general sybase.public.sqlanywhere.general


Discuss Question: What is wrong with this statement in the sybase.public.sqlanywhere.general forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
David
 
Posts: n/a

Default Question: What is wrong with this statement - 12-01-2009 , 08:50 AM






Given this

MESSAGE statement
Use this statement to display a message.

Syntax
MESSAGE expression, ...
[ TYPE { INFO | ACTION | WARNING | STATUS } ]
[ TO { CONSOLE
Quote:
CLIENT [ FOR { CONNECTION conn-id [ IMMEDIATE ] | ALL } ]
[ EVENT | SYSTEM ] LOG }
[ DEBUG ONLY ] ]



What is wrong with this?


MESSAGE '{string}'
TYPE INFO TO EVENT LOG DEBUG ONLY;


The error message from ISQL that displays is as follows
This statement is inside a CREATE PROCEDURE STATEMENT
It works when TO EVENT LOG is changed to TO CONSOLE
or TO CLIENT however the messages viewable are limited
in volume by both the CONSOLE the ISQL results window.

ERROR MESSAGE

Could not execute statement
Syntax error near 'DEBUG" on line 21
SQLCODE=131, ODBC 3 State="42000"
file "{file name}.sql' on line 6, column 1
you can continue executing or stop.


One additional thing -- The registry entries still
correspond to the default settings referenced under
this item in the SQL Anywhere help file

event log, registry entry

Reply With Quote
  #2  
Old   
David
 
Posts: n/a

Default Re: Question: What is wrong with this statement - 12-01-2009 , 08:53 AM






My current SQL Anywhere version is 11.0.1.2331 -- this according to the
documentation a new SQL Anywhere 11 feature.

Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.