Connecting a Stream to a Derived Window Using nextval()

Use the nextval() function to set a primary key for a derived window connected to a stream.

1. Open a new or existing ESP project in Studio.
2. Connect a stream to a derived window.
3. In the derived window under column expressions, right-click the wildcard and select Delete Element.
4. Select Copy Columns from Input to add the column expressions from the input window.
5. Click the drop down menu for the derived window; select Modify and then Edit Primary Keys.
6. In the dialog box, add a column as the primary key. Click OK.
7. Right-click the expression value for the primary key column and select Edit Expression Value.
8. Delete the expression value and replace it with nextval(). Click OK.