adjusted present-loc ddl for NOT NULL fields; added dataload instructions and commands