DDL example Schema DDL
120 U929-J-Z125-9-76
277 ASCENDING KEY IS SUPPL-NAME, SUPPL-NO.
278 *
279 *
280 SET NAME IS ARTICLES-AVAILABLE
281 ORDER IS SORTED INDEXED BY DEFINED KEYS
282 DUPLICATES ARE ALLOWED
283 OWNER IS SUPPLIER.
284 MEMBER IS ARTICLE MANDATORY AUTOMATIC
285 ASCENDING KEY IS ARTICLE-NAME
286 SEARCH KEY IS NOT-AVAIL-CODE USING INDEX
287 NAME IS SEARCH-TAB-ART-AVAIL DUPLICATES ARE ALLOWED
288 SET OCCURRENCE SELECTION IS THRU CURRENT OF SET.
289 *
290 *
291 SET NAME IS ORDERED-ARTICLES
292 ORDER IS LAST
293 OWNER IS ARTICLE.
294 MEMBER IS ORD-ITEM MANDATORY AUTOMATIC
295 SET OCCURRENCE SELECTION IS THRU LOCATION MODE OF OWNER.
296 *
297 *
298 SET NAME IS REORDERED-ARTICLES
299 ORDER IS LAST
300 OWNER IS ARTICLE.
301 MEMBER IS P-ORD-ITEM MANDATORY AUTOMATIC
302 SET OCCURRENCE SELECTION IS THRU LOCATION MODE OF OWNER.
303 *
304 *
305 SET NAME IS P-ORD-PLACED
306 ORDER IS LAST
307 OWNER IS SUPPLIER.
308 MEMBER IS PURCHASE-ORDER MANDATORY AUTOMATIC
309 SET OCCURRENCE SELECTION IS THRU CURRENT OF SET.
310 *
311 *
312 SET NAME IS P-ORD-RECEIVED
313 ORDER IS FIRST
314 OWNER IS SUPPLIER.
315 MEMBER IS PURCHASE-ORDER MANDATORY MANUAL
316 SET OCCURRENCE SELECTION IS THRU CURRENT OF SET.
317 *
318 *
319 SET NAME IS P-ORD-CONTENTS
320 ORDER IS NEXT
321 OWNER IS PURCHASE-ORDER.
322 MEMBER IS P-ORD-ITEM MANDATORY AUTOMATIC
323 SET OCCURRENCE SELECTION IS THRU CURRENT OF SET.
324 *