Re: SQL CREATE TABLE with CCSID gets SQL0189

[Peter Dow <maillist@xxxxxxxxxxxxxxx>]

Thanks Chuck and Rob -- obviously I'm skimming too much in my reading!

CRPence wrote:
>    "Both 819 and 1252 are listed", but neither is listed with an X 
> [supported tagging plus conversion tables; i.e. "implies that this 
> CCSID can be used to tag local data"] in the table describing its 
> level of support.  Both of those ASCII CCSIDs 819 & 1252 are listed 
> with a C [Conversion tables only; i.e. no tagging support; e.g. "a 
> PC-Data CCSID such as 850 cannot be used to tag local data in DB2 
> for i5/OS"].  Use either the [VAR]GRAPHIC data type for UCS2 [13488] 
> or a UTF character CCSID [1208, 1200].
>
> Regards, Chuck
>
> Peter Dow wrote:
>   
> > Yes, I saw that.  Both 819 and 1252 are listed.  So why am I
> > getting SQL0189?
> >
> > CRPence wrote:
> >     
> http://publib.boulder.ibm.com/infocenter/iseries/v5r4/topic/db2/rbafzmstsidvals.htm 
>
>