[karthi_syb]

Will sybase12.0 support SET command ? Becuae i got the below error message.


Server Message: Number 102, Severity 15
Server 'DEV', Line 2:
Incorrect syntax near '@sql'.

[mike_bike_kite]

The set command certainly works in version 12.5 but I don't have an earlier version to try it on. Is it in your manual? Could you supply the code that creates the error rather than just word?

If it helps here's a working example:

declare @sql varchar(80)
set @sql = "Works in version " + @@version
select @sql

Works in version Adaptive Server Enterprise/12.5.3/EBF 12331 ESD#1/P/Sun_svr4/OS

[karthi_syb]

Hi Mike,

Thanks for your reply.

I have executed your sample query, again i got the same error message.

declare @sql varchar(80)
set @sql = "Works in version " + @@version
select @sql

Server Message: Number 102, Severity 15
Server 'DEV', Line 2:
Incorrect syntax near '@sql'.

[mike_bike_kite]

My guess then is that it doesn't work on version 12

Just change the set to a select and it should work fine.

Mike

[karthi_syb]

As you said, If i changed it to Select, it works fine.