Transcription of Native SQL Stored Procedures - …
{{id}} {{{paragraph}}}
Native SQL Stored ProceduresRobert AndresenPrincipal ConsultantIBM Certified Database Administrator, DB2 9 for z/OSIBM Certified SOA AssociateITIL Foundation CertifiedCell: +1 630 vs. external SQL Procedures > Native SQL procedure definition>Versioning> Native SQL procedure execution>Deploying a Native SQL procedure to other servers>DB2/DSN/SQL: changes to commands>Testing, error handling and debugging Sample Rexx exec to test Native SQL procedure>Migrating external to Native SQL proceduresExternal SQL Procedures >New in DB2 V5>Required SQL code plus C code>Multiple step prepare>Runs in WLM environmentNative SQL Procedures >New in DB2 9 NFM>Simpler builds No C/C++ compile Single step DDL>Better performance executed in DB2 DBM1 address space, not WLM>zIIP eligible Saves on software licensing costs>Enhanced support for SQL PL FOR loops Nested compound statements Data types BIGINT, BINARY, VARBINARY & >New table in DB2 9>Environment information Index on expressions Native SQL procedure>ENVID is unique environment identifier> column TEXT_ENVID points to SYSENVIRONMENTA uthorization>CREATE PROCEDURE SQL CREATEIN for the schema SYSADM or SYSCTRLN ative SQL Procedures >Compiled into run time structures>Bound when created>Loaded into EDM Pool at execute time Large packages Watch EDM Pool failuresSample RETURNDEPTSALARY>In IBM SQL Reference>Modified to use tableSample Native SQLCREATE PROCEDURE RETURNDEPTSALARY (IN DEPTNUMBER CHAR(3).)
Native SQL Stored Procedures Robert Andresen Principal Consultant IBM Certified Database Administrator, DB2 9 for z/OS IBM Certified SOA Associate
Domain:
Source:
Link to this page:
Please notify us if you found a problem with this document:
{{id}} {{{paragraph}}}
Installing WebSphere Application Server on, Directory, Best Practices for DB2 on z/OS Backup and Recovery, DB2 Utility Update - Best Practices, DB2 Utility Update: Best Practices, DB2 12 for z/OS, Considerations, For z/OS Migration Overview, Database Guide: DB2 Universal Database, Database Guide: DB2 Universal Database for