| Auszug |
|---|
|
Nuclos SQL configurations: nuclet import, run SQL automatically, checksum, nuclet version, tags, SQL_CONFIG_FILTER, 4.2024.31. |
Language: Deutsch · English
SQL configurations
Run SQL automatically on nuclet import – versioned, checksum- and tag-controlled.
| Status |
|---|
| colour | Blue |
|---|
| title | Application developer |
|---|
|
| Status |
|---|
| colour | Green |
|---|
| title | Updated: Jul 2026 |
|---|
|
| Status |
|---|
| colour | Grey |
|---|
| title | applies to Nuclos 4.2026.x |
|---|
|
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.
Settings
| 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. |
Related pages
Database objects
Views & functions.
Open →
