Results 1 to 2 of 2

Thread: db2 compiler

  1. #1
    Join Date
    Nov 2002

    Unanswered: db2 compiler

    V8 is supposed to have a compiler built in, how do I use it or install it.
    David Quigley

  2. #2
    Join Date
    May 2003
    I believe that you may be talking about the fact that starting in V8.2, SQL stored procedures and functions do not need a C compilier on your server. That is not because 8.2 comes with a C compiler, but because the SQL statements are converted to native representation and stored in the catalog as is the case with other SQL statements. Previously, stored procedures and UDF's written in SQL where converted to C programs with embedded SQL and then compiled.

    DB2 V8.2 is equivilent to 8.1 with FP7 or higher.

    If instead, you are asking about the DB2 pre-compiler that is used for C, COBOL, etc, programs with embedded SQL, then check out the Application Programming Guide. A pre-compiler converts the SQL statements to regular lanuguage calls to DB2 modules (packages) so that the program can then be compiled with a regular compiler (not included).
    Last edited by Marcus_A; 01-28-06 at 22:41.
    M. A. Feldman
    IBM Certified DBA on DB2 for Linux, UNIX, and Windows
    IBM Certified DBA on DB2 for z/OS and OS/390

Posting Permissions

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