In this chapter, you have seen the usage of the cursors in SQL procedures. Cursors allow you to access and process data one row at a time, giving you the opportunity to implement much more complex logic that would otherwise be impossible or difficult to carry out. When using cursors to process data, you can perform reads and positioned deletes/updates. You can use the cursor either to process the data within the SQL procedure, or to return result sets to the client program.

    DB2 SQL PL. Deployment and Advanced Configuration Essential Guide for DB2 UDB on Linux., UNIX, Windows, i5. OS, z. OS
    Intelligent Enterprises of the 21st Century
    ISBN: N/A
    EAN: 2147483647
    Year: 2003
    Pages: 205 © 2008-2017.
    If you may any questions please contact us: