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}]