Transcription of Native SQL Stored Procedures - The …
{{id}} {{{paragraph}}}
Example: stock market
Native SQL Stored Procedures - The …
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.
Native 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
Loading..
Tags:
Information
Domain:
Source:
Link to this page:
Please notify us if you found a problem with this document:
Related search queries
PROC SQL, A Primer for SAS Programmers, Data Step Proc SQL, Merging Tables in DATA Step, PROC, Merging Tables in DATA Step vs. PROC SQL: Convenience, DATA Step vs. PROC SQL: What, MERGING vs. JOINING: Comparing the DATA Step, SAS DATA Step, SAS SQL, Data, Look at Dictionary Tables &, Queries, Joins, and WHERE Clauses