db2 char column with ' and " as part of data

[rexxit]

Hello. I am writing a REXX/DB2 apps that will be inserting and updateing a table. One of the columns is a CHAR. This is used to for stuff like height. Such as 12'10". when I attempt to do this i get a -104. I have tried surronding the data with quotes such as '''value'''. Nothing seems to work. Either I get a -104 or a REXX error about unequal quotes etc. Has anyone a reliable method to overcome this issue. I am in a MVS/os/390 environment using db2 v7.

thanks.

 

[rexxhead]

Typically when you have quotes inside a quoted string you have to double them:

fld = ' 12''10" '

I don't know if that would work for you, but you may want to give it a try.

Frank Clarke
Tampa Area REXX Programmers' Alliance
REXX Language Assn Listmaster