How do I fetch a result of a select query in a temporary variable?

[Shiva J]

Hi all,

I need to fetch a data output of an sql query in a temp variable. Can someone here help me out.

Thanks in advance,
Shiva J

[Frinavale]

Please try to describe more about your problem.

What is the query supposed to do?

Are you trying to execute DB2 queries from application code like C#, Java, VB.NET, php or something? If so, is the temp variable part of that calling code?

Or is your temp variable part of a DB2 script that you are attempting to write?

-Frinny