Create table with EBCDIC encoding in db2 i series

0 votes

1 answer

924 views

                          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.

Asked by Anand (3 rep)

Oct 20, 2022, 06:18 AM
Last activity: Oct 20, 2022, 01:33 PM

Create table with EBCDIC encoding in db2 i series

Related Questions