Does MaxDB support "Begin ... End" in SQL statement ?

[Former Member]

In Microsoft SQL Server, we can write :

" Begin

Declare @num integer

.....

Exec (select * from A)

....

End

However, in MaxDB, when I use "Begin,End, IF ...", it always failed with "not Invalid sql statement"...

So I wanna if MaxDB support these in SQL statement ?

(I know, in DBPROC and Function, these key words work)

Thank you very much!

Best Regards,

Bi,Xuan

[alexander_schroeder]

Hello Xuan,

Unfortunately for you, MaxDB does not support TSQL constructs like the one

you have tried. These constructs only work with Microsoft SQL Server.

Regards

Alexander Schröder