Section 4.4.5.1. Example: DeleteReauthQuery with <AuthBy AKASQL>

Example: `DeleteReauthQuery` with `<AuthBy AKASQL>`

This example query shows how DeleteReauthQuery is used with

<AuthBy
                     AKASQL>

. The bind variables marked with question marks are used with DeleteReauthQueryParam listed below the query.

DeleteReauthQuery update SIMUSER set  REAUTH_ID=NULL, \
      COUNTER=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, NEXT_REAUTH_ID=NULL where REAUTH_ID=%0