Hi,

I have a problem using the select query to retreive the data containing '. I am using Aqua data studio as my DB2 client and my server is DB2 8.1.

For example,

select * from PLAN where plan_name = 'A''

I am selecting for a plan whose plan name is A'. I was able to insert this data using my java code.

When I am executing this query, I get the following error,
...