Db2 Developer-C 11.1

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.

CREATE TABLE Patient
(   pat_id char(5) NOT NULL PRIMARY KEY
  , pat_name varchar (50)
)
INSERT INTO PATIENT VALUES ('P0001', 'John Smith'), ('P0010', 'Jane Doe')
CREATE SEQUENCE PATIENT_SEQ AS DEC (4) START WITH 11
CREATE TRIGGER PATIENT_BIR
BEFORE INSERT ON PATIENT
REFERENCING NEW AS N
FOR EACH ROW
SET PAT_ID = 'P' || DIGITS (NEXTVAL FOR PATIENT_SEQ)
INSERT INTO PATIENT (PAT_NAME)
VALUES
  ('Natalie Lim')
, ('Kelly Tan')
SELECT * FROM PATIENT


PAT_ID
PAT_NAME


P0001
John Smith

P0010
Jane Doe

P0011
Natalie Lim

P0012
Kelly Tan