To export a single SQL statement to a file, follow these steps:

1.Open the SAM that includes this statement, as described in Opening an Existing SAM.

2.Open the SQL statement, as described in Opening an Existing SQL Statement.
The syntax of the SQL statement appears in the SQL Editor window.

3.Select SQL Statement Ø Export Ø File.
The Export SQL Statement to File dialog box appears, as shown below.

Export SQL Statement to File Dialog Box

4.Navigate to the directory to which you want to export the SQL statement.
The names of the files in that directory appear in the File list box

1.Type the name of the file to which you want to export the statement in the Save as filename entry field.

2.Select the OK push button.
The Export SQL Statement to File dialog box closes. DB/Assist exports the text of the statement in the SQL Editor window to the selected file.