OZEKI NG SMS Gateway
"The World's most reliable SMS gateway software!"

RECOMMENDED FOR YOU:

SMS Gateway software
Ozeki brings you outstanding
SMS Gateway technology. Use our SMS Server products on Windows,Linux, or Android

C# SMS API
Developers can use our C# SMS API to send SMS from C#.Net. The C# SMS API comes with full source code

PHP SMS API
The ozeki PHP SMS gateway software can be used to send SMS from PHP and to receive SMS usig PHP on your website

SMPP SMS Gateway
SMS service providers use our SMPP gateway solution, that offers a high performance SMPP server and SMPP client gateway with amazing routing capabilities

Ozeki NG SMS Gateway

Connection string builder | MS SQL high speed

Keywords in the SQL templates

Keyword	Value	Incoming (insert)	Outgoing polling (select)	Outgoing sending (update)	Outgoing sent (update)	Outgoing not sent (update)	Outgoing delivered (update)	Outgoing undelivered (update)
$id	Message ID	+	+	+	+	+	+	+
$senttime	Sent time in the format specified on the confguration form	+			+	+
$receivedtime	Received time in the format specified on the confguration form	+				+
$messagedata	Message text	+	+	+	+	+	+	+
$decodedmessagedata	The decoded text for text messages and a hex string for binary messages. This is different then $messagedata since the $messagedata field will try to decode all data as text.	+		+	+	+	+	+
$sender	Sender address	+	+	+	+	+	+	+
$originator	Same as $sender	+	+	+	+	+	+	+
$receiver	Recipient address	+	+	+	+	+	+	+
$recipient	Same as $receiver	+	+	+	+	+	+	+
$messagetype	Ozeki message type	+	+	+	+	+	+	+
$operatornames	The names of the service provider connections, that can be used to send this message. The names can be separated by a semicolon or a colon.		+
$operator	The name of the service provider connection to use	+	+		+
$subject	The message subject (for SMS messages, the first 1024 characters of the message text)	+
$callbackid	The message submission reference number				+
$cost	The cost of a message (the number of PDUs used to submit it)				+
$reason	The error reason					+		+
$errormessage	The error message					+		+
$currentdatetime	Current date and time in the format specified on the confguration form	+		+	+	+	+	+
$currentdate	Current date in the format yyyy-MM-dd	+		+	+	+	+	+
$currenttime	Current time in the format HH:mm:ss	+		+	+	+	+	+
$1	The first word in the message. You can use $2 to refer to the second word, $3 to refer to the third word, etc...	+
$U1	The first word in the message in upper case format. You can use $U2 to refer to the second word in upper case format, etc...	+
SMS message related fields
$dcshex	The data coding scheme (DCS) byte of the PDU in hexadecimal format	+			+
$dcs	The data coding scheme (DCS) byte of the PDU in decimal format	+			+
$pidhex	The protocol identifier (PID) byte of the PDU in hexadecimal format	+			+
$pid	The protocol identifier (PID) byte of the PDU in decimal format	+			+
$udhplusud	The user data header and the user data in hexadecimal string format of the first pdu	+			+
$udh	The user data header in hexadecimal string format of the first pdu	+			+
$ud	The user data in hexadecimal string format of the first pdu	+			+
$sca	Service center address	+			+
$tp_mms	The TP_MMS flag of the first byte of the PDU. (true or false)	+			+
$tp_mt	The TP_MT flag of the first byte of the PDU. (true or false)	+			+
$tp_rp	The TP_RP flag of the first byte of the PDU. (true or false)	+			+
$tp_srr	The TP_SRR flag of the first byte of the PDU. (true or false)	+			+
$tp_udhi	The TP_UDHI (User data header inidication) flag of the first byte of the PDU. (true or false)	+			+
$messageclass	The message class value is a decimal number	+			+
Multipart SMS messages
$pducount	The number of PDUs in the message	+			+
$pdu1_udhud	The user data header and the user data in hexadecimal string format of the first pdu. For the second pdu this would be $pdu2_udhud, etc...	+			+
$pdu1_udh	The user data header in hexadecimal string format of the first pdu. For the second pdu this would be $pdu2_udh, etc...	+			+
$pdu1_ud	The user data in hexadecimal string format of the first pdu. For the second pdu this would be $pdu2_ud, etc...	+			+
$pdu1_rawheader	The pdu header in hexadecimal string format of the first pdu. For the second pdu this would be $pdu2_rawheader, etc...	+			+
$pdu1_rawbody	The same as $pdu1_udhud. For the second pdu this would be $pdu2_rawpdu, etc...	+			+
$pdu1_rawpdu	The first pdu in hexadecimal format. For the second pdu this would be $pdu2_rawpdu, etc...	+			+
$rawpdus	Contains all pdus separated by a semi colon;	+			+
Optional fields
$fieldname	Field name is the name of a database column that was included in the select statement used to originally pick up the message. This keyword will hold the value of this column in all subsequent updates.		+	+	+	+	+	+

More information

Connection string builder | MS SQL high speed