Language: Deutsch · English

SQL configurations

Run SQL automatically on nuclet import – versioned, checksum- and tag-controlled.

REFERENZ APPLICATION DEVELOPER UPDATED: JUL 2026 APPLIES TO NUCLOS 4.2026.X

On this page

What are SQL configurations?

Menu: Configuration → Nuclet → SQL configurations tab (from Nuclos 4.2024.31).

Nuclos can execute SQL automatically when a nuclet is imported. The statements are stored directly in the nuclet and travel with the transfer.

SQL configurations in the nuclet.

Parameter	Values	Exported	Meaning
Order	Integer (default 1)	Yes	Determines the execution order of the scripts.
Name	Text (e.g. MyScript)	Yes	Short label for the script.
Description	Text (optional)	Yes	More detailed description of what the script does.
SQL	CLOB / text	Yes	The raw SQL; separate multiple statements with a semicolon: `UPDATE …;INSERT …;`
After schema update	Boolean	Yes	Run before or after the schema update (creation of new BOs).
Checksum	Text (readonly)	Yes	Calculated automatically from the SQL; identical scripts already run are not repeated.
Nuclet version	Integer	Yes	From which nuclet version the script runs (with „irreversible“ the required version before import).
Irreversible change	Boolean	Yes	Enforces a minimum nuclet version for subsequent scripts.
Tags	Text (space-separated)	Yes	Binds scripts to tags (server parameter `SQL_CONFIG_FILTER`). The database type (POSTGRESQL/H2/ORACLE) is always a tag.
Date of last execution	Date (readonly)	No	Set when the script has been executed.
Execution checksum	Text (readonly)	No	Checksum at execution time; if the SQL checksum changes, the script runs again.
Error	Boolean	No	Set if a statement contained an error.
Output	Text	No	Error message of the SQL execution when „error“ is set.