To execute an XTM and save output as an SQL script:

  1. Click Operations > Run. The Execute XTM window will appear.

  2. Click Save as SQL Script.

  3. In the Save as SQL Script box, enter the full path and file name for the XSL file, or select a file and path by clicking the browse button.

  4. In the Source XML box, enter a full path and file name for the XML file to import data from, or select a file and path by clicking the browse button.

  5. Click OK. The XTM Tool will create an SQL script. You can run the SQL script from the dmSQL prompt or using the JDBA tool to enter data into the database.

 

Example:

SQL script output:

INSERT INTO DELPHI.CHINESE (ID,TEXT) VALUES (?,?);

1,'lobdir1\clobfile0.txt';

2,'lobdir1\clobfile1.txt';

3,'lobdir1\clobfile2.txt';

4,'lobdir1\clobfile3.txt';

5,'lobdir1\clobfile4.txt';

…