Results 1 to 3 of 3
  1. #1
    Join Date
    Feb 2007
    Location
    Bratislava, Slovakia
    Posts
    85

    Unanswered: how to store variables in sql/pl

    Hi all,
    I am looking for replacement of oracle functionality. in package body I can declare public variable, which store value after execution of procedure or function, prepared for next call procedure or function. this variable is saved until session running.
    exists some possibility in db2?
    thanks.
    baloo
    Beer contains just a small amount of vitamines - that's why it's necessary to drink lot of it.

  2. #2
    Join Date
    Jan 2007
    Location
    Jena, Germany
    Posts
    2,721
    You can create a table (possibly a temporary table) and store your variables there.
    Knut Stolze
    IBM DB2 Analytics Accelerator
    IBM Germany Research & Development

  3. #3
    Join Date
    Feb 2007
    Location
    Bratislava, Slovakia
    Posts
    85
    stolze: thanks for response.
    Beer contains just a small amount of vitamines - that's why it's necessary to drink lot of it.

Posting Permissions

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