ASE version:

Aqua Data Studio 23.0.0
Build #: 59903
Built on: 2023-Jul-11 07:25:18 AM

Error Messages for Procedure Editor does not display line number

To reproduce ( in ADS):

Type in an editor window:

create table c(d int null)
go
create procedure aa
as
begin
    update d set d=1 order by d
end
go
drop table c
go

When executing, error reported is

>[Error] Script lines: 3-8 --------------------------
 Incorrect syntax near the keyword 'order'.

As the code is short, error is obvious (update does not allow order by). But in a big procedure, it is impossible to find where the error is

The same statement executed in Sybase ASE command line utility:

1> create table c(d int null)
2> go
1> create procedure aa
2> as
3> begin
4> update d set d=1 order by d
5> end
6> go
Msg 156, Level 15, State 2:
Server 'SERVOLAB', Procedure 'aa', Line 4:
Incorrect syntax near the keyword 'order'.

Here you can see the line with error clearly signaled (Line 4: update d set d=1 order by d)