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

This Forum is for the guests or the users who are not registered on this board. This part allows guests to post in.
Previous topicNext topic

Topic Author
ArrayinDB2

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

Post by ArrayinDB2 » Wed Feb 17, 2016 10:30 pm

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
Global Moderator
Global Moderator
Posts: 881
Joined: Wed Sep 11, 2013 3:57 pm

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

Post by enrico-sorichetti » Wed Feb 17, 2016 10:58 pm

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


cheers
enrico
When I tell somebody to RTFM or STFW I usually have the page open in another tab/window of my browser,
so that I am sure that the information requested can be reached with a very small effort 8-)


Topic Author
ArrayinDB2

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

Post by ArrayinDB2 » Sat Feb 20, 2016 9:09 pm

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



User avatar

Anuj Dhawan
Founder
Posts: 2612
Joined: Sun Apr 21, 2013 7:40 pm
Location: Mumbai, India
Zodiac: Sagittarius

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

Post by Anuj Dhawan » Sun Feb 21, 2016 9:15 am

Thanks for the feedback. :)


Thanks,
Anuj

Disclaimer: My comments on this website are my own and do not represent the opinions or suggestions of any other person or business entity, in any way.

Previous topicNext topic

Return to “You are a Guest.”