Unanswered: How can i convert "Raise error " from sybase to UDB
Here is the issue on RAISE ERROR
In SYBASE We have the stored proc similar to the following.
create proc RaiseErrTest ()
insert into schema.tbl1 select col1,col2 from schema.tbl2 where col1 = 100
if @@error != 0
raiserror 99999 " Insert table failed!"
For the above sql how can i write in UDB.
I tried many ways but not able to achieve it...
If some body helps me that will be great.
Sr.DBA in SYBASE