(2005) Supported Dynamic Lookups

Owned by SNP
May 04, 2020
2 min read

Content

Supported Dynamic Lookups

Example of a supported SELECT statement

SELECT */list_of_fields  (aggregation_functions-SUM, MIN, MAX, COUNT) (AS)

  INTO (CORRESPONDING  FIELDS OF) TABLE result_table

  FROM  ( Dynamic_table )

  (FOR ALL ENTRIES  IN fae_table)

  WHERE  (fae_table_cond AND  ) where_cond-BETWEEN,OR,IN,().

Example of a supported WHERE condition

manager  = fae_table-manager  AND  (city = ‘FRANKFURT’  OR city = ‘BERLIN’)

Example of a not supported WHERE condition 

manager  = fae_table-manager  OR manager  = ‘PETER’ AND  (city = ‘FRANKFURT’  OR  (country = ‘SVK’  AND  date = ‘01012014’)  )

Not supported dynamic lookups

Not supported dynamic lookups are the same as in (2005) Supported Standard Lookups as well as the below mentioned types:

1. SELECT with dynamic FIELDS

  • Fields are used to select only defined fields
  • This select is not supported by Lookup API and DataTiering
Recommended solution
  1. To achieve a code that can be adjusted, replace dynamic fields variable from SELECT with a star
  2. After the previous step you may adjust the SELECT statement in DataTiering
  3. You may return the SELECT statement to its original version
  4. Add to the generated code the red marked part.

Example before 

Example after 


2. SELECT with dynamic WHERE condition

Not supported SELECT with dynamic WHERE condition is the same as in (2005) Supported Standard Lookups, however in this case the complete dynamic where condition is a variable:

Recommended solution
  1. To achieve a code that can be adjusted, comment the condition
  2. Adjust the SELECT statement with DataTiering
  3. Return the SELECT statement to its original version
  4. Add WHERE condition to Lookup API (red marked)

Example before 

Example after