Function SCOPE_IDENTITY not found When I call SCOPE_IDENTITY in Sybase, I get 


  [Error] Script lines: 1-6 --------------------------  Function 'SCOPE_IDENTITY' not found. If this is a SQLJ function or SQL
  function, use sp_help to check whether the object exists (sp_help may
  produce a large amount of output).  Msg: 14216, Level: 16, State: 1 
  Server: DGTSYBASEDEV101, Line: 3 


This is my code:

INSERT into IVR_SESSION (PHONE_NUMBER,IVR_TYPE, CALLING_COUNTRY,ADD_DATETIME,UPDATE_DATETIME)
values ("464545454", "asdd", "AUS",getdate(),getdate())
SELECT SCOPE_IDENTITY()
The SCOPE_IDENTITY function is not available in Sybase ASE as it is specific to Microsoft Sql Server. If you want to obtain the last identity value that was generated you can use the @@IDENTITY global variable like so:

insert into sales_daily (syb_identity, stor_id) 
     values (102, "1349")
select @@identity


You can find the documentation for the @@IDENTITY global variable at SyBooks Online.