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 [42601]: [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.
CREATE TABLE
syntax in documentation?