Results 1 to 2 of 2
  1. #1
    Join Date
    Feb 2011
    Posts
    36

    Unanswered: Parameter in DB2 query

    Is there a way to parameterize a select query so that the user is prompted for the parameter value at runtime, like this:

    SELECT ABC from XYZ
    WHERE
    ABC = ParameterValue

    ...where I hope to find some way for the user to be prompted to enter the value for ParameterValue.

  2. #2
    Join Date
    May 2003
    Location
    USA
    Posts
    5,737
    What DB2 version and operating system are you using? What query tool are you using?
    M. A. Feldman
    IBM Certified DBA on DB2 for Linux, UNIX, and Windows
    IBM Certified DBA on DB2 for z/OS and OS/390

Posting Permissions

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