Find Strings which Contain Double Quotes

SDyke · #1 (**permalink**) 01-05-12, 12:47

I need help with db2 sql syntax that uses posstr to find string taht contain double quotes. The following gives syntax error.

testconnString = "Select * From amflib1.itemasa Where posstr(itdsc, '""') > 0"

tonkuma · #2 (**permalink**) 01-05-12, 14:29

Strings in DB2 sould enclosed with single quotations.

Please try ...
testconnString = 'Select * From amflib1.itemasa Where posstr(itdsc, ''"'') > 0'

SDyke · #3 (**permalink**) 01-05-12, 14:34

Still get syntax error

tonkuma · #4 (**permalink**) 01-05-12, 15:07

What was the exact error message(s)?

You might want to assign a string to a variable testconnString. But it is not meet a syntax of DB2 SQL.

DB2 syntax is

Code:

Syntax

>>-SET---------------------------------------------------------->

     .-,------------------------------------------------------------------.     
     V                                                                    |     
>--+---+-| target-variable |--=--+-expression-+-------------------------+-+-+-><
   |   |                         +-NULL-------+                         |   |   
   |   |                         '-DEFAULT----'                         |   |   
   |   |    .-,-------------------.             .-,--------------.      |   |   
   |   |    V                     |             V                |      |   |   
   |   '-(----| target-variable |-+--)--=--+-(----+-expression-+-+--)-+-'   |   
   |                                       |      +-NULL-------+      |     |   
   |                                       |      '-DEFAULT----'      |     |   
   |                                       '-(--row-fullselect--)-----'     |   
   +-boolean-variable-name--=--+-search-condition-+-------------------------+   
   |                           +-TRUE-------------+                         |   
   |                           +-FALSE------------+                         |   
   |                           '-NULL-------------'                         |   
   +-array-variable-name--[--array-index--]--=--+-expression-+--------------+   
   |                                            '-NULL-------'              |   
   +-target-cursor-variable--=--+-cursor-variable-name---------+------------+   
   |                            +-| cursor-value-constructor |-+            |   
   |                            '-NULL-------------------------'            |   
   |                                  .-,--------------.                    |   
   |                                  V                |                    |   
   '-| target-row-variable |--=--+-(----+-expression-+-+--)-+---------------'   
                                 |      '-NULL-------'      |                   
                                 +-(--row-fullselect--)-----+                   
                                 +-row-expression-----------+                   
                                 '-NULL---------------------'

See more detailes in
SET variable - IBM DB2 9.7 for Linux, UNIX, and Windows

fengsun2 · #5 (**permalink**) 01-05-12, 20:55

Maybe you can use chr() function to do this

testconnString = "Select * From amflib1.itemasa Where posstr(itdsc, chr(34)) > 0"

tonkuma · #6 (**permalink**) 01-05-12, 22:34

SDyke,

Is the code in op extracted from other than an SQL routine(compound SQL, SQL function, or SQL procedure, so on)?

If so, I want to recommend you
to extract the select statement from your program and execute it independently,
and see exact error code/error text of the error message(s) you received.

Internet Services

Web Development

Digital Marketing

Consumer Tech