MVSFORUMS.com

[Jyotsna_mallipeddi]

Hi

I am trying to insert special characters like & # ; which are part of my text. Basically trying to insert a French text into a VARCHAR field. Below is the query which I am trying thru a JCL using IKJEFT01 PGM


INSERT INTO P65.MESSAGE_TEMPLATE
VALUES(998,'124','CA','FR','A','Des amaméliorations');

But the above sql is giving an error saying illegal symbol & found in the text.

Please suggest is there a way for me to insert such data in mainframe DB2 database.

Thanks in advance

Jyotsna

[kolusu]

Jyotsna,

You shouldn't have any problem inserting the values into a VARCHAR field unless you have fieldproc or editproc on the column. try inserting the same values using spufi.

Also I noticed that there is no & in your insert statement shown above. So you did not show us the entire sql or the message is wrong.

Kolusu
_________________
Kolusu
www.linkedin.com/in/kolusu

[videlord]

How can you input '