Using mtsmaker with a database/query file

About this task

You can use a database/query file (.mdq) that was created using the Database Interface Designer and transfer it, in binary mode, to the system hosting your database. The .mdq file is then used as a source of information about a particular query, database, or stored procedure.

To generate a tree script file (.mts) for a database query, specify the following mtsmaker parameters. For specific information about each mtsmaker parameter, refer to the List of Parameters .

mtsmaker   -M mdq_file 
   -Q query_name [-B database_name]
   -F mtt_file_name
   -O mts_file_name
   [-X {F|O|T|FOT}]

To generate a tree script file (.mts) for a table, view, or stored procedure, specify the following mtsmaker parameters:

mtsmaker   -M mdq_file 
   -B database_name
   -T table_name|-G stored_procedure_name
   -F mtt_file_name 
   -O mts_file_name
   [-X {F|O|T|FOT}]