I also had a similar issue and after trying many possibilities may have found the solution. When you create the 2nd parameter try this... " where branch_cd = '$P!{b_cd}' " Also, remember to put this syntax in the where clause of the SQL statement: P$!{<Parameter_name>}, where P${<Parameter_name>} is the 2nd parameter and equals " where branch_cd = '$P!{b_cd}' ". Hope this helps someone.