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