Copying an ESQL file

You can copy an ESQL file as a starting point for a new ESQL file that has similar function.

Before you begin

This topic assumes that you have created an ESQL file. For more information, see Creating an ESQL file.

To copy an ESQL file, complete the following steps.

In the Application Development view, right-click the ESQL file that you want to copy, and click Copy.
Alternatively, you can select the ESQL file and click Edit > Copy.
Right-click the integration project into which you want to copy the ESQL file and click Paste.
Alternatively, you can select the integration project and click Edit > Paste.
You can copy the ESQL file to the same broker schema within the same integration project, or to a different broker schema within the same integration project, or to a broker schema in a different integration project.

When you copy an ESQL file, the associated files (message flow, and mapping if present) are not automatically copied to the same target integration project. If you want these files copied as well, you must do so manually.

To use this ESQL file with another message flow, ensure that the modules in the ESQL file match the nodes that you have in the message flow, and that the node properties are set correctly.

You can also copy an ESQL file by using File > Save As; for more information, see Saving an ESQL file.