ADD TABLE "SmartProduct"
  AREA "Data"
  DUMP-NAME "smartproduct"
  TABLE-TRIGGER "CREATE" NO-OVERRIDE PROCEDURE "SmartDBtrgs/crSProduct.p" CRC "?" 

ADD FIELD "ProductGuid" OF "SmartProduct" AS character 
  FORMAT "x(36)"
  INITIAL ""
  POSITION 2
  MAX-WIDTH 72
  ORDER 10

ADD FIELD "ProductCode" OF "SmartProduct" AS character 
  FORMAT "x(20)"
  INITIAL ""
  LABEL "Code"
  POSITION 3
  MAX-WIDTH 40
  ORDER 20

ADD FIELD "ProductName" OF "SmartProduct" AS character 
  FORMAT "x(80)"
  INITIAL ""
  LABEL "Name"
  POSITION 4
  MAX-WIDTH 160
  ORDER 30

ADD FIELD "ProductDescription" OF "SmartProduct" AS clob 
  FORMAT "x(8)"
  INITIAL ?
  POSITION 5
  LOB-AREA "LOB"
  LOB-BYTES 104857600
  LOB-SIZE 100M
  CLOB-CODEPAGE "UTF-8"
  CLOB-COLLATION "basic"
  CLOB-TYPE 2
  ORDER 40

ADD FIELD "ProductInstalled" OF "SmartProduct" AS logical 
  FORMAT "yes/no"
  INITIAL "no"
  LABEL "Installed"
  POSITION 6
  MAX-WIDTH 1
  ORDER 50

ADD INDEX "ProductGuid" ON "SmartProduct" 
  AREA "Index"
  UNIQUE
  PRIMARY
  INDEX-FIELD "ProductGuid" ASCENDING 

ADD INDEX "ProductCode" ON "SmartProduct" 
  AREA "Index"
  UNIQUE
  INDEX-FIELD "ProductCode" ASCENDING 

ADD INDEX "ProductName" ON "SmartProduct" 
  AREA "Index"
  INDEX-FIELD "ProductName" ASCENDING 

.
PSC
cpstream=ISO8859-1
.
0000001327