//Declare a Table like entity in ECL
/*
SQL Equivalent:

CREATE TABLE Products (
  productCode VARCHAR(15) NOT NULL,
  productName VARCHAR(70) NOT NULL,
  productLine VARCHAR(50) NOT NULL,
  productScale VARCHAR(10) NOT NULL,
  productVendor VARCHAR(50) NOT NULL,
  productDescription TEXT NOT NULL,
  quantityInStock SMALLINT NOT NULL,
  buyPrice DOUBLE NOT NULL,
  MSRP DOUBLE NOT NULL,
  PRIMARY KEY (productCode)
);
*/

//In ECL you will declare a Record and a Dataset definition
//The Dataset definition references a file (~cm::products) on disk
Product := RECORD
	STRING productCode;
	STRING100 productName;
	STRING productLine;
	STRING productScale;
	STRING productVendor;
	STRING productDescription;
	INTEGER quantityInStock;
	DECIMAL7_2 buyPrice;
	DECIMAL7_2 MSRP;
END;
products := DATASET('~cm::products', Product , csv);