I am working with AS400 system. I need to create tables with different encoding for validation task. I tested with
CREATE TABLE TESTSCH.EBCDIC_TBL ( COLUMN1 VARCHAR(100), COLUMN2 INTEGER ) CCSID ebcdic;
However this is not working and throwing below error.
QL Error : [SQL0199] Keyword CCSID not expected
How to create a table with different encoding EBCDIC/ Unicode ASCII etc.
I am using Dbeaver to connect to AS400 system.