IDENTITY_VAL_LOCAL

Returns the most recently assigned value for an identity column. The result is a decimal.

   SELECT IDENTITY_VAL_LOCAL(EMP_NO)
         FROM CORPDATA.EMPLOYEE