Analyzer records all the steps you take to create a table, including all commands and can use this information to create a procedure. Creating a procedure from the table history reproduces the steps required to produce a table, saving you the time and trouble of recreating it manually.
Note: The Create Procedure from History menu option only includes refreshable Import commands in the procedure.
The procedure performs the processing necessary to re-produce a table and, where relevant, a particular View.
To create a procedure from the table history, do the following:
1. | Create a new table using Analyzer commands from the menu or command line. |
2. | With the new table open, select Tools from the menu and choose Create Procedure from History. |
3. | Analyzer prompts you that a new procedure item named “New_Procedure” was created. Click [OK]. |
4. | Right-click the new procedure, select “Rename”, enter a meaningful name and click [Enter]. |
The procedure is created. You can run it at any time to re-produce the same table. Since the commands are stored in the procedure, you can edit the procedure itself if you want to make any processing changes.