Hi
Im trying to create a Procedure to create (or not) tables dynamically. Does Monet can do something like the following??
CREATE PROCEDURE(pdate date, tname varchar(10))
BEGIN
SET TABLENAME = CONCAT(tname, '_', YEAR(pdate)*100+MONTH(pdate));
CREATE TABLE IF NOT EXIST TABLENAME;
END
Thanks in advance!
Rgds