Input parameter value while executing SQL

jinsezh · #1 (**permalink**) 08-31-06, 14:44

Hi there,

In oracle, if I run

select * from employer where emplorer name like &EmpName;

the system will prompt me to input the value for parameter 'EmpName'.

Is there any way in DB2 I can do the same thing?

Thanks,
Jinsezh

ARWinner · #2 (**permalink**) 08-31-06, 15:39

I assume you mean in the CLP. THe answer is no.

Andy

Marcus_A · #3 (**permalink**) 08-31-06, 20:46

That does work with the QMF query tool for DB2 for z/OS (which I am sure is where Oracle stole it from). But it is not really the Oracle database engine, but the Oracle SQL+ interface that does that.

Peter.Vanroose · #4 (**permalink**) 09-03-06, 03:19

On unix or linux (or any OS where you can install and run bash) the following shell script does roughly what you want:

Code:

#! /bin/bash
echo "Enter EmpName (may include '%' or '_' wildcards): \c"
read EmpName
db2 select \* from employer where employer_name like $EmpName

jinsezh · #5 (**permalink**) 09-05-06, 18:01

Thank you all.

I found it in QMF, the query is exactly the same as in Oracle, the parameter also declares with &.

Cheers,
jinsezh

Internet Services

Web Development

Digital Marketing

Consumer Tech