A small script to allow functions that are defined for an on-disk database to be cloned into the in-memory one. To restrict it to certain functions only specify a list in the form 'f1','f2' etc as Only

SCRIPT (IN SrcDB VARCHAR, IN Only VARCHAR)
BEGIN

DECLARE Source CURSOR FOR Selector;
DECLARE Creator VARCHAR;  
DECLARE SelSQL VARCHAR;

SET SelSQL = 'SELECT Definition FROM '
            + SrcDB
            + '.Information.Functions WHERE NAME NOT IN (SELECT Name FROM Information.Functions)';
IF (Only IS NOT NULL) AND (Only <> '') THEN
SET SelSQL = SelSQL + ' AND Name IN (' + Only + ')';
END IF;

PREPARE Selector FROM SelSQL;

OPEN Source;

FETCH FIRST FROM Source(Definition) INTO Creator;

WHILE NOT EOF(Source) DO
IF (Creator IS NOT NULL) AND (Creator <> '') THEN
 EXECUTE IMMEDIATE 'CREATE '+ Creator;
END IF;
FETCH NEXT FROM Source(Definition) INTO Creator;
END WHILE;

END


Roy Lambert

Roy,

MM A small script to allow functions that are defined for an on-disk
database to be cloned into the in-memory one. To restrict it to certain
functions only specify a list in the form 'f1','f2' etc as Only >>

Nice.

--
Tim Young
Elevate Software
www.elevatesoft.com

Tim


I only write these things because I'm lazy.

Roy Lambert

Roy,

<< I only write these things because I'm lazy. >>

That's why I automate everything short of answering emails here.

--
Tim Young
Elevate Software
www.elevatesoft.com