Yes, it will work.
Pure JDBC only supports index, not named parameters. Named parameter (:userId) is not part of Java. There are third party libraries supporting it. http://www.javaworld.com/article/2077706/core-java/named-parameters-for-preparedstatement.html Regards, Will ________________________________ From: Cheyenne Forbes <cheyenne.osanu.for...@gmail.com> Sent: Thursday, March 23, 2017 1:27 PM To: user@phoenix.apache.org Subject: Re: Define parameters in queries Will I be able to change the value of userId from in the query? :userId = CASE WHEN userId > 10 THEN userId ELSE (userId + 1) END