This hint adds additional properties to the results of a SELECT * query. The hint may include one or more parameters: S for synthetic properties, G for generated properties, P for the data storage partition and L for localized string values.

For details of the properties, see Query functions for Data Lake and Compass properties.

Synthetic, generated, and partition properties are Infor properties. They are included with each record to associate the record with Data Lake data or Compass data storage. Synthetic properties are attributes associated with the Data Lake payload. Generated and partition properties are attributes associated with Compass storage.