Section 4.10.5.1. Example: DeleteReauthQuery with <AuthBy SIMSQL> and <AuthBy SIMMAP>

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

This example query shows how DeleteReauthQuery is used with

<AuthBy
                     SIMSQL>

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

DeleteReauthQuery update SIMUSER set  REAUTH_ID=NULL, \
      COUNTER=NULL, NONCE_S=NULL, NEXT_REAUTH_ID=NULL \
      where REAUTH_ID=?
DeleteReauthQueryParam %0

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

DeleteReauthQuery update SIMUSER set REAUTH_ID=NULL, \
      COUNTER=NULL, NONCE_S=NULL, NEXT_REAUTH_ID=NULL \
      where REAUTH_ID=%0