Parameter Passing In Db2

skarri · #1 (**permalink**) 10-30-08, 05:31

this is the way in oracle to ask a user to pass a required value

Quote:

select ename from emp where mgr=&12;

output will be:

Quote:

Enter value for 12: 7788
old 1: select ename from emp where mgr=&12
new 1: select ename from emp where mgr=7788

ENAME
----------
ADAMS

so how do we do this in DB2

stolze · #2 (**permalink**) 10-30-08, 07:46

You write a shell/Perl/Python/... script that does the I/O that and then the script executes SQL statements. There is rarely the need to invent another language/extension for that.

madhu_kaza · #3 (**permalink**) 10-30-08, 13:03

You can write one scalar UDF where you can pass mgr value as input parameter and return ename as output.

Thanks,
Madhavi

stolze · #4 (**permalink**) 10-30-08, 13:24

I understood the question in such a way that the '&12' syntax actually triggers a user-interaction over the console and the user has to enter some value there.

dav1mo · #5 (**permalink**) 10-30-08, 15:51

same syntax exists in QMF.

skarri · #6 (**permalink**) 10-31-08, 08:13

Yes,i would require an output as Mr.STOLZE mentioned

Internet Services

Web Development

Digital Marketing

Consumer Tech