Define SQL queries

All configurations in Alfabet requiring a query definition can be defined in native SQL. In some cases Alfabet query language cannot be used and queries have to be defined in native SQL because the required definition is outside of the scope of the simplified Alfabet query language.

This documentation does not teach you native SQL. You should be familiar with the native SQL query language. The following description is limited to information about the specific use of native SQL in Alfabet configurations.

For each configuration in Alfabet based on a query you can define a native SQL query instead of an Alfabet query in the respective text editor or input field. All queries starting with ALFABET_QUERY_500 are processed as Alfabet query, all other queries are processed as native SQL queries. There is no header definition required for native SQL.

If native SQL queries are defined in the attribute section of configuration objects, the definition can be provided in a simple text editor or an editor specific to native SQL. The native SQL editor includes functionality to ease definition of Alfabet specific instructions and parameters.