Adding Parameters to out
This portion of the tutorial demonstrates two different ways to add and edit parameters.
To add the necessary parameters to out
1. Open your transform.
2. Click to select out.
3. Right-click and select Add Parameter.
4. Select Complex > CURSOR.
5. In the operation handle to the left of CURSORParam, right-click and select Add Parameter.
6. Select Integer > INTEGER.
7. Repeat until you have 3 cursor parameters with integer subparameters.
8. Save your transform.
9. Select the CURSORParam row.
10. Right-click and select Rename.
11. Type customer.
12. Select the CURSORParam2 row.
13. Right-click and select Rename.
14. Type order.
15. Select the CURSORParam3 row.
16. Right-click and select Rename.
17. Type orderitem.
18. Add and rename subparameters until your have parameters with the following structure:
Parent Parameter | subparameter | Data Type |
customer | | CURSOR |
customerid | INTEGER |
customername | VARCHAR |
order | | CURSOR |
orderid | INTEGER |
customerid | INTEGER |
ordersubtotal | FLOAT |
orderitem | | CURSOR |
orderitemid | INTEGER |
orderid | INTEGER |
orderitemname | VARCHAR |
orderitemdescription | VARCHAR |
19. Save your transform.