If this is your first visit, be sure to
check out the FAQ by clicking the
link above. You may have to register
before you can post: click the register link above to proceed. To start viewing messages,
select the forum that you want to visit from the selection below.

Unanswered: db2 quey user prompt

DB2 itself does not support that. But if you are using QMF, then put an ampersand in front of the variable.

select * from emp where empno = &empno_input

If you are using something besides QMF, you are out of luck (unless the query interface itself has a facility like QMF for variable prompting). SPUFI has no such facility unless they added it very recently.