Win32 Perl Programming: The Standard Extensions, Second Edition

Advanced Features of Win32::ODBC

So far, this chapter has discussed the simplest usage of the Win32::ODBC extension. This is how most scripts use it; however, Win32::ODBC provides access to most of the ODBC 2.0 API. This means that if you are familiar with ODBC, you can control your interactions with databases using some pretty powerful features, including fetching rowsets, cursor control, and error processing.

Managing Cursors

If you are familiar with SQL, you’ll be happy to know that cursors are supported. If you have no idea what cursors are, you probably don’t need to be concerned about them. Cursors are beyond the scope of this book, so very little time will be spent on this topic. Several ODBC functions pertain to their use, however, ...