DB2 SQL PL - Features For ZO/S Mainframe


We can compile DB2 PL/SQL either in:
  • DB2 command line processor (CLP)
  • DB2 CLPPlus
  • IBM® Data Studio client
The procedure which are written purely in SQL PL are called native SQL procedures.

The procedures which are written in other than SQL/PL are called external stored procedures
Cobol,PL/I,REXX,Java,C,C++,Assembler. The calling procedure interacts with WLM

SAMPLE PROCEDURE DB2 ZO/S:
OUT P_SUMSAL DECIMAL(11,2),OUT P_SQLCODE INTEGER)PACKAGE OWNER XYZ  QUALIFIER ABCDRESULT SETS 0  LANGUAGE SQLCREATE PROCEDURE SPA81(OUT P_CNT1 SMALLINT,
VERSION V1
ISOLATION LEVEL CS  VALIDATE BIND
P1: BEGIN
DECLARE SQLCODE INEGER DEFAULT 0;
SELECT COUNT(*), SUM(SALARY)
INTO P_CNT1,P_SUMSAL
FROM EMP;
SET P_SQLCODE = SQLCODE
END P1

Comments

Post a Comment

Popular posts from this blog

Top myths for NULL value in SQL Queries

Image
The below are some of the key points about nulls, and how to compare them. Just to make sure that you should know about what is NULL value. Interpretation is not exactly missing value. There could be many reasons why no value is present, e.g., value inappropriate. How to compare NULL to values In the below example the where condition just checks for TRUE condition. If not matches you will get UNKNOWN. Example: Table Name is: Sells bar beer price ======================= Joe's bar Bud NULL SELECT bar FROM Sells WHERE price < 2.00 OR price >= 2.00; ------------ ------------- UNKNOWN Conclusion Joe's Bar is not produced, even though the WHERE condition is correctly given. The reason is the price value is NULL. So, we should not compare NULL to values.
Read more