CREATE MULTISET TABLE dwhsup.TEST_SQL_2 ,FALLBACK ,
NO BEFORE JOURNAL,
NO AFTER JOURNAL,
CHECKSUM = DEFAULT,
DEFAULT MERGEBLOCKRATIO,
MAP = TD_MAP1
(
COD_AER CHAR(3) CHARACTER SET LATIN NOT CASESPECIFIC TITLE 'Code aéroport' NOT NULL,
LIB_AER VARCHAR(50) CHARACTER SET LATIN NOT CASESPECIFIC TITLE 'Libellé aéroport')
PRIMARY INDEX ( COD_AER );
 
insert into dwhsup.TEST_SQL_2 values (null, 'New York -J.F Kennedy');
 
select * from dwhsup.TEST_SQL_2;

Q1JFQVRFIE1VTFRJU0VUIFRBQkxFIGR3aHN1cC5URVNUX1NRTF8yICxGQUxMQkFDSyAsCk5PIEJFRk9SRSBKT1VSTkFMLApOTyBBRlRFUiBKT1VSTkFMLApDSEVDS1NVTSA9IERFRkFVTFQsCkRFRkFVTFQgTUVSR0VCTE9DS1JBVElPLApNQVAgPSBURF9NQVAxCigKQ09EX0FFUiBDSEFSKDMpIENIQVJBQ1RFUiBTRVQgTEFUSU4gTk9UIENBU0VTUEVDSUZJQyBUSVRMRSAnQ29kZSBhw6lyb3BvcnQnIE5PVCBOVUxMLApMSUJfQUVSIFZBUkNIQVIoNTApIENIQVJBQ1RFUiBTRVQgTEFUSU4gTk9UIENBU0VTUEVDSUZJQyBUSVRMRSAnTGliZWxsw6kgYcOpcm9wb3J0JykKUFJJTUFSWSBJTkRFWCAoIENPRF9BRVIgKTsKCmluc2VydCBpbnRvIGR3aHN1cC5URVNUX1NRTF8yIHZhbHVlcyAobnVsbCwgJ05ldyBZb3JrIC1KLkYgS2VubmVkeScpOwoKc2VsZWN0ICogZnJvbSBkd2hzdXAuVEVTVF9TUUxfMjs=