Detailed description of SQL statements
This page provides you detailed information
on the various SQL statements of database user. Please browse through the
screenshots to learn how and when the statements are executed during the SMS
Polling statement will be executed by default in every
"10" seconds. The time of the execution can be set in "Check the ozekimessageout
table every ... sec. for outgoing messages (Figure 1).
Figure 1 - Polling statement
Figure 2 demonstrates that the database has been polled and
there is no outgoing message in the database table.
Figure 2 - No outgoing message
If there are outgoing messages in the database they will
return with the polling statement and the database user updates record to
"Sending" (Figure 3).
Figure 3 - Outgoing message
Sending statement is executed if Polling was
successful and there is an outgoing message in the table (Figure 4).
Figure 4 - Sending statement
Then messages are forwarded to the Service Provider in Ozeki NG
SMS Gateway via outbound route (Figure 5).
Figure 5 - Messages forwarded to the service provider
If the Service Provider of Ozeki NG SMS Gateway forwards the
message to the SMSC (SMS center), the Service provider will return that "Message
delivered to network". In this case the database user will update the record to
"Sent" (Figure 6).
Figure 6 - Message delivered to network
If the message has been sent from the Service provider in
Ozeki NG SMS Gateway Sent statement is executed (Figure 7).
Figure 7 - Sent statement
If the Service provider of Ozeki NG SMS Gateway cannot
forward the message to the SMSC for some reason, the status of the message will
be "Message not sent" in the SMS gateway. The database user then updates the
record to "Not sent" (Figure 8).
Figure 8 - Message cannot be delivered to network
If the message cannot be sent to the service provider in Ozeki
NG SMS Gateway Not sent will be executed (Figure 9).
Figure 9 - Not sent statement
If the SMSC sends a delivery report containing "Message
delivered to handset" the database user will update the record to "Delivered"
Figure 10 - Message is delivered to handset
If the delivery report contains "Message successfully delivered to handset",
Delivered statement will be executed (Figure 11).
Figure 11 - Delivered statement
If the delivery has been failed the database user will update
the record to "Undelivered" (Figure 12).
Figure 12 - Message delivery failed
If the SMSC reports that the message cannot be delivered,
Undelivered statement will be executed (Figure 13).
Figure 13 - Undelivered statement