If you do not specify the MERGEBLOCKRATIO option when you create a table, Vantage returns the SQL create text for the table as if you had specified the DEFAULT MERGEBLOCKRATIO option.
For example, suppose you create a table named emp_table, but do not specify the MERGEBLOCKRATIO option. Then, you submit a SHOW TABLE request for emp_table.
SHOW TABLE emp_table;
The SHOW TABLE output is as follows.
CREATE SET TABLE emp_table, NO FALLBACK, NO BEFORE JOURNAL, NO AFTER JOURNAL,CHECKSUM = DEFAULT, DEFAULTMERGEBLOCKRATIO, MAP = TD_MAP1 ( emp_no INTEGER ) PRIMARY INDEX ( emp_no );