I need the documentation to understand how inline SQl works ,Can anyone provide me the documentation in detail for the same.Is this inline SQl also called embedded SQL in DB2.Also kindly provide the steps to execute the program

Thanks


Ashaq

Are you referring to working with temporary sets?

Basically this is storing the outcome of the inner SQL statement in a temporary set and then applying SQL over this set again.

Example:

Select temp.x,temp.y from
(Select a,b,c from m,n where ..........................) temp

There is additional syntax that involves using the 'WITH' clause.

Recommendation: SQL cookbooks by Graeme Birchall