Results 1 to 5 of 5

Thread: oracle--->db2

  1. #1
    Join Date
    Feb 2004
    Posts
    18

    Unanswered: oracle--->db2

    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?

  2. #2
    Join Date
    Nov 2003
    Location
    Netherlands
    Posts
    96
    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

  3. #3
    Join Date
    Feb 2004
    Posts
    18
    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?

  4. #4
    Join Date
    Jul 2006
    Location
    Pune , India
    Posts
    433
    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

  5. #5
    Join Date
    Feb 2004
    Posts
    18
    thanks for telling me your experience.
    do you know how to relize with unix shell.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •