Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss

Sybase error 156

1,083 views
Skip to first unread message

Jim Metcalfe

unread,
Aug 17, 1995, 3:00:00 AM8/17/95
to
Does anyone know what Sybase error 156 is? I cannot find it in any
of the troubleshooting guides that I have. Any help would be
appreciated.

Thanks,
Jim

Simon Walker

unread,
Aug 21, 1995, 3:00:00 AM8/21/95
to

select * from master..sysmessages where error = 156

error severity dlevel description
----------- -------- ------ --------------------------------------------
156 15 2 Incorrect syntax near the keyword '%.*s'.

You need a better message handler ;)

simon walker
The SQL Workshop
Milton Keynes, UK

Jim Metcalfe

unread,
Aug 23, 1995, 3:00:00 AM8/23/95
to
Wayne,

Wayne Westlake (wa...@sybase.co.za) wrote:

: Where did the error occur? In the errorlog or was it returned to the
: client? Please provide more information including the exact error
: message and what conditions caused it.

Only the error number was returned to the client with no error message.

: I found a references to Msg 156 in the AnswerBase and it pertains to a

: SQL query:

: Msg 156, Level 15, State x
: Incorrect syntax near the keyword 'distinct'.

: This is the result if the Distinct keyword appears more than once in
: the <query specification> outside of any <set function specification>.

I was told by another poster to do a query of sysmessages to obtain
the error text which turned out to be the incorrect syntax you found in
AnswerBase. I am suprised this error number is not documented
in a manual (at least not in the core set of manuals I received with
the product) since I would expect syntax errors to be common, especially
in applications where the user enters raw queries.

Thanks for your help.

Jim


Wayne Westlake

unread,
Aug 24, 1995, 3:00:00 AM8/24/95
to
metc...@fc.hp.com (Jim Metcalfe) wrote:

>Does anyone know what Sybase error 156 is? I cannot find it in any
>of the troubleshooting guides that I have. Any help would be
>appreciated.

>Thanks,
>Jim


Jim,

Where did the error occur? In the errorlog or was it returned to the
client? Please provide more information including the exact error
message and what conditions caused it.

I found a references to Msg 156 in the AnswerBase and it pertains to a
SQL query:

Msg 156, Level 15, State x
Incorrect syntax near the keyword 'distinct'.

This is the result if the Distinct keyword appears more than once in
the <query specification> outside of any <set function specification>.


Wayne Westlake
Sybase South Africa


0 new messages