SCRIPT
BEGIN
   
   /************************************************************
   * Tables
   ************************************************************/
   
   EXECUTE IMMEDIATE 'CREATE TABLE "MyTable"
(
"Column1" INTEGER
)
VERSION 1
UNENCRYPTED
INDEX PAGE SIZE 4096
BLOB BLOCK SIZE 512
MAX ROW BUFFER SIZE 32768
MAX INDEX BUFFER SIZE 65536
MAX BLOB BUFFER SIZE 32768';
   
   
   /************************************************************
   * Views
   ************************************************************/
   
   
   /************************************************************
   * Functions
   ************************************************************/
   
   EXECUTE IMMEDIATE 'CREATE FUNCTION "MainFunction" (IN "aNumber" INTEGER)
RETURNS INTEGER
BEGIN  

  DECLARE retindex INT DEFAULT 0; 

  set retindex = CallAnotherFunction(12345);
   
  return retindex;

END
';
   
   EXECUTE IMMEDIATE 'CREATE FUNCTION "CallAnotherFunction" (IN "aNumber" INTEGER)
RETURNS INTEGER
BEGIN 
RETURN 54321;
END
';
   
   
   /************************************************************
   * Procedures
   ************************************************************/
   
END