Using mtsmaker without an .mdq File

The following is an example of how to generate a schema script for a query without using a database/query file and specifying an Oracle connect string with the Data Source parameter (-D).

The -D parameter can also be used to specify a data source for ODBC, Sybase SQL Server, or DB2®, as appropriate.


mtsmaker -s "select * from AddressList" -u yourid -p password
   -z oracle -d "oracle connect string" -o addlist.mts 
   -f maillist.mtt -n adddata

As part of the SQL Statement parameter (-s) format, the SELECT statement must be enclosed in a double quotation mark.