Section 4.11.1.1. Example: AddSessionQuery

Example: `AddSessionQuery`

In the following example query, bind variables marked with question marks are used with AddSessionQueryParam.

AddSessionQuery INSERT INTO sessions ( \
      imsi, session_id, origin_host, origin_realm, \
      application_id, application_name, \
      service_selection, permanent_user_id, start_time) \
      VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?)
AddSessionQueryParam %0
AddSessionQueryParam %1
AddSessionQueryParam %2
AddSessionQueryParam %3
AddSessionQueryParam %4
AddSessionQueryParam %5
AddSessionQueryParam %6
AddSessionQueryParam %7
AddSessionQueryParam %8

The following example shows how to store additional information required by emergency services and IMSI encryption. It's also possible to enable just emergency services or IMSI encryption. These two features do not depend on each other.

AddSessionQuery INSERT INTO sessions ( \
      imsi, session_id, origin_host, origin_realm, \
      application_id, application_name, \
      service_selection, permanent_user_id, start_time, \
      emergency_services, user_name ) \
      VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
AddSessionQueryParam %0
AddSessionQueryParam %1
AddSessionQueryParam %2
AddSessionQueryParam %3
AddSessionQueryParam %4
AddSessionQueryParam %5
AddSessionQueryParam %6
AddSessionQueryParam %7
AddSessionQueryParam %8
AddSessionQueryParam %9
AddSessionQueryParam %10