Results 1 to 2 of 2
  1. #1
    Join Date
    Jan 2004
    Location
    hyderabad
    Posts
    10

    Unanswered: substitution variables

    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

  2. #2
    Join Date
    Aug 2001
    Location
    UK
    Posts
    4,650

    Re: substitution variables

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

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

    Cheers
    sathyaram

    Originally posted by ramakrishna
    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
    Visit the new-look IDUG Website , register to gain access to the excellent content.

Posting Permissions

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