--  Revision date 20030801
--
--  This is an example of loading extra data from a file where the VCS_ID is
--  known and the VCS_DATA_NAME is constant as is the VCS_SUPP.
--  This shows how to load data from the aids nci set 
--  VCS_ID and the aids activity as a 2 character code are supplied in a csv
--  file
--  It is useful to set ERRORS to a high number as accordong to the model data 
--  which have a VCS_ID which is not in the VCS_MAIN file will be ignored and
--  written to the *.bad file
--  Data files of this type often have a header line which you may wish to skip
--  the line rather than allow it to be written to the *bad file 
--  In this example the NSC number ( VCS_ID ) and the aids activity as a 2
--  character code are supplied in a csv  file with one header line 
--  "NSC,Conclusion"
--  So 
--  ERRORS        = 999999
--  SKIP          = 1
--  VCS_SUPP      = "0"
--  VCS_DATA_NAME = "NCI_AIDS_CLASS"
-- 
--  These data ( at least )  will need to be changed for other input.


OPTIONS (ERRORS=999999, SKIP=1)
LOAD DATA
        APPEND INTO TABLE VCS_DATA
        FIELDS TERMINATED BY ',' OPTIONALLY ENCLOSED by '"'
        (
        VCS_ID  CHAR,
        VCS_SUPP CONSTANT "0",
        VCS_DATA_NAME CONSTANT "NCI_AIDS_CLASS",
        VCS_DATA_VALUE CHAR(4000)
        )