getrowid()

Returns the sequence number, or ROWID, of a given row in the window or stream as a 64-bit integer.

Syntax

getrowid ( row )

Parameters

row

A record from a window, stream, or delta stream, which is identified by the window or stream's name.

Usage

Each incoming row of data is assigned a unique sequence number or ROWID. The getrowid function takes a window or stream's identifier as its argument, and returns the ROWID of the row in the window or stream. It can be used with a stream, delta stream, or window. For more information about ROWID, see the Programmers Guide.

Example

CREATE INPUT STREAM MarketIn 
     SCHEMA ( Symbol STRING, Price MONEY(4), Volume INTEGER ); 

CREATE  OUTPUT STREAM MarketOut  
     SCHEMA ( RowId LONG, Symbol STRING, Price MONEY(4), Volume INTEGER, TradeValue MONEY(4)) 
AS
     SELECT  
         getrowid ( MarketIn ) RowId, 
         MarketIn.Symbol, 
         MarketIn.Price,  
         MarketIn.Volume, 
         MarketIn.Price * MarketIn.Volume as TradeValue 
     FROM MarketIn;