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