I'm trying to migrate my knowledge from Microsoft SQL Server 2000 / 2005 to IBM UDB and currently encountering a lot of problems.

Using Command Editor, how do i Declare a Variable.

DECLARE intVar INTEGER DEFAULT 0;

Tried executing the code above and i get an error, but this Declaration works when inside a Stored Procedure, is there a Difference?

Thanks

Yes, it only works in procedures. Not sure about triggers.

Yes for triggers and also for UDFs.

Andy