Re: Inserting apostrophes into columns thru tp gateway

scis_at_cyberramp.net (Clay Isaacs) wrote:

> In article <4dbq5v$7jf_at_news.iag.net>, delphi@iag.net says...
> >
> >Use a double single quote (''), This is interpreted as a single quote.
> >
> >Dr. Phil
> >
>
> We have a problem that is similar but the update goes through an Oracle
> transparent gateway (v3.0.13) to DB2/MVS. For example:
>
> UPDATE DB2_TABLE
> SET DB2_TABLE_COLUMN='Monday"s'
>
> results in the DB2 column = Monday
>
> or trying
> SET DB2_TABLE_COLUMN="Monday's" results in Monday. The results seem to
> be inconsistent in what actually gets put into the table.
>

So did you try:

   SET DB2_TABLE_COLUMN='Monday''s' ?

I would think that's all you need...

HTH -=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=- Chris Kasten
Programmer/Analyst (among others...)

#include <sys/std_disclaimer.h>
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=- Received on Wed Jan 17 1996 - 00:00:00 CET