Run Database Script (DbScript)

Description:
DbScript allows you to run a set of DbTkXml commands .

If you specify an input script file DbScript will run in batch mode silently,
writing diagnostics to a log file "logs/yyyymmdd/DbScript.log"

If you don't specify an input script file or '-' DbScript will run
interactively from the command line prompting you for the next command.

Note that In demo mode up to 100 records can be exported, 500 imported..

Syntax:
usage: DbScript [-i{in}]
-i = INPUT : Specify Script Input (- or no input for interactive prompt)

Example1 (Interactive mode):
DbScript
DbTkXml> opendb sample.mdb
opendb sample.mdb
1: Categories
2: Customers
3: Employees
4: Order Details
5: Orders
6: Products
7: Shippers
8: Suppliers
DbTkXml> table shippers
table shippers
1: ShipperID|INTLONG|
2: CompanyName|TEXT|
3: Phone|TEXT|
DbTkXml> list data
list data
1: 1|Speedy Express|(503) 555-9831|
2: 2|United Package|(503) 555-3199|
3: 3|Federal Shipping|(503) 555-9931|
DbTkXml> xmlexport
xmlexport
1: 3 'shippers' Record(s) written to 'shippers.xml'
2: shippers.xml
3: shippers.dtd
DbTkXml> exit

Example2 (Batch mode):
DbScript -i script.txt
DbScript will execute the commands in the script.txt script file.

Script.txt could contain for example the commands from Example1 above:
opendb sample.mdb
table shippers
list data
xmlexport
exit

Example3 (Verbose Batch mode):
DbScript < script.txt

DbScript will execute the commands in the script.txt script file
but display the diagnostics for each command:
DbTkXml> 
opendb sample.mdb
1: Categories
2: Customers
3: Employees
4: Order Details
5: Orders
6: Products
7: Shippers
8: Suppliers
DbTkXml> 
table shippers
1: ShipperID|INTLONG|
2: CompanyName|TEXT|
3: Phone|TEXT|
DbTkXml> 
list data
1: 1|Speedy Express|(503) 555-9831|
2: 2|United Package|(503) 555-3199|
3: 3|Federal Shipping|(503) 555-9931|
DbTkXml> 
xmlexport
1: 3 'shippers' Record(s) written to 'shippers.xml'
2: shippers.xml
3: shippers.dtd
DbTkXml> 
exit

Logfile:
If you run this command on Feb 18th, 2001 the logfile would be created in:
logs/20010218/dbscript.log
INIT    |14:29:19.222 |====== Opening C:/DbTkXml/logs/20020309/dbscript.log ======
DbTkXml |14:29:19.352 |ExecCmd: opendb sample.mdb
DbTkXml |14:29:19.422 |ExecCmd: table shippers
DbTkXml |14:29:19.462 |ExecCmd: list data
DbTkXml |14:29:19.492 |ExecCmd: xmlexport
DbTkXml |14:29:19.542 |3 'shippers' Record(s) written to 'shippers.xml'