Skip to content

/AWS1/CL_LKF=>GETTABLEOBJECTS()

About GetTableObjects

Returns the set of Amazon S3 objects that make up the specified governed table. A transaction ID or timestamp can be specified for time-travel queries.

Method Signature

IMPORTING

Required arguments:

IV_DATABASENAME TYPE /AWS1/LKFNAMESTRING /AWS1/LKFNAMESTRING

The database containing the governed table.

IV_TABLENAME TYPE /AWS1/LKFNAMESTRING /AWS1/LKFNAMESTRING

The governed table for which to retrieve objects.

Optional arguments:

IV_CATALOGID TYPE /AWS1/LKFCATALOGIDSTRING /AWS1/LKFCATALOGIDSTRING

The catalog containing the governed table. Defaults to the caller’s account.

IV_TRANSACTIONID TYPE /AWS1/LKFTRANSACTIONIDSTRING /AWS1/LKFTRANSACTIONIDSTRING

The transaction ID at which to read the governed table contents. If this transaction has aborted, an error is returned. If not set, defaults to the most recent committed transaction. Cannot be specified along with QueryAsOfTime.

IV_QUERYASOFTIME TYPE /AWS1/LKFTIMESTAMP /AWS1/LKFTIMESTAMP

The time as of when to read the governed table contents. If not set, the most recent transaction commit time is used. Cannot be specified along with TransactionId.

IV_PARTITIONPREDICATE TYPE /AWS1/LKFPREDICATESTRING /AWS1/LKFPREDICATESTRING

A predicate to filter the objects returned based on the partition keys defined in the governed table.

  • The comparison operators supported are: =, >, <, >=, <=

  • The logical operators supported are: AND

  • The data types supported are integer, long, date(yyyy-MM-dd), timestamp(yyyy-MM-dd HH:mm:ssXXX or yyyy-MM-dd HH:mm:ss"), string and decimal.

IV_MAXRESULTS TYPE /AWS1/LKFPAGESIZE /AWS1/LKFPAGESIZE

Specifies how many values to return in a page.

IV_NEXTTOKEN TYPE /AWS1/LKFTOKENSTRING /AWS1/LKFTOKENSTRING

A continuation token if this is not the first call to retrieve these objects.

RETURNING

OO_OUTPUT TYPE REF TO /AWS1/CL_LKFGETTABLEOBJECTSRSP /AWS1/CL_LKFGETTABLEOBJECTSRSP