Re: Dynamic Queries

Hi, you can use a Python or R UDF with loopback queries to achieve this. Hannes

On 15 Jun 2016, at 00:00, Ariel Abadi wrote:

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 _______________________________________________ users-list mailing list users-list@monetdb.org https://www.monetdb.org/mailman/listinfo/users-list