ADD TABLE "SmartContextStore"
  AREA "Data"
  LABEL "Context Store"
  LABEL-SA "U"
  DESCRIPTION "Persistent Store for Context Dataset between Authenticated REST calls"
  VALMSG-SA "U"
  DUMP-NAME "smartcontextstore"
  TABLE-TRIGGER "CREATE" NO-OVERRIDE PROCEDURE "SmartDBtrgs/crSContextStore.p" CRC "?" 

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

ADD FIELD "UserName" OF "SmartContextStore" AS character 
  FORMAT "x(20)"
  INITIAL ""
  LABEL "User Name"
  POSITION 3
  MAX-WIDTH 40
  ORDER 30

ADD FIELD "DomainName" OF "SmartContextStore" AS character 
  FORMAT "x(20)"
  INITIAL ""
  LABEL "Domain Name"
  POSITION 4
  MAX-WIDTH 40
  ORDER 40

ADD FIELD "Created" OF "SmartContextStore" AS datetime-tz 
  FORMAT "99/99/9999 HH:MM:SS.SSS+HH:MM"
  INITIAL ?
  LABEL "Date Time Created"
  POSITION 5
  MAX-WIDTH 12
  ORDER 50

ADD FIELD "LastAccessed" OF "SmartContextStore" AS datetime-tz 
  FORMAT "99/99/9999 HH:MM:SS.SSS+HH:MM"
  INITIAL ?
  LABEL "Date Time Last Accessed"
  POSITION 6
  MAX-WIDTH 12
  ORDER 60

ADD FIELD "ContextDataset" OF "SmartContextStore" AS clob 
  FORMAT "x(8)"
  INITIAL ?
  POSITION 7
  LOB-AREA "LOB"
  LOB-BYTES 104857600
  LOB-SIZE 100M
  CLOB-CODEPAGE "UTF-8"
  CLOB-COLLATION "basic"
  CLOB-TYPE 2
  ORDER 70

ADD FIELD "SessionID" OF "SmartContextStore" AS character 
  FORMAT "x(40)"
  INITIAL ""
  LABEL "Session ID"
  POSITION 8
  MAX-WIDTH 80
  ORDER 20

ADD INDEX "ContextStoreGUID" ON "SmartContextStore" 
  AREA "Index"
  UNIQUE
  PRIMARY
  INDEX-FIELD "ContextStoreGUID" ASCENDING 

ADD INDEX "Created" ON "SmartContextStore" 
  AREA "Index"
  INDEX-FIELD "Created" ASCENDING 

ADD INDEX "DomainUser" ON "SmartContextStore" 
  AREA "Index"
  INDEX-FIELD "DomainName" ASCENDING 
  INDEX-FIELD "UserName" ASCENDING 

ADD INDEX "LastAccessed" ON "SmartContextStore" 
  AREA "Index"
  INDEX-FIELD "LastAccessed" ASCENDING 

ADD INDEX "SessionID" ON "SmartContextStore" 
  AREA "Index"
  UNIQUE
  INDEX-FIELD "SessionID" ASCENDING 

.
PSC
cpstream=ISO8859-1
.
0000002165