Digi TransPort WR11 - Page 497

Configuring Virtual Private Networking (VPN) Configure Internet Protocol security (IPsec)
Digi TransPort® Routers User Guide
497
Connect to the SQL server and database
sql con <host > <user > <pwd> <dat abase>
For example:
sql con 192. 168. 0. 50 sql user sql pass er out e- db
Issue transact SQL statements
sql do <" cmd" >
For example:
sql do " sel ect * f r om si t e wher e subnet =' 10. 110. 100. 0' l i mi t 3"
Limit the sqldo command to only act on specified fields
sql f i el ds “ <f i el d1> <f i el d2> <f i el d3>”
After issuing the sqlfields command, all further sqldo commands will apply to these fields only.
For example:
sql f i el ds “ r emmsk passwor d peer i p”
Close the SQL server connection correctly
sql cl ose
Use the SQL “debug” command
If the database being queried is held locally on the router, you can precede these transact SQL
commands with the SQL debug command to get extra feedback on any commands issued.
n To enable the SQL debug:
sql 0 debug_opt s 3
n To view the debug data via the ASY 0 port:
debug 0
n To view the SQL debug data via Telnet:
debug t
n To disable the SQL debug:
>sql 0 debug_opt s 0
debug of f