Results 1 to 2 of 2
  1. #1
    Join Date
    Oct 2013

    Unanswered: parameterized PreparedStatement with XPath expression

    What I'd like to do:

    "WHERE XMLEXISTS('$e//$l[fn:contains(./text(), $n)]'
    	PASSING table.entry AS \"e\",
    	CAST(? AS VARCHAR(128)) AS \"l\",
    	CAST(? AS VARCHAR(128)) AS \"n\"
    but it keeps saying that $l is the wrong type... Is there a way to do what I'm attempting without resorting to piecing together the String?

  2. #2
    Join Date
    Apr 2008
    Iasi, Romania
    Provided Answers: 3
    I'm not sure you can use parameter markers for node names.
    Florin Aparaschivei
    DB2 9.7, 10.5 on Windows
    Iasi, Romania

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts