Create and update SQL scripts are text files with a set of DDL and DML commands separated by the "^" character. The "^" character
is used, so that the ";" separator can be applied as part of complex commands; for example, when creating functions or triggers.
The script execution mechanism splits the input file into separate commands using the "^" separator and executes each command
in a separate transaction. This means that, if necessary, it is possible to group several single statements (e.g., insert), separated by semicolons and ensure that they execute in a single transaction.
An example of the update SQL script:
create table LIBRARY_COUNTRY ( ID varchar(36) not null, CREATE_TS time, CREATED_BY varchar(50), -- NAME varchar(100) not null, -- primary key (ID) )^ alter table LIBRARY_TOWN add column COUNTRY_ID varchar(36) ^ alter table LIBRARY_TOWN add constraint FK_LIBRARY_TOWN_COUNTRY_ID foreign key (COUNTRY_ID) references LIBRARY_COUNTRY(ID)^ create index IDX_LIBRARY_TOWN_COUNTRY on LIBRARY_TOWN (COUNTRY_ID)^
