Page 1 of 1
Create array in DB2 on zOS ends in SQLCODE=-104.
Posted: Wed Feb 17, 2016 10:30 pm
by 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?
Re: Create array in DB2 on zOS ends in SQLCODE=-104.
Posted: Wed Feb 17, 2016 10:58 pm
by 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
------------------------
| ??- | ˜
| ??! | |
| ??’ | ˆ
| ??( | [
| ??) | ]
| ??/ | \
| ??< | {
| ??= | #
| ??> | }
Re: Create array in DB2 on zOS ends in SQLCODE=-104.
Posted: Sat Feb 20, 2016 9:09 pm
by ArrayinDB2
Thanks it was indeed a code page error. Support is helping on this.
Re: Create array in DB2 on zOS ends in SQLCODE=-104.
Posted: Sun Feb 21, 2016 9:15 am
by Anuj Dhawan
Thanks for the feedback.