Using Microsoft Visual Studio debugger for user-defined functions

These steps will give the Microsoft Visual Studio 2008 developers the ability to step through the user-defined functions code.

  1. Attach the debugger to a running server:
    devenv /debugexe "%IQDIR15%\bin32\iqsrv15.exe"
  2. Goto Debug | Attach to Process
  3. To start the server and debugger together:
    devenv /debugexe "%IQDIR15%\bin32\iqsrv15.exe" [commandline options for your server]

    Each platform will have a debugger and each will have their own command line syntax. Sybase IQ source code is not required. The msvs debugger will recognize when the user-defined functions source is executed and break at the set breakpoints. When control returns from the user-defined functions to the server, you will only see machine code.

Related concepts
User-defined function restrictions
Maintenance of user-defined functions
Compiling and linking source code to build dynamically linkable libraries
SQL data types
Related tasks
Creating a user-defined function
Calling user-defined functions
Setting the dynamic library interface
Dropping user-defined functions
Granting and revoking permissions