INFOR.DATAOBJECTSEQID
This function shows the data object sequence id, which is the record sequence, or line of the data object for the record. It is associated with the data object Id.
The functions and parameters are case-insensitive. The default result set column name is infor.DataObjectSeqId. You may specify an alias to override the default result set column name.
Syntax
select infor.dataobjectseqid('object') from object
The parameter is the object name. Use single quotes around the object name because it is a literal for the function. Use the object name as a parameter if the query contains joins to select the DataObjectSeqId from a specific object name.
Syntax
select infor.dataobjectseqid() from object
The object name is optional if the query selects data from a single object.
The infor.lastModified, infor.dataObjectId and infor.dataObjectSeqId are associated with each record and are used for traceability back to a specific object stored in the Data Lake. Use the infor.dataObjectId to find a specific data object by using the Data Lake API /dataobject/{id}. Each payload may contain one or more records, or tuples. Therefore, you may have the same infor.dataOb jectId and infor.lastModified associated with multiple records in a result set. The infor.dataObjectSeqId is the record location or line, in the infor.dataObjectId.
For example: A data object ID has 50 records; the infor.dataObjectSeqId is used to find the record, or sequence of the record in the data object ID.