APILOG - Invocation Log Of APIs

Dec 21, 2024

CREATE TABLE K3S_5WEB.APILOG ( 
	BIRTH TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP , 
	APINAME VARCHAR(10) CCSID 37 DEFAULT NULL , 
	"UPDATE" TIMESTAMP GENERATED ALWAYS 	FOR EACH ROW ON UPDATE AS ROW CHANGE TIMESTAMP NOT NULL , 
	"USER" VARCHAR(10) CCSID 37 DEFAULT NULL , 
	COMPLETED SMALLINT DEFAULT 0 , 
	NOTE VARCHAR(100) CCSID 37 DEFAULT NULL )   
	  
	RCDFMT APILOG     ; 
  
LABEL ON TABLE WEB_5WEB.APILOG 
	IS 'Web - API Log Activity' ; 

---