Use the AUTOGENERATE clause in an input window to automatically generate values that function as primary keys for input data that does not have a natural primary key.
CREATE SCHEMA TradeSchema ( AutoGenId long, Symbol STRING, Price MONEY (4), Volume INTEGER, TradeTime DATE );
The example then creates an input window named Trades that uses the schema TradeSchema and sets the AutoGenId as the primary key. Finally, the example uses the AUTOGENERATE clause to automatically generate values for the AutoGenId column.
CREATE INPUT WINDOW Trades SCHEMA TradeSchema PRIMARY KEY (AutoGenId) AUTOGENERATE (AutoGenId);
ATTACH INPUT ADAPTER xmlInConn1 TYPE xml_in TO Trades PROPERTIES blockSize=1, dir='../exampledata', file='Trades.xml', filePattern='*.xml', safeOps=false, skipDels=false;