/*
-------------------------------------------------------------------------------------------------------------------------------
--                        
-- Mandator:              Open MaxDB Group - Data Management.
-- Legacy System:         omdg
-- Script:                omdg_sqlsamples_create_load.sql
-- Theme:                 Script to create the additional table omdg_samples in schema hotel.
--                        Demonstration of
--                        - Invocation of loadercli
--                        - CREATE TABLE statement
--                        - IMPORT Statement using LOB Specification
-- Author:                RDa
-- Synopsis:              loadercli -d admin -u mona,red -E 0 -b omdg_sqlsamples_create_load.sql
-- Interface definition:  hotel.omdg_sqlsamples
-- Modify date:           2008.02.02 - RDa - (OMDG, Ralf Dahmen) - Creation for demonstration
-------------------------------------------------------------------------------------------------------------------------------
*/
DROP   TABLE hotel.omdg
//
CREATE TABLE hotel.omdg
(
        "GROUPID"       CHAR (128) ASCII  NOT NULL,
        "CATEGORYID"    CHAR (128) ASCII  NOT NULL,
        "IDENT"         INTEGER,
        "STATEMENT"     LONG ASCII,
        "RESULT"        LONG ASCII
)
//
COMMENT ON TABLE hotel.omdg             IS 'Samples to get familiar with MaxDB, prepared by OMDG'
//
COMMENT ON COLUMN hotel.omdg.groupid    IS 'String to group the samples, may used for HTML output.'
//
COMMENT ON COLUMN hotel.omdg.categoryid IS 'String to subgroup the samples, may used for HTML output.'
//
COMMENT ON COLUMN hotel.omdg.ident      IS 'Identifier to sort the samples, has to be used for execution sequence and may used for HTML output.'
//
COMMENT ON COLUMN hotel.omdg.statement  IS 'SQL Statement / Tool invocation examples / Interface examples'
//
COMMENT ON COLUMN hotel.omdg.result     IS 'Execution output of the statement.'