In oracle:
Oracle Database 10g Enterprise Edition Release 10.1.0.2.0 - Production
With the Partitioning, OLAP and Data Mining options
に接続されました。
SQL> SELECT * FROM &1
2 ;
1に値を入力してください: DUAL
旧 1: SELECT * FROM &1
新 1: SELECT * FROM DUAL

D
-
X

Now i want to know how to realize the same feature in db2?

Hi,

You have a lot of chinese symbols in your post which doesn't help to answer your question.

The 'select 1 from dual' can be changed to 'select 1 from sysibm.sysdummy1' or 'values (1)' but I don't know if this answers all your questions.

Regards, Gert

sorry:
this is Japanese code.
Now i change to english.
i will appreciate for your help
In oracle:
Oracle Database 10g Enterprise Edition Release 10.1.0.2.0 - Production
With the Partitioning, OLAP and Data Mining options
connected.
SQL> SELECT * FROM &1
2 ;
1Please input value. : DUAL
old 1: SELECT * FROM &1
new 1: SELECT * FROM DUAL

D
-
X
The important point is '&' in oracle.how to realize in db2?

ok.. so '&' takes input at runtime in oracle while executing sql staements.
i havn't come across any such thing yet in db2 ....
may be its not supported in DB2.
"EXPERTS" on the forum will clear the doubt well.

--Rahul Singh

thanks for telling me your experience.
do you know how to relize with unix shell.