--------------------------------------------------------------- -- MIT License -- Copyright (c) 2016 TEMBO Technology Labs (Pty) Ltd. -- Author: Tommy Atkins - Chief Development Officer -- -- Permission is hereby granted, free of charge, to any person obtaining a copy of this -- software and associated documentation files (the "Software"), to deal in the Software -- without restriction, including without limitation the rights to use, copy, modify, -- merge, publish, distribute, sublicense, and/or sell copies of the Software, and to permit -- persons to whom the Software is furnished to do so, subject to the following conditions: -- -- The above copyright notice and this permission notice shall be included in all copies -- or substantial portions of the Software. -- ================================================================================== -- THE SOFTWARE IS PROVIDED "AS IS", WITHOUT WARRANTY OF ANY KIND, EXPRESS OR IMPLIED, -- INCLUDING BUT NOT LIMITED TO THE WARRANTIES OF MERCHANTABILITY, FITNESS FOR A PARTICULAR -- PURPOSE AND NONINFRINGEMENT. IN NO EVENT SHALL THE AUTHORS OR COPYRIGHT HOLDERS BE LIABLE -- FOR ANY CLAIM, DAMAGES OR OTHER LIABILITY, WHETHER IN AN ACTION OF CONTRACT, TORT OR -- OTHERWISE, ARISING FROM, OUT OF OR IN CONNECTION WITH THE SOFTWARE OR THE USE OR OTHER -- DEALINGS IN THE SOFTWARE. -- ================================================================================== CREATE TABLE AOFCC3F ( ACTDTS TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP, RECSTS CHAR(2) NOT NULL DEFAULT, FILENM CHAR(10) NOT NULL DEFAULT, ACTION CHAR(1) NOT NULL DEFAULT, USERID CHAR(10) NOT NULL DEFAULT, BEFORE VARCHAR(4096) NOT NULL DEFAULT, AFTER VARCHAR(4096) NOT NULL DEFAULT) RCDFMT AOFCC3FR ; --------------------------------------------------------------- LABEL ON TABLE AOFCC3F IS 'AOF Change Collector (Group 3)' ; --------------------------------------------------------------- LABEL ON COLUMN AOFCC3F ( ACTDTS IS 'Timestamp ', RECSTS IS 'R/S ', FILENM IS 'File ', ACTION IS 'Action ', USERID IS 'User ID ', BEFORE IS 'Before Image ', AFTER IS 'After Image '); --------------------------------------------------------------- LABEL ON COLUMN AOFCC3F ( ACTDTS TEXT IS 'Timestamp', RECSTS TEXT IS 'R/S', FILENM TEXT IS 'File', ACTION TEXT IS 'Action', USERID TEXT IS 'User ID ', BEFORE TEXT IS 'Before Image', AFTER TEXT IS 'After Image'); ---------------------------------------------------------------