Notebook question with using parameters #3162
mikemoegling-wbs
started this conversation in
General
Replies: 0 comments
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment
Uh oh!
There was an error while loading. Please reload this page.
Hello,
I am working on a notebook and have a SQL statement that uses a "?" for parameter prompting. I read through the documentation and found a good explanation of parameter binding. In DB2 for i that worked fantastic. I am trying to put the same SQL into a notebook for DB2 for i and it seems as if parameters, bound or not bound does not work. The specific error is : [SQL0104] Token ; was not valid. Valid tokens: ., 42601, -104.
It is OK if parameters are not supported yet, I am just wanting to know if I am missing something, doing something wrong, or this can't be done at this moment.
My SQL is:
`select
mid, mname, mopt, mfunction, mpgm, pohpgm, podobj, podlib, podatr, podcmd, podtxt, poparm1, poparm2, secval
from
wbsprojde.utl003dbv
where
mpgm = ?
or pohpgm = ?
or poparm1 = ?
group by
mid, mname, mopt, mfunction, mpgm, pohpgm, podobj, podlib, podatr, podcmd, podtxt, poparm1, poparm2, secval
order by
mid, mopt;
All reactions