EXEC ('SELECT * FROM sys.types');

CREATE PROCEDURE CreateFilesForExportData (path varchar(1000))
LANGUAGE SQL
BEGIN ATOMIC
   DECLARE id SMALLINT;
   DECLARE tableName VARCHAR(128);
   DECLARE cur_tableName CURSOR FOR
      SELECT TABLES.TABNAME
      FROM SYSCAT.TABLES AS TABLES
      WHERE TABLES.TABSCHEMA = 'METR' AND TABLES.TYPE = 'T'
      ORDER BY TABLES.TABNAME ASC;
   DECLARE CONTINUE HANDLER FOR NOT FOUND SET id=1;

   SET id = 0;

   OPEN cur_tableName;
   FETCH FROM cur_tableName INTO tableName;
   WHILE id = 0 DO
	  
          --Как в MS SQL Server
          EXEC (N'EXPORT TO "'+@path+'\result.csv" OF DEL MODIFIED BY NOCHARDEL TIMESTAMPFORMAT="YYYY/MM/DD HH:MM:SS" COLDEL| STRIPLZEROS MESSAGES "'+@path+'\FMessage.txt"
                SELECT * FROM METR.'+@tableName+'');<----



	  FETCH FROM cur_tableName INTO tableName;
   END WHILE;
   CLOSE cur_tableName;
END