how to store variables in sql/pl

baloo99 · #1 (**permalink**) 09-14-07, 05:17

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

stolze · #2 (**permalink**) 09-15-07, 09:40

You can create a table (possibly a temporary table) and store your variables there.

baloo99 · #3 (**permalink**) 09-15-07, 15:19

stolze: thanks for response.

Internet Services

Web Development

Digital Marketing

Consumer Tech