Create array in DB2 on zOS ends in SQLCODE=-104.

[ArrayinDB2]

I tried to create an array data type in DB2 on z/OS like this:

Code: Select all

  CREATE TYPE user_var as CHAR(255) array[100];

But it ends in SQLCODE=-104

Code: Select all

DSNT408I SQLCODE = -104, ERROR:  ILLEGAL SYMBOL "[". SOME SYMBOLS THAT MIGHT
         BE LEGAL ARE: Ý ??(

DSNT418I SQLSTATE   = 42601 SQLSTATE RETURN CODE

Have some one tried this before? Can anyone please help to resolve this?

[enrico-sorichetti]

You might have a problem with the code pages used
if You are out of luck using a C like character set with [ and ] then use the corresponding trigraph representation
as suggested by the message

SOME SYMBOLS THAT MIGHT BE LEGAL ARE: Ý ??(

where the ??( is the trigraph corresponding to a [

speak to Your support on how to configure Your 3270 session code page

here are the commonly used trigraphs

Code: Select all

| trigraph | replacement 
------------------------ 
| ??-      | ˜            
| ??!      | |           
| ??’      | ˆ           
| ??(      | [           
| ??)      | ]           
| ??/      | \           
| ??<      | {           
| ??=      | #           
| ??>      | }            

[ArrayinDB2]

Thanks it was indeed a code page error. Support is helping on this.

[Anuj Dhawan]

Thanks for the feedback.