Section 4.10.7.1. Example: GetReauthQuery with <AuthBy SIMSQL> and <AuthBy SIMMAP>

Example: `GetReauthQuery` with `<AuthBy SIMSQL>` and `<AuthBy SIMMAP>`

This example query shows how GetReauthQuery is used with

<AuthBy
                     SIMSQL>

and <AuthBy SIMMAP>. In this example, bind variables marked with question marks are used with GetReauthQueryParam listed below the query.

GetReauthQuery select IMSI, REAUTH_ID, NONCE_S, COUNTER, \
      MK, K_AUT, K_ENCR, NEXT_REAUTH_ID, VERSION from \
      SIMUSER where REAUTH_ID = ?
GetReauthQueryParam %0

Instead of the previous example, you can also use the following query without the GetReauthQueryParam. In this case, SQL quoted value is used to create the SQL query.

GetReauthQuery select IMSI, REAUTH_ID, NONCE_S, COUNTER, \
      MK, K_AUT, K_ENCR, NEXT_REAUTH_ID, VERSION from \
      SIMUSER where REAUTH_ID = %0