Alter a transpose function

In this topic you will use the Alter Transpose Function option to alter a function by, for example, selecting a different element or event frame template, or renaming the function.

Note: PI OLEDB Enterprise does not support Alter statements which is why PI SQL Commander Lite simulates the altering process by dropping the function and recreating it with modifications.

1. Right-click a function with invalid attributes and click Fix.

   The invalid attributes get removed automatically and the function is made valid again.

2. To alter a transpose function right-click a function in a database and click Alter Transpose Function.

   

   The Transpose Function Wizard is displayed.

3. In the Transpose Function window click Next.

   Note: The transpose function type cannot be altered. If you want to change the function type, you need to drop the function and create a new one.

   The Template window is displayed.

4. Choose the appropriate method depending on your selection:

   • If you selected a transpose function for assets, select an element template in the Element Template window and click Next.

   • If you selected a transpose function for event frames, select an event frame template in the Event Frame Template window and click Next.

     Note: If you change a function template, the transpose function name does not automatically change. You need to adjust the name in the next step.

   From here you can always click Back to modify your previous action.

   The Definition window is displayed.

5. Optional: If you want to change the transpose function name, type the new name in the Transpose function name field.

6. In the Definition window, choose the appropriate method depending on your selection of function type:

   • If you selected the dynamic transpose function, click Next.

   • If you selected the custom transpose function, select the template attributes you want to use by dragging each element and dropping it into the right-hand box. You can also double-click the element to add it. Click Next when finished.

   The Options window is displayed.

7. Optional: In the Options window, select or clear Values as VARIANT and click Next.

   Note: The Create function table option cannot be altered. This means that if you previously selected the option, you cannot clear it, and if you did not select it, you cannot select it during the altering process.

   The Summary window is displayed.

8. Click Next.

   The function name and the selected element template or event frame template are displayed in the next window.

9. Click Execute to execute the function.

   The DML (data manipulation language) drops the initial function and creates a new function and function table.