Results 1 to 2 of 2
  1. #1
    Join Date
    Jun 2005
    Location
    Chennai
    Posts
    16

    Unanswered: What is native sql procedure in db2 ?

    Stored Procedures Types
    1. External high level language procedures COBOL, PL/I, C, C++, Assembler, REXX, and Java
    2. External SQL language procedures
    3. Native SQL language stored procedures Introduced by DB2 9 for z/OS


    • What is Native sql procedure ?
    • What is the difference between External and Native SQL procedures?
    Learning, Keep on learning.....

  2. #2
    Join Date
    Jan 2007
    Location
    Jena, Germany
    Posts
    2,721
    In DB2 z/OS, a procedure created with LANGUAGE SQL resulting in the generated of code (I don't know which programming language, though). You had to bind a DBRM for that. With DB2 V9 for z/OS, DB2 stores the procedure in the DB2 catalog and executes it directly - such a "native" procedure has no longer the step over an external module and DBRM.
    Knut Stolze
    IBM DB2 Analytics Accelerator
    IBM Germany Research & Development

Tags for this Thread

Posting Permissions

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