DB2 STORED PROCEDURE

Hi
Can someone validate if the following Stored Procedure is valid:

CREATE PROCEDURE SPROC.PMDR0002 (
  IN STATS_DT DATE,
  IN STATS_HR CHAR(2),
  IN AUD_PGM_ID CHAR(8),
  IN AUD_OPID CHAR(8),
  IN AUD_TS TIMESTAMP )
  LANGUAGE SQL
  MODIFIES SQL DATA
  COLLID SPROC
  WLM ENVIRONMENT DBD1WLM1
  ASUTIME NO LIMIT
  SECURITY DB2
  STAY RESIDENT YES
  EXTERNAL NAME 'PMDR0002'
  RUN OPTIONS 'ALL31(ON) HEAP(,,ANY) STACK(,,ANY,)'
------------------------------------------------------------------------
-- SQL Stored Procedure
-- Long Name:  FIND MERCHANT BY AFFILIATE, CHANNEL, STORE, AND PAYMENT METHOD
------------------------------------------------------------------------
P1: BEGIN
INSERT INTO AU002AT_AU_TMPSTAT
values (STATS_DT,STATS_HR, , , , , , , , AUD_PGM_ID, AUD_OPID, AUD_TS);  <---
  END P1

Notice that in the table AU002_AU_TMPSTAT I have to only insert a few fields the rest of the fields have to be null, is the above method OK? High points coz I need a prompt confirmation.

Thank You
ngujjaStart Free Trial