Mainframe, MVS and zOS Discussion

Thanks for the feedback. :)

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

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

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

[quote]SOME SYMBOLS THAT MIGHT BE LEGAL ARE: Ý ??([/quote]

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

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

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

DSNT418I SQLSTATE   = 42601 SQLSTATE RETURN CODE

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

[code] CREATE TYPE user_var as CHAR(255) array[100];[/code] But it ends in SQLCODE=-104


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

DSNT418I SQLSTATE = 42601 SQLSTATE RETURN CODE
[/code]

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