hi


I like to know about substitution variables in db2.

select * from employee where deptno=?

i want to supply the deptno at runtime. how to do it

in oracle we do the same like

select * from employee where deptno=&dno

it will ask us at run time to supply value


how to do the same in db2. I tried with & but it is not working plz let me know

AFAIk, you cannot do this with plain SQL ...

You should be using some scripting or programming to achieve this in DB2

Cheers
sathyaram