DDL example Schema DDL
118 U929-J-Z125-9-76
181 01 P-ORD-NO-ITEM PICTURE IS 99.
182 01 P-ORD-QTY TYPE IS DECIMAL 10.
183 *
184 *
185 *
186 SET NAME IS CST-ORD-PLACED
187 ORDER IS SORTED INDEXED BY DEFINED KEYS
188 DUPLICATES ARE NOT ALLOWED
189 OWNER IS CUSTOMER.
190 MEMBER IS CST-ORDERS OPTIONAL AUTOMATIC
191 ASCENDING KEY IS ORD-NO
192 SEARCH KEY IS ORD-YEAR, ORD-MONTH, ORD-DAY USING INDEX
193 NAME IS SEARCH-TAB-C-O-PLCD DUPLICATES ARE ALLOWED
194 SET OCCURRENCE SELECTION IS THRU LOCATION MODE OF OWNER.
195 *
196 *
197 SET NAME IS CST-O-CONTENTS
198 ORDER IS SORTED INDEXED BY DEFINED KEYS
199 DUPLICATES ARE NOT ALLOWED
200 OWNER IS CST-ORDERS.
201 MEMBER IS ORD-ITEM MANDATORY AUTOMATIC
202 ASCENDING KEY IS ORD-NO-ITEM
203 SET OCCURRENCE SELECTION IS THRU CURRENT OF SET.
204 *
205 *
206 SET NAME IS OUTSTANDING
207 ORDER IS LAST
208 OWNER IS CUSTOMER.
209 MEMBER IS ORD-ITEM OPTIONAL AUTOMATIC
210 SET OCCURRENCE SELECTION IS THRU LOCATION MODE OF OWNER.
211 *
212 *
213 SET NAME IS HIRE-PURCHASE
214 ORDER IS LAST
215 OWNER IS CUSTOMER.
216 MEMBER IS INSTALMENT MANDATORY AUTOMATIC
217 SET OCCURRENCE SELECTION IS THRU LOCATION MODE OF OWNER.
218 *
219 *
220 SET NAME IS OFFER
221 ORDER IS SORTED INDEXED BY DEFINED KEYS
222 DUPLICATES ARE ALLOWED
223 OWNER IS ART-TYPE.
224 MEMBER IS ART-DESCR MANDATORY AUTOMATIC
225 ASCENDING KEY IS ARTICLE-NAME
226 SET OCCURRENCE SELECTION IS THRU CURRENT OF SET.
227 *
228 *