--JET
INSERT INTO CubeFunctionDB (FuncId, DbName, Syntax) VALUES ('Sum',   'JET', 'Sum(?)')
INSERT INTO CubeFunctionDB (FuncId, DbName, Syntax) VALUES ('Max',   'JET', 'Max(?)')
INSERT INTO CubeFunctionDB (FuncId, DbName, Syntax) VALUES ('Min',   'JET', 'Min(?)') 
INSERT INTO CubeFunctionDB (FuncId, DbName, Syntax) VALUES ('Avg',   'JET', 'Avg(?)')
INSERT INTO CubeFunctionDB (FuncId, DbName, Syntax) VALUES ('Count', 'JET', 'Count(?)') 
INSERT INTO CubeFunctionDB (FuncId, DbName, Syntax) VALUES ('StDev', 'JET', 'STDEV(?)')
INSERT INTO CubeFunctionDB (FuncId, DbName, Syntax) VALUES ('Var',   'JET', 'VAR(?)')
INSERT INTO CubeFunctionDB (FuncId, DbName, Syntax) VALUES ('StDevP','JET', 'STDEVP(?)')
INSERT INTO CubeFunctionDB (FuncId, DbName, Syntax) VALUES ('VarP',  'JET', 'VARP(?)')
INSERT INTO CubeFunctionDB (FuncId, DbName, Syntax) VALUES ('First', 'JET', 'FIRST(?)')
INSERT INTO CubeFunctionDB (FuncId, DbName, Syntax) VALUES ('Last',  'JET', 'LAST(?)')

INSERT INTO CubeFunctionDB (FuncId, DbName, Syntax) VALUES ('DateUsa', 'JET', 'Format(?,"mm/dd/yy")')
INSERT INTO CubeFunctionDB (FuncId, DbName, Syntax) VALUES ('DateAnsi', 'JET','Format(?,"mm.dd.yy")')
INSERT INTO CubeFunctionDB (FuncId, DbName, Syntax) VALUES ('DateBrit', 'JET','Format(?,"dd/mm/yy")')
INSERT INTO CubeFunctionDB (FuncId, DbName, Syntax) VALUES ('DateGerm', 'JET','Format(?,"dd.mm.yy")')
INSERT INTO CubeFunctionDB (FuncId, DbName, Syntax) VALUES ('DateIta', 'JET', 'Format(?,"dd-mm-yy")')

INSERT INTO CubeFunctionDB (FuncId, DbName, Syntax) VALUES ('Year', 'JET',    'Format(?,"yyyy")')
INSERT INTO CubeFunctionDB (FuncId, DbName, Syntax) VALUES ('Quarter', 'JET', 'Format(?,"q")')
INSERT INTO CubeFunctionDB (FuncId, DbName, Syntax) VALUES ('Month', 'JET',   'Format(?,"mmm")')
INSERT INTO CubeFunctionDB (FuncId, DbName, Syntax) VALUES ('MonthF', 'JET',  'Format(?,"mmmm")')
INSERT INTO CubeFunctionDB (FuncId, DbName, Syntax) VALUES ('Day', 'JET',     'Format(?,"dd")')
INSERT INTO CubeFunctionDB (FuncId, DbName, Syntax) VALUES ('Weekday', 'JET', 'Format(?,"ddd")')
INSERT INTO CubeFunctionDB (FuncId, DbName, Syntax) VALUES ('WeekdayF', 'JET','Format(?,"dddd")')
INSERT INTO CubeFunctionDB (FuncId, DbName, Syntax) VALUES ('Time', 'JET',    'Format(?,"Medium Time")')
INSERT INTO CubeFunctionDB (FuncId, DbName, Syntax) VALUES ('Hour24', 'JET',  'Format(?,"h")')
INSERT INTO CubeFunctionDB (FuncId, DbName, Syntax) VALUES ('Minute', 'JET',  'Format(?,"n")')
INSERT INTO CubeFunctionDB (FuncId, DbName, Syntax) VALUES ('Second', 'JET',  'Format(?,"s")')

--SQL2005
INSERT INTO CubeFunctionDB (FuncId, DbName, Syntax) VALUES ('Sum', 'SQL2005', 'Sum(?)')
INSERT INTO CubeFunctionDB (FuncId, DbName, Syntax) VALUES ('Max', 'SQL2005',  'Max(?)')
INSERT INTO CubeFunctionDB (FuncId, DbName, Syntax) VALUES ('Min', 'SQL2005',  'Min(?)') 
INSERT INTO CubeFunctionDB (FuncId, DbName, Syntax) VALUES ('Avg', 'SQL2005',  'Avg(?)')
INSERT INTO CubeFunctionDB (FuncId, DbName, Syntax) VALUES ('Count', 'SQL2005', 'Count(?)') 
INSERT INTO CubeFunctionDB (FuncId, DbName, Syntax) VALUES ('CountD', 'SQL2005', 'Count(DISTINCT ?)') 
INSERT INTO CubeFunctionDB (FuncId, DbName, Syntax) VALUES ('CountB', 'SQL2005',  'COUNT_BIG(?)')
INSERT INTO CubeFunctionDB (FuncId, DbName, Syntax) VALUES ('CountDB', 'SQL2005', 'COUNT_BIG(DISTINCT ?)')
INSERT INTO CubeFunctionDB (FuncId, DbName, Syntax) VALUES ('StDev', 'SQL2005',  'STDEV(?)')
INSERT INTO CubeFunctionDB (FuncId, DbName, Syntax) VALUES ('StDevP', 'SQL2005', 'STDEVP(?)')
INSERT INTO CubeFunctionDB (FuncId, DbName, Syntax) VALUES ('Var', 'SQL2005',   'VAR(?)')
INSERT INTO CubeFunctionDB (FuncId, DbName, Syntax) VALUES ('VarP', 'SQL2005',  'VARP(?)')
INSERT INTO CubeFunctionDB (FuncId, DbName, Syntax) VALUES ('First', 'SQL2005', 'FIRST(?)')
INSERT INTO CubeFunctionDB (FuncId, DbName, Syntax) VALUES ('Last', 'SQL2005',  'LAST(?)')

INSERT INTO CubeFunctionDB (FuncId, DbName, Syntax) VALUES ('DateUsa',  'SQL2005', 'CONVERT(varchar,?,101)')
INSERT INTO CubeFunctionDB (FuncId, DbName, Syntax) VALUES ('DateAnsi', 'SQL2005', 'CONVERT(varchar,?,102)')
INSERT INTO CubeFunctionDB (FuncId, DbName, Syntax) VALUES ('DateBrit', 'SQL2005', 'CONVERT(varchar,?,103)')
INSERT INTO CubeFunctionDB (FuncId, DbName, Syntax) VALUES ('DateGerm', 'SQL2005', 'CONVERT(varchar,?,104)')
INSERT INTO CubeFunctionDB (FuncId, DbName, Syntax) VALUES ('DateIta',  'SQL2005', 'CONVERT(varchar,?,105)')

INSERT INTO CubeFunctionDB (FuncId, DbName, Syntax) VALUES ('Year', 'SQL2005',     'DATENAME (year, ?)')
INSERT INTO CubeFunctionDB (FuncId, DbName, Syntax) VALUES ('Quarter', 'SQL2005',  'DATENAME (quarter, ?)')
INSERT INTO CubeFunctionDB (FuncId, DbName, Syntax) VALUES ('Month', 'SQL2005',    'DATENAME (month, ?)')
INSERT INTO CubeFunctionDB (FuncId, DbName, Syntax) VALUES ('DayOfYear', 'SQL2005','DATENAME (dayofyear, ?)')
INSERT INTO CubeFunctionDB (FuncId, DbName, Syntax) VALUES ('Day', 'SQL2005',      'DATENAME (day, ?)')
INSERT INTO CubeFunctionDB (FuncId, DbName, Syntax) VALUES ('Week', 'SQL2005',     'DATENAME (week, ?)')
INSERT INTO CubeFunctionDB (FuncId, DbName, Syntax) VALUES ('Weekday', 'SQL2005', 'DATENAME (weekday, ?)')
INSERT INTO CubeFunctionDB (FuncId, DbName, Syntax) VALUES ('Hour24', 'SQL2005', 'DATENAME (hour, ?)')
INSERT INTO CubeFunctionDB (FuncId, DbName, Syntax) VALUES ('Minute', 'SQL2005', 'DATENAME (minute, ?)')
INSERT INTO CubeFunctionDB (FuncId, DbName, Syntax) VALUES ('Second', 'SQL2005', 'DATENAME (second, ?)')
INSERT INTO CubeFunctionDB (FuncId, DbName, Syntax) VALUES ('Time', 'SQL2005', 'CONVERT(varchar,?,108)')

--SQL2000
INSERT INTO CubeFunctionDB (FuncId, DbName, Syntax) VALUES ('Sum', 'SQL2000', 'Sum(?)')
INSERT INTO CubeFunctionDB (FuncId, DbName, Syntax) VALUES ('Max', 'SQL2000',  'Max(?)')
INSERT INTO CubeFunctionDB (FuncId, DbName, Syntax) VALUES ('Min', 'SQL2000',  'Min(?)') 
INSERT INTO CubeFunctionDB (FuncId, DbName, Syntax) VALUES ('Avg', 'SQL2000',  'Avg(?)')
INSERT INTO CubeFunctionDB (FuncId, DbName, Syntax) VALUES ('Count', 'SQL2000', 'Count(?)') 
INSERT INTO CubeFunctionDB (FuncId, DbName, Syntax) VALUES ('CountD', 'SQL2000', 'Count(DISTINCT ?)') 
INSERT INTO CubeFunctionDB (FuncId, DbName, Syntax) VALUES ('CountB', 'SQL2000',  'COUNT_BIG(?)')
INSERT INTO CubeFunctionDB (FuncId, DbName, Syntax) VALUES ('CountDB', 'SQL2000', 'COUNT_BIG(DISTINCT ?)')
INSERT INTO CubeFunctionDB (FuncId, DbName, Syntax) VALUES ('StDev', 'SQL2000',  'STDEV(?)')
INSERT INTO CubeFunctionDB (FuncId, DbName, Syntax) VALUES ('StDevP', 'SQL2000', 'STDEVP(?)')
INSERT INTO CubeFunctionDB (FuncId, DbName, Syntax) VALUES ('Var', 'SQL2000',   'VAR(?)')
INSERT INTO CubeFunctionDB (FuncId, DbName, Syntax) VALUES ('VarP', 'SQL2000',  'VARP(?)')

INSERT INTO CubeFunctionDB (FuncId, DbName, Syntax) VALUES ('DateUsa',  'SQL2000', 'CONVERT(varchar,?,101)')
INSERT INTO CubeFunctionDB (FuncId, DbName, Syntax) VALUES ('DateAnsi', 'SQL2000', 'CONVERT(varchar,?,102)')
INSERT INTO CubeFunctionDB (FuncId, DbName, Syntax) VALUES ('DateBrit', 'SQL2000', 'CONVERT(varchar,?,103)')
INSERT INTO CubeFunctionDB (FuncId, DbName, Syntax) VALUES ('DateGerm', 'SQL2000', 'CONVERT(varchar,?,104)')
INSERT INTO CubeFunctionDB (FuncId, DbName, Syntax) VALUES ('DateIta',  'SQL2000', 'CONVERT(varchar,?,105)')

INSERT INTO CubeFunctionDB (FuncId, DbName, Syntax) VALUES ('Year', 'SQL2000',     'DATENAME (year, ?)')
INSERT INTO CubeFunctionDB (FuncId, DbName, Syntax) VALUES ('Quarter', 'SQL2000',  'DATENAME (quarter, ?)')
INSERT INTO CubeFunctionDB (FuncId, DbName, Syntax) VALUES ('Month', 'SQL2000',    'DATENAME (month, ?)')
INSERT INTO CubeFunctionDB (FuncId, DbName, Syntax) VALUES ('DayOfYear', 'SQL2000','DATENAME (dayofyear, ?)')
INSERT INTO CubeFunctionDB (FuncId, DbName, Syntax) VALUES ('Day', 'SQL2000',      'DATENAME (day, ?)')
INSERT INTO CubeFunctionDB (FuncId, DbName, Syntax) VALUES ('Week', 'SQL2000',     'DATENAME (week, ?)')
INSERT INTO CubeFunctionDB (FuncId, DbName, Syntax) VALUES ('Weekday', 'SQL2000', 'DATENAME (weekday, ?)')
INSERT INTO CubeFunctionDB (FuncId, DbName, Syntax) VALUES ('Hour24', 'SQL2000', 'DATENAME (hour, ?)')
INSERT INTO CubeFunctionDB (FuncId, DbName, Syntax) VALUES ('Minute', 'SQL2000', 'DATENAME (minute, ?)')
INSERT INTO CubeFunctionDB (FuncId, DbName, Syntax) VALUES ('Second', 'SQL2000', 'DATENAME (second, ?)')
INSERT INTO CubeFunctionDB (FuncId, DbName, Syntax) VALUES ('Time', 'SQL2000', 'CONVERT(varchar,?,108)')


--ORA
INSERT INTO CubeFunctionDB (FuncId, DbName, Syntax) VALUES ('Sum', 'ORA', 'Sum(?)')
INSERT INTO CubeFunctionDB (FuncId, DbName, Syntax) VALUES ('Max', 'ORA', 'Max(?)')
INSERT INTO CubeFunctionDB (FuncId, DbName, Syntax) VALUES ('Min', 'ORA', 'Min(?)') 
INSERT INTO CubeFunctionDB (FuncId, DbName, Syntax) VALUES ('Avg', 'ORA', 'Avg(?)')
INSERT INTO CubeFunctionDB (FuncId, DbName, Syntax) VALUES ('Count', 'ORA', 'Count(?)') 
INSERT INTO CubeFunctionDB (FuncId, DbName, Syntax) VALUES ('CountD', 'ORA', 'Count(DISTINCT ?)') 
INSERT INTO CubeFunctionDB (FuncId, DbName, Syntax) VALUES ('StDev', 'ORA',  'Stddev(?)')
INSERT INTO CubeFunctionDB (FuncId, DbName, Syntax) VALUES ('Var', 'ORA',  'Variance(?)')
INSERT INTO CubeFunctionDB (FuncId, DbName, Syntax) VALUES ('Median', 'ORA', 'MEDIAN(?)')
INSERT INTO CubeFunctionDB (FuncId, DbName, Syntax) VALUES ('StDevP', 'ORA', 'stddev_pop(?)')
INSERT INTO CubeFunctionDB (FuncId, DbName, Syntax) VALUES ('VarP', 'ORA',  'var_pop(?)')

INSERT INTO CubeFunctionDB (FuncId, DbName, Syntax) VALUES ('DateUsa', 'ORA',   'TO_CHAR(?,''mm/dd/yy'')')
INSERT INTO CubeFunctionDB (FuncId, DbName, Syntax) VALUES ('DateAnsi', 'ORA',  'TO_CHAR(?,''mm/dd/yy'')')
INSERT INTO CubeFunctionDB (FuncId, DbName, Syntax) VALUES ('DateBrit', 'ORA',   'TO_CHAR(?,''dd/mm/yy'')')
INSERT INTO CubeFunctionDB (FuncId, DbName, Syntax) VALUES ('DateGerm', 'ORA',   'TO_CHAR(?,''dd.mm.yy'')')
INSERT INTO CubeFunctionDB (FuncId, DbName, Syntax) VALUES ('DateIta', 'ORA',   'TO_CHAR(?,''dd-mm-yy'')')

INSERT INTO CubeFunctionDB (FuncId, DbName, Syntax) VALUES ('Year', 'ORA',   'TO_NUMBER(TO_CHAR(?,''YYYY''))')
INSERT INTO CubeFunctionDB (FuncId, DbName, Syntax) VALUES ('Month', 'ORA',  'TO_CHAR(?,''MON'')')
INSERT INTO CubeFunctionDB (FuncId, DbName, Syntax) VALUES ('MonthF', 'ORA', 'TO_CHAR(?,''MONTH'')')
INSERT INTO CubeFunctionDB (FuncId, DbName, Syntax) VALUES ('Day', 'ORA',    'TO_NUMBER(TO_CHAR(?,''DD''))')
INSERT INTO CubeFunctionDB (FuncId, DbName, Syntax) VALUES ('Weekday', 'ORA', 'TO_CHAR(?,''DY'')')
INSERT INTO CubeFunctionDB (FuncId, DbName, Syntax) VALUES ('Time', 'ORA',    'TO_CHAR(?,''HH:MI AM'')')
INSERT INTO CubeFunctionDB (FuncId, DbName, Syntax) VALUES ('Hour12', 'ORA',  'TO_NUMBER(TO_CHAR(?,''HH''))')
INSERT INTO CubeFunctionDB (FuncId, DbName, Syntax) VALUES ('Hour24', 'ORA',  'TO_NUMBER(TO_CHAR(?,''HH24''))')
INSERT INTO CubeFunctionDB (FuncId, DbName, Syntax) VALUES ('Minute', 'ORA',  'TO_NUMBER(TO_CHAR(?,''MI''))')
INSERT INTO CubeFunctionDB (FuncId, DbName, Syntax) VALUES ('Second', 'ORA',  'TO_NUMBER(TO_CHAR(?,''SS''))')

--MySql
INSERT INTO CubeFunctionDB (FuncId, DbName, Syntax) VALUES ('Sum', 'MySql', 'Sum(?)')
INSERT INTO CubeFunctionDB (FuncId, DbName, Syntax) VALUES ('Max', 'MySql', 'Max(?)')
INSERT INTO CubeFunctionDB (FuncId, DbName, Syntax) VALUES ('Min', 'MySql', 'Min(?)') 
INSERT INTO CubeFunctionDB (FuncId, DbName, Syntax) VALUES ('Avg', 'MySql', 'Avg(?)')
INSERT INTO CubeFunctionDB (FuncId, DbName, Syntax) VALUES ('Count', 'MySql', 'Count(?)') 
INSERT INTO CubeFunctionDB (FuncId, DbName, Syntax) VALUES ('CountD', 'MySql', 'Count(DISTINCT ?)') 
INSERT INTO CubeFunctionDB (FuncId, DbName, Syntax) VALUES ('StDev', 'MySql',  'STDDEV(?)')
INSERT INTO CubeFunctionDB (FuncId, DbName, Syntax) VALUES ('StDevP', 'MySql', 'STDDEV_POP(?)')
INSERT INTO CubeFunctionDB (FuncId, DbName, Syntax) VALUES ('Var', 'MySql',    'VARIANCE(?)')
INSERT INTO CubeFunctionDB (FuncId, DbName, Syntax) VALUES ('VarP', 'MySql',   'VAR_POP(?)')

INSERT INTO CubeFunctionDB (FuncId, DbName, Syntax) VALUES ('DateUsa', 'MySql',   'DATE_FORMAT(?,''%m/%d/%Y'')')
INSERT INTO CubeFunctionDB (FuncId, DbName, Syntax) VALUES ('DateAnsi', 'MySql',  'DATE_FORMAT(?,''%Y.%m.%d'')')
INSERT INTO CubeFunctionDB (FuncId, DbName, Syntax) VALUES ('DateBrit', 'MySql',   'DATE_FORMAT(?,''%d/%m/%Y'')')
INSERT INTO CubeFunctionDB (FuncId, DbName, Syntax) VALUES ('DateGerm', 'MySql',   'DATE_FORMAT(?,''%d.%m.%Y'')')
INSERT INTO CubeFunctionDB (FuncId, DbName, Syntax) VALUES ('DateIta', 'MySql',   'DATE_FORMAT(?,''%d-%m-%Y'')')

INSERT INTO CubeFunctionDB (FuncId, DbName, Syntax) VALUES ('Year', 'MySql',      'DATE_FORMAT(?,''%Y'')')
INSERT INTO CubeFunctionDB (FuncId, DbName, Syntax) VALUES ('Month', 'MySql',     'DATE_FORMAT(?,''%M'')')
INSERT INTO CubeFunctionDB (FuncId, DbName, Syntax) VALUES ('DayOfYear', 'MySql', 'DATE_FORMAT(?,''%j'')')
INSERT INTO CubeFunctionDB (FuncId, DbName, Syntax) VALUES ('Day', 'MySql',       'DATE_FORMAT(?,''%d'')')
INSERT INTO CubeFunctionDB (FuncId, DbName, Syntax) VALUES ('Week', 'MySql',      'DATE_FORMAT(?,''%U'')')
INSERT INTO CubeFunctionDB (FuncId, DbName, Syntax) VALUES ('Weekday', 'MySql',   'DATE_FORMAT(?,''%W'')')
INSERT INTO CubeFunctionDB (FuncId, DbName, Syntax) VALUES ('Hour24', 'MySql',    'DATE_FORMAT(?,''%k'')')
INSERT INTO CubeFunctionDB (FuncId, DbName, Syntax) VALUES ('Minute', 'MySql',    'DATE_FORMAT(?,''%i'')')
INSERT INTO CubeFunctionDB (FuncId, DbName, Syntax) VALUES ('Second', 'MySql',    'DATE_FORMAT(?,''%s'')')

--DB2
INSERT INTO CubeFunctionDB (FuncId, DbName, Syntax) VALUES ('Sum', 'DB2', 'Sum(?)')
INSERT INTO CubeFunctionDB (FuncId, DbName, Syntax) VALUES ('Max', 'DB2', 'Max(?)')
INSERT INTO CubeFunctionDB (FuncId, DbName, Syntax) VALUES ('Min', 'DB2', 'Min(?)') 
INSERT INTO CubeFunctionDB (FuncId, DbName, Syntax) VALUES ('Avg', 'DB2', 'Avg(?)')
INSERT INTO CubeFunctionDB (FuncId, DbName, Syntax) VALUES ('Count', 'DB2', 'Count(?)') 
INSERT INTO CubeFunctionDB (FuncId, DbName, Syntax) VALUES ('CountD', 'DB2','Count(DISTINCT ?)') 
INSERT INTO CubeFunctionDB (FuncId, DbName, Syntax) VALUES ('CountB', 'DB2', 'COUNT_BIG(?)')
INSERT INTO CubeFunctionDB (FuncId, DbName, Syntax) VALUES ('CountDB', 'DB2','COUNT_BIG(DISTINCT ?)')
INSERT INTO CubeFunctionDB (FuncId, DbName, Syntax) VALUES ('StDev', 'DB2',  'STDDEV(?)')
INSERT INTO CubeFunctionDB (FuncId, DbName, Syntax) VALUES ('Var', 'DB2',  'VARIANCE(?)')

INSERT INTO CubeFunctionDB (FuncId, DbName, Syntax) VALUES ('DateUsa', 'DB2',  'CHAR(?,USA)')
INSERT INTO CubeFunctionDB (FuncId, DbName, Syntax) VALUES ('DateAnsi', 'DB2', 'CHAR(?,ISO)')
INSERT INTO CubeFunctionDB (FuncId, DbName, Syntax) VALUES ('DateGerm', 'DB2', 'CHAR(?,EUR)')
INSERT INTO CubeFunctionDB (FuncId, DbName, Syntax) VALUES ('DateJis', 'DB2',  'CHAR(?,JIS)')

INSERT INTO CubeFunctionDB (FuncId, DbName, Syntax) VALUES ('Year', 'DB2', 'YEAR(?)')
INSERT INTO CubeFunctionDB (FuncId, DbName, Syntax) VALUES ('Month', 'DB2',  'MONTHNAME(?)')
INSERT INTO CubeFunctionDB (FuncId, DbName, Syntax) VALUES ('Day', 'DB2',  'DAY(?)')
INSERT INTO CubeFunctionDB (FuncId, DbName, Syntax) VALUES ('Weekday', 'DB2',  'DAYNAME(?)')
INSERT INTO CubeFunctionDB (FuncId, DbName, Syntax) VALUES ('Week', 'DB2',  'WEEK(?)')
INSERT INTO CubeFunctionDB (FuncId, DbName, Syntax) VALUES ('DayOfYear', 'DB2',  'DAYOFYEAR(?)')
INSERT INTO CubeFunctionDB (FuncId, DbName, Syntax) VALUES ('Hour24', 'DB2',  'Hour(?)')
INSERT INTO CubeFunctionDB (FuncId, DbName, Syntax) VALUES ('Minute', 'DB2',  'Minute(?)')
INSERT INTO CubeFunctionDB (FuncId, DbName, Syntax) VALUES ('Second', 'DB2',  'Second(?)')