CREATE OR REPLACE PROCEDURE CAS.ROWTYPECHECK ( P_APPLICATION_REC TAPPLICATION%ROWTYPE )
IS
BEGIN
INSERT INTO "CAS"."VAPPLICATION"
VALUES P_APPLICATION_REC;
END;
But I'm getting one error while deploying.
Deploy CAS.ROWTYPECHECK
Running
CAS.ROWTYPECHECK - Deploy started.
Create stored procedure returns SQLCODE: -104, SQLSTATE: 42601.
CAS.ROWTYPECHECK: 1: An unexpected token "%" was found following "ON_REC
TAPPLICATION". Expected tokens may include: ",".. SQLCODE=-104, SQLSTATE=42601, DRIVER=4.16.53
An unexpected token "%" was found following "ON_REC TAPPLICATION". Expected tokens may include: ",".. SQLCODE=-104, SQLSTATE=42601, DRIVER=4.16.53
CAS.ROWTYPECHECK - Deploy failed.
CAS.ROWTYPECHECK - Roll back completed successfully.
DBMS is DB2 V9.1.
I tried using:
CREATE OR REPLACE PROCEDURE <Sechma>.<ProcedureName>
(<Record> <table/VIEW>%ROWTYPE)