Problem:

The use of CCSID ASCII appears not to work for databases, tables, views, etc.

When the CCSID option is defined, an error -

X020: Syntax Error. Last symbol read was 'ASCII'

How can ASCII tables be created in XDB..?

Resolution:

To create ASCII tables, databases, etc, firsat the location being used needs to be created as ASCII Sensitive and the SQL to create the location should specify CCSID ASCII.

When creating databases, tables, etc in that location, CCSID does not need to be specified as it is picked up from the location, if not specified in the database / table definition sql.

It is not possible to create EBCDIC and ASCII items in the same location.

The mixture of code pages on a location causes all kinds of problems with comparisons across tables so we have not put in support for mixing EBCDIC and ASCII.  

Any clients who want to use a code page other than EBCDIC needs to use Unicode.