Hai Friends,
Can u Pls tell me how to Set a Transaction Name in IB and
COMMIT the Transaction using Store Procedure.I would give U an
example.

Set TErm !! ;
Create Procedure Sp_TestTransaction
(EmpNo integer)
Returns
(RetVal Integer)
As
Begin
RetVal = 0;
Set Transaction Tr1;
Update Employee set EmpName='Suresh' where EmpID=:EmpNo;
RetVal = 1;
COMMIT Tr1;
Suspend;
End !!
Set Term ; !!