Results 1 to 2 of 2

Thread: inline SQL

  1. #1
    Join Date
    Dec 2003
    Posts
    39

    Thumbs down Unanswered: inline SQL

    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

  2. #2
    Join Date
    Jan 2003
    Location
    Zutphen,Netherlands
    Posts
    256
    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
    Ties Blom
    Senior Application Developer BI
    Getronics Healthcare
    DB2,ORACLE,Powercenter,BusObj,Access,
    SQL, SQL server

Posting Permissions

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