Re: Inserting apostrophes into columns thru tp gateway
From: Clay Isaacs <scis_at_cyberramp.net>
Date: 1996/01/17
Message-ID: <4dj8i6$42b_at_newshost.cyberramp.net>#1/1
Date: 1996/01/17
Message-ID: <4dj8i6$42b_at_newshost.cyberramp.net>#1/1
In article <4dbq5v$7jf_at_news.iag.net>, delphi_at_iag.net says...
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
results in the DB2 column = Monday
or trying
>
>Use a double single quote (''), This is interpreted as a single quote.
>
>Dr. Phil
>
SET DB2_TABLE_COLUMN='Monday"s'
SET DB2_TABLE_COLUMN="Monday's" results in Monday. The results seem to
be inconsistent in what actually gets put into the table.
Has anyone run into this problem using the transparent gateway to DB2? How did you get it to work? Is this possibly a bug?
Any help would be appreciated
Clay Received on Wed Jan 17 1996 - 00:00:00 CET