Results 1 to 2 of 2
  1. #1
    Join Date
    Apr 2008
    Posts
    5

    Unanswered: Difference between SQL procedures and compound SQL Statments

    I would like to know Difference between SQL procedures and compound SQL Statments. Please let me know about the performanance using these.

    Thanks
    Shiva

  2. #2
    Join Date
    Jan 2007
    Location
    Jena, Germany
    Posts
    2,721
    A DB2 procedure may contain a compound statement, gets a name and it is stored at the server - hence the name "stored procedure". You can execute a stored procedure using the CALL statement.

    A compound statement is just a sequence of SQL statements. It may be contained in a stored procedure or UDF.
    Knut Stolze
    IBM DB2 Analytics Accelerator
    IBM Germany Research & Development

Posting Permissions

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