RE: Foreign key constraint problem

You asked for it <g>:

-- Generate SQL
-- Version: V5R4M0 060210
-- Generated on: 05/30/07 14:28:03
-- Relational Database:
-- Standards Option: DB2 UDB iSeries

-- DROP TABLE JEFF/DMITMMST ;

CREATE TABLE JEFF/DMITMMST (
RCDCD CHAR(2) CCSID 37 NOT NULL DEFAULT '' ,
CONSTRAINT RcdCd CHECK (RCDCD = 'MB') ,
ACREC CHAR(1) CCSID 37 NOT NULL DEFAULT '' ,
CONSTRAINT ActRec CHECK (ACREC IN ('A','D','S')) ,
ITNBR CHAR(6) CCSID 37 NOT NULL DEFAULT '' ,
RDATE NUMERIC(4, 0) NOT NULL DEFAULT 0 ,
ITMCL NUMERIC(2, 0) NOT NULL DEFAULT 0 ,
CWTCD CHAR(1) CCSID 37 NOT NULL DEFAULT '' ,
CONSTRAINT CwtCod CHECK (CWTCD IN ('C','N')) ,
VNDNR DECIMAL(5, 0) NOT NULL DEFAULT 0 ,
CONSTRAINT VndNbr CHECK (VNDNR > 0) ,
ITDSC CHAR(30) CCSID 37 NOT NULL DEFAULT '' ,
CONSTRAINT ItmDsc CHECK (ITDSC <> ' ') ,
PACKX DECIMAL(5, 0) NOT NULL DEFAULT 0 ,
CONSTRAINT Pack CHECK (PACKX > 0) ,
SIZEX CHAR(8) CCSID 37 NOT NULL DEFAULT '' ,
CONSTRAINT Size CHECK (SIZEX <> ' ') ,
WEGHT DECIMAL(5, 2) NOT NULL DEFAULT 0 ,
CUBEX DECIMAL(5, 3) NOT NULL DEFAULT 0 ,
QSUN1 CHAR(3) CCSID 37 NOT NULL DEFAULT '' ,
CONSTRAINT CasDsc CHECK (QSUN1 <> ' ') ,
QSUN2 CHAR(3) CCSID 37 NOT NULL DEFAULT '' ,
QCONF DECIMAL(3, 0) NOT NULL DEFAULT 0 ,
ITSB1 CHAR(6) CCSID 37 NOT NULL DEFAULT '' ,
ITSB2 CHAR(6) CCSID 37 NOT NULL DEFAULT '' ,
ITSB3 CHAR(6) CCSID 37 NOT NULL DEFAULT '' ,
SBCNF NUMERIC(2, 0) NOT NULL DEFAULT 0 ,
CASSB CHAR(1) CCSID 37 NOT NULL DEFAULT '' ,
CONSTRAINT CasSub CHECK (CASSB IN (' ','C')) ,
PALET CHAR(1) CCSID 37 NOT NULL DEFAULT '' ,
CONSTRAINT Pallet CHECK (PALET IN (' ','N','L','S')) ,
LAYRS DECIMAL(3, 0) NOT NULL DEFAULT 0 ,
PRLYR DECIMAL(3, 0) NOT NULL DEFAULT 0 ,
BCKCD CHAR(1) CCSID 37 NOT NULL DEFAULT '' ,
CONSTRAINT SpcOrdItm CHECK (BCKCD IN ('Y','N')) ,
PCECD CHAR(1) CCSID 37 NOT NULL DEFAULT '' ,
CONSTRAINT DolPct CHECK (PCECD IN ('P','D')) ,
TAXC1 CHAR(1) CCSID 37 NOT NULL DEFAULT '' ,
CONSTRAINT TaxCd1 CHECK (TAXC1 IN ('T','N')) ,
DSCNT CHAR(1) CCSID 37 NOT NULL DEFAULT '' ,
INSTK CHAR(1) CCSID 37 NOT NULL DEFAULT '' ,
CONSTRAINT InStock CHECK (INSTK IN ('Y','N')) ,
IUPCD DECIMAL(5, 0) NOT NULL DEFAULT 0 ,
PRTNS DECIMAL(5, 0) NOT NULL DEFAULT 0 ,
CONSTRAINT Portions CHECK (PRTNS > 0) ,
ITCLC NUMERIC(2, 0) NOT NULL DEFAULT 0 ,
CATCD1 CHAR(1) CCSID 37 NOT NULL DEFAULT '' ,
CATCD2 CHAR(1) CCSID 37 NOT NULL DEFAULT '' ,
QTYAL DECIMAL(5, 0) NOT NULL DEFAULT 0 ,
UNTAL DECIMAL(3, 0) NOT NULL DEFAULT 0 ,
POCT1 DECIMAL(7, 4) NOT NULL DEFAULT 0 ,
POCT2 DECIMAL(7, 4) NOT NULL DEFAULT 0 ,
PEMAL DECIMAL(7, 4) NOT NULL DEFAULT 0 ,
FRGHT DECIMAL(5, 2) NOT NULL DEFAULT 0 ,
AVGCS DECIMAL(5, 2) NOT NULL DEFAULT 0 ,
LSTCS DECIMAL(7, 4) NOT NULL DEFAULT 0 ,
MRKET DECIMAL(7, 4) NOT NULL DEFAULT 0 ,
CLP01 DECIMAL(5, 2) NOT NULL DEFAULT 0 ,
CLP02 DECIMAL(5, 2) NOT NULL DEFAULT 0 ,
CLP03 DECIMAL(5, 2) NOT NULL DEFAULT 0 ,
CLP04 DECIMAL(5, 2) NOT NULL DEFAULT 0 ,
CLP05 DECIMAL(5, 2) NOT NULL DEFAULT 0 ,
CLP06 DECIMAL(5, 2) NOT NULL DEFAULT 0 ,
CLP07 DECIMAL(5, 2) NOT NULL DEFAULT 0 ,
CLP08 DECIMAL(5, 2) NOT NULL DEFAULT 0 ,
CLP09 DECIMAL(5, 2) NOT NULL DEFAULT 0 ,
CLP10 DECIMAL(5, 2) NOT NULL DEFAULT 0 ,
CLP11 DECIMAL(5, 2) NOT NULL DEFAULT 0 ,
CLP12 DECIMAL(5, 2) NOT NULL DEFAULT 0 ,
CLP13 DECIMAL(5, 2) NOT NULL DEFAULT 0 ,
CLP14 DECIMAL(5, 2) NOT NULL DEFAULT 0 ,
CLP15 DECIMAL(5, 2) NOT NULL DEFAULT 0 ,
PRMAL DECIMAL(5, 2) NOT NULL DEFAULT 0 ,
OTHON DECIMAL(5, 0) NOT NULL DEFAULT 0 ,
OTHOF DECIMAL(5, 0) NOT NULL DEFAULT 0 ,
PROMO CHAR(1) CCSID 37 NOT NULL DEFAULT '' ,
SRPQY NUMERIC(2, 0) NOT NULL DEFAULT 0 ,
SRPAM DECIMAL(5, 2) NOT NULL DEFAULT 0 ,
QTYOH DECIMAL(5, 0) NOT NULL DEFAULT 0 ,
UNTOH DECIMAL(3, 0) NOT NULL DEFAULT 0 ,
WGTOH DECIMAL(7, 2) NOT NULL DEFAULT 0 ,
QTYOO DECIMAL(5, 0) NOT NULL DEFAULT 0 ,
POOUT DECIMAL(3, 0) NOT NULL DEFAULT 0 ,
XPDMFR DECIMAL(5, 0) NOT NULL DEFAULT 0 ,
RECWK DECIMAL(5, 0) NOT NULL DEFAULT 0 ,
RECMO DECIMAL(5, 0) NOT NULL DEFAULT 0 ,
RECYR DECIMAL(5, 0) NOT NULL DEFAULT 0 ,
RECWT DECIMAL(7, 2) NOT NULL DEFAULT 0 ,
UNTRS DECIMAL(3, 0) NOT NULL DEFAULT 0 ,
QTYRS DECIMAL(3, 0) NOT NULL DEFAULT 0 ,
UNTAD DECIMAL(3, 0) NOT NULL DEFAULT 0 ,
ADJMO DECIMAL(5, 0) NOT NULL DEFAULT 0 ,
ADJYR DECIMAL(5, 0) NOT NULL DEFAULT 0 ,
UNTSD DECIMAL(3, 0) NOT NULL DEFAULT 0 ,
SAQMO DECIMAL(5, 0) NOT NULL DEFAULT 0 ,
SAQYR DECIMAL(5, 0) NOT NULL DEFAULT 0 ,
CHNMV DECIMAL(3, 0) NOT NULL DEFAULT 0 ,
UNTLS DECIMAL(3, 0) NOT NULL DEFAULT 0 ,
LSTMO DECIMAL(5, 0) NOT NULL DEFAULT 0 ,
LSTYR DECIMAL(5, 0) NOT NULL DEFAULT 0 ,
NOSTK DECIMAL(3, 0) NOT NULL DEFAULT 0 ,
NOMOS NUMERIC(2, 0) NOT NULL DEFAULT 0 ,
NOWKS NUMERIC(2, 0) NOT NULL DEFAULT 0 ,
NFDCD NUMERIC(1, 0) NOT NULL DEFAULT 0 ,
CONSTRAINT NonFood CHECK (NFDCD >= 1 and NFDCD <= 3) ,
TMEBL DECIMAL(7, 0) NOT NULL DEFAULT 0 ,
CSTAM DECIMAL(7, 2) NOT NULL DEFAULT 0 ,
PTDDM DECIMAL(5, 0) NOT NULL DEFAULT 0 ,
PTDSH DECIMAL(5, 0) NOT NULL DEFAULT 0 ,
PPDMD DECIMAL(5, 0) NOT NULL DEFAULT 0 ,
PPSHP DECIMAL(5, 0) NOT NULL DEFAULT 0 ,
UNTDM DECIMAL(3, 0) NOT NULL DEFAULT 0 ,
UNTSH DECIMAL(3, 0) NOT NULL DEFAULT 0 ,
CHNTV DECIMAL(3, 0) NOT NULL DEFAULT 0 ,
UNITCD CHAR(1) CCSID 37 NOT NULL DEFAULT '' ,
CONSTRAINT UntCd CHECK (UNITCD >= '1' and UNITCD <= '4') ,
PRDYS DECIMAL(3, 0) NOT NULL DEFAULT 0 ,
UNTSY DECIMAL(3, 0) NOT NULL DEFAULT 0 ,
DTRCT NUMERIC(8, 0) NOT NULL DEFAULT 0 ,
DOFLT NUMERIC(8, 0) NOT NULL DEFAULT 0 ,
SALMO DECIMAL(7, 2) NOT NULL DEFAULT 0 ,
SALYR DECIMAL(7, 0) NOT NULL DEFAULT 0 ,
SACMO DECIMAL(7, 2) NOT NULL DEFAULT 0 ,
SACYR DECIMAL(7, 0) NOT NULL DEFAULT 0 ,
GMYTD DECIMAL(7, 0) NOT NULL DEFAULT 0 ,
PRCOD CHAR(1) CCSID 37 NOT NULL DEFAULT '' ,
CONSTRAINT DatPrdCd CHECK (PRCOD IN ('N','M','O')) ,
STQSL DECIMAL(3, 0) NOT NULL DEFAULT 0 ,
VUPCD DECIMAL(5, 0) NOT NULL DEFAULT 0 ,
ALPHA CHAR(1) CCSID 37 NOT NULL DEFAULT '' ,
WHSLC DECIMAL(5, 0) NOT NULL DEFAULT 0 ,
BEGOH DECIMAL(5, 0) NOT NULL DEFAULT 0 ,
BEGUN DECIMAL(3, 0) NOT NULL DEFAULT 0 ,
MKTAD DECIMAL(7, 4) NOT NULL DEFAULT 0 ,
MKTCD CHAR(1) CCSID 37 NOT NULL DEFAULT '' ,
PEMCD CHAR(1) CCSID 37 NOT NULL DEFAULT '' ,
SUBAL CHAR(1) CCSID 37 NOT NULL DEFAULT '' ,
DBKON DECIMAL(5, 0) NOT NULL DEFAULT 0 ,
DBKOF DECIMAL(5, 0) NOT NULL DEFAULT 0 ,
BIDCS DECIMAL(7, 4) NOT NULL DEFAULT 0 ,
CASEL CHAR(1) CCSID 37 NOT NULL DEFAULT '' ,
CMPIT DECIMAL(5, 0) NOT NULL DEFAULT 0 ,
PRNOT DECIMAL(3, 0) NOT NULL DEFAULT 0 ,
BIDIP DECIMAL(5, 4) NOT NULL DEFAULT 0 ,
BIDIC CHAR(1) CCSID 37 NOT NULL DEFAULT '' ,
BIDOP DECIMAL(5, 4) NOT NULL DEFAULT 0 ,
BIDOC CHAR(1) CCSID 37 NOT NULL DEFAULT '' ,
QRYA1 DECIMAL(5, 2) NOT NULL DEFAULT 0 ,
QRYA2 DECIMAL(5, 2) NOT NULL DEFAULT 0 ,
QRYSL DECIMAL(3, 0) NOT NULL DEFAULT 0 ,
MBGROP NUMERIC(4, 0) NOT NULL DEFAULT 0 ,
MBSBGP NUMERIC(4, 0) NOT NULL DEFAULT 0 ,
MBLINE NUMERIC(5, 0) NOT NULL DEFAULT 0 ,
XPDNBR CHAR(10) CCSID 37 NOT NULL DEFAULT '' ,
VNITM CHAR(10) CCSID 37 NOT NULL DEFAULT '' ,
ADUNQ NUMERIC(1, 0) NOT NULL DEFAULT 0 ,
BRAND CHAR(10) CCSID 37 NOT NULL DEFAULT '' ,
LKPRC CHAR(1) CCSID 37 NOT NULL DEFAULT '' ,
DFTWH NUMERIC(2, 0) NOT NULL DEFAULT 0 ,
PRIMARY KEY ( ITNBR ) ,
CONSTRAINT PrcBkSeqUK UNIQUE (MBGROP , MBSBGP , MBLINE) )
NOT VOLATILE
RCDFMT MBRECORD ;

LABEL ON TABLE JEFF/DMITMMST
IS 'Item Master' ;

LABEL ON COLUMN JEFF/DMITMMST
( RCDCD IS 'Record Code' ,
ACREC IS 'Active Record Code' ,
ITNBR IS 'Item Number' ,
RDATE IS 'Date Record Added' ,
CWTCD IS 'Catchweight Code' ,
VNDNR IS 'Vendor Number' ,
ITDSC IS 'Item Description' ,
PACKX IS 'Pack' ,
SIZEX IS 'Size' ,
WEGHT IS 'Weight Per Case' ,
CUBEX IS 'Cube' ,
PALET IS 'Pallet Size Code' ,
LAYRS IS 'Layers Per Pallet' ,
PRLYR IS 'Cases Per Layer' ,
BCKCD IS 'Back Order Code' ,
IUPCD IS 'Item UPC' ,
CATCD1 IS 'Catalog Code Byte 1' ,
CATCD2 IS 'Catalog Code Byte 2' ,
QTYAL IS 'Quantity Allocated' ,
POCT1 IS 'PO Cost #1' ,
POCT2 IS 'PO Cost #2' ,
PEMAL IS 'Permanent Allowance' ,
FRGHT IS 'Freight' ,
MRKET IS 'Market Cost' ,
CLP01 IS 'Unit Price' ,
CLP02 IS 'Half Case Price' ,
CLP03 IS 'A Bracket' ,
CLP04 IS 'B Bracket' ,
CLP05 IS 'C Bracket' ,
CLP06 IS 'D Bracket' ,
CLP07 IS 'E Bracket' ,
CLP08 IS 'M Bracket' ,
CLP09 IS 'Unused Bracket' ,
CLP10 IS 'S Bracket' ,
CLP11 IS 'R Bracket' ,
CLP12 IS 'L Bracket' ,
CLP13 IS 'F Bracket' ,
CLP14 IS 'J Bracket' ,
CLP15 IS 'N Bracket' ,
PRMAL IS 'Promo Allow' ,
SRPQY IS 'SRP Qty' ,
SRPAM IS 'SRP Amount' ,
QTYOH IS 'Quantity On Hand' ,
WGTOH IS 'Weight On Hand' ,
QTYOO IS 'Quantity On Order' ,
RECWT IS 'Wgt Received This Week' ,
QTYRS IS 'Quantity On Reserve' ,
CHNMV IS 'Chain 2-week Movement' ,
UNTSH IS 'Units Shipped' ,
CHNTV IS 'Temp 2-week Movement' ,
DTRCT IS 'Date Last Receipt' ,
DOFLT IS 'Date Last Shipment' ,
VUPCD IS 'Vendor UPC' ,
ALPHA IS 'Alpha Part of Item#' ,
WHSLC IS 'Warehouse Location' ,
MKTAD IS 'Market Adj' ,
MKTCD IS 'Market Adj Cd' ,
PEMCD IS 'Permanent Allow Code' ,
CASEL IS 'Case Lot Code' ,
MBGROP IS 'Price Book Group' ,
MBSBGP IS 'Price Book Subgroup' ,
MBLINE IS 'Price Book Line' ,
VNITM IS 'Vendor Item Number' ,
BRAND IS 'Brand' ,
LKPRC IS 'Lock Price Code' ,
DFTWH IS 'Dflt WH' ) ;

LABEL ON COLUMN JEFF/DMITMMST
( RCDCD TEXT IS 'Record code' ,
ACREC TEXT IS 'Active record code. A or D or S' ,
ITNBR TEXT IS 'Item number' ,
RDATE TEXT IS 'Date record added to file' ,
ITMCL TEXT IS 'Item class - meat work order' ,
CWTCD TEXT IS 'Catchweight code' ,
VNDNR TEXT IS 'Vendor number' ,
ITDSC TEXT IS 'Item description' ,
PACKX TEXT IS 'Pack' ,
SIZEX TEXT IS 'Size' ,
WEGHT TEXT IS 'Weight per case' ,
CUBEX TEXT IS 'Cube' ,
QSUN1 TEXT IS 'Case description' ,
QSUN2 TEXT IS 'Unit description' ,
QCONF TEXT IS 'Quantity conversion factor' ,
ITSB1 TEXT IS 'Sub item number 1' ,
ITSB2 TEXT IS 'Sub item number 2' ,
ITSB3 TEXT IS 'Sub item number 3' ,
SBCNF TEXT IS 'Sub conversion factor' ,
CASSB TEXT IS 'Case sub only code' ,
PALET TEXT IS 'Pallet size' ,
LAYRS TEXT IS 'Layers per pallet' ,
PRLYR TEXT IS 'Cases per layer' ,
BCKCD TEXT IS 'Backorder code' ,
PCECD TEXT IS 'Dollar/percent code' ,
TAXC1 TEXT IS 'Tax code' ,
DSCNT TEXT IS 'Another discount code' ,
INSTK TEXT IS 'Item always in stock' ,
IUPCD TEXT IS 'Item portion of UPC' ,
PRTNS TEXT IS 'Portions' ,
ITCLC TEXT IS 'Item class' ,
CATCD1 TEXT IS 'Catalog code byte 1' ,
CATCD2 TEXT IS 'Catalog code byte 2' ,
QTYAL TEXT IS 'Quantity Allocated' ,
UNTAL TEXT IS 'Units allocated' ,
POCT1 TEXT IS 'Purchase order cost #1' ,
POCT2 TEXT IS 'Purchase order cost #2' ,
PEMAL TEXT IS 'Permanent allowance' ,
FRGHT TEXT IS 'Freight' ,
AVGCS TEXT IS 'Average cost' ,
LSTCS TEXT IS 'Last cost' ,
MRKET TEXT IS 'Market cost' ,
CLP01 TEXT IS 'Unit price' ,
CLP02 TEXT IS 'Half case price' ,
CLP03 TEXT IS 'A bracket' ,
CLP04 TEXT IS 'B bracket' ,
CLP05 TEXT IS 'C bracket' ,
CLP06 TEXT IS 'D bracket' ,
CLP07 TEXT IS 'E bracket' ,
CLP08 TEXT IS 'M bracket' ,
CLP09 TEXT IS 'Unused price bracket' ,
CLP10 TEXT IS 'S bracket' ,
CLP11 TEXT IS 'R bracket' ,
CLP12 TEXT IS 'L bracket' ,
CLP13 TEXT IS 'F bracket' ,
CLP14 TEXT IS 'J bracket' ,
CLP15 TEXT IS 'N bracket' ,
PRMAL TEXT IS 'Promotion allowance' ,
OTHON TEXT IS 'Promo on date' ,
OTHOF TEXT IS 'Promotion off date' ,
PROMO TEXT IS 'Promotion code' ,
SRPQY TEXT IS 'Suggested retail price quantity' ,
SRPAM TEXT IS 'Suggested retail price amount' ,
QTYOH TEXT IS 'Quantity on hand' ,
UNTOH TEXT IS 'Units on hand' ,
WGTOH TEXT IS 'Weight on hand' ,
QTYOO TEXT IS 'Quantity on order' ,
POOUT TEXT IS 'Purchase orders outstanding' ,
XPDMFR TEXT IS 'XPD-Link Manufacturer' ,
RECWK TEXT IS 'Quantity received this week' ,
RECMO TEXT IS 'Quantity received this month' ,
RECYR TEXT IS 'Quantity received this year' ,
RECWT TEXT IS 'Weight received this week' ,
UNTRS TEXT IS 'Units on reserve' ,
QTYRS TEXT IS 'Quantity on reserve' ,
UNTAD TEXT IS 'Units adjusted' ,
ADJMO TEXT IS 'Quantity adjusted this period' ,
ADJYR TEXT IS 'Qty adjusted YTD' ,
UNTSD TEXT IS 'Units sold' ,
SAQMO TEXT IS 'Sales quantity this period' ,
SAQYR TEXT IS 'Sales quantity YTD' ,
CHNMV TEXT IS 'Chains 2-week movement' ,
UNTLS TEXT IS 'Units lost sales' ,
LSTMO TEXT IS 'Lost sales qty this period' ,
LSTYR TEXT IS 'Lost sales YTD' ,
NOSTK TEXT IS 'Number of stockouts YTD' ,
NOMOS TEXT IS 'Number of periods YTD (ie weeks)' ,
NOWKS TEXT IS 'Number weeks YTD' ,
NFDCD TEXT IS 'Non-food code' ,
TMEBL TEXT IS 'Total of week end balances' ,
CSTAM TEXT IS 'Cost amount of on hand qty' ,
PTDDM TEXT IS 'This period demand (inv mgt)' ,
PTDSH TEXT IS 'This period shipped (inv mgt)' ,
PPDMD TEXT IS 'Previous period demand (inv mgt)' ,
PPSHP TEXT IS 'Previous period ship (inv mgt)' ,
UNTDM TEXT IS 'Units demanded (inv mgt)' ,
UNTSH TEXT IS 'Units shipped (inv mgt)' ,
CHNTV TEXT IS 'Chains temporary 2-week movement' ,
UNITCD TEXT IS 'Unit code - portion pricing' ,
PRDYS TEXT IS 'Dated product days' ,
UNTSY TEXT IS 'Units sold YTD' ,
DTRCT TEXT IS 'Date of last receipt' ,
DOFLT TEXT IS 'Date of last shipment' ,
SALMO TEXT IS 'Sales dollars this period' ,
SALYR TEXT IS 'Sales dollars YTD' ,
SACMO TEXT IS 'Cost of goods sold this period' ,
SACYR TEXT IS 'Cost of goods sold YTD' ,
GMYTD TEXT IS 'Gross margin YTD' ,
PRCOD TEXT IS 'Dated product code' ,
STQSL TEXT IS 'Quantity sold from slot(usedfor restocking)' ,
VUPCD TEXT IS 'Vendor portion of UPC' ,
ALPHA TEXT IS 'Alpha portion of item number' ,
WHSLC TEXT IS 'Warehouse location (slot number)' ,
BEGOH TEXT IS 'Beginning on hand' ,
BEGUN TEXT IS 'Beginning units on hand' ,
MKTAD TEXT IS 'Market adjustment' ,
MKTCD TEXT IS 'Market adjustment code' ,
PEMCD TEXT IS 'Permanent allowance code' ,
SUBAL TEXT IS 'Sub always code' ,
DBKON TEXT IS '"D" bracket on date' ,
DBKOF TEXT IS '"D" bracket off date' ,
BIDCS TEXT IS 'Bid cost' ,
CASEL TEXT IS 'Case lot code' ,
CMPIT TEXT IS 'Computrition item number' ,
PRNOT TEXT IS 'Dated product notification days' ,
BIDIP TEXT IS 'In town bid percent' ,
BIDIC TEXT IS 'In town bid code P=percent D=dollars' ,
BIDOP TEXT IS 'Out of town bid percent' ,
BIDOC TEXT IS 'Out of town bid code P=percent D=dollars' ,
QRYA1 TEXT IS 'Query/36 amount #1' ,
QRYA2 TEXT IS 'Query/36 amount #2' ,
QRYSL TEXT IS 'Query/36 selection code' ,
MBGROP TEXT IS 'Group number' ,
MBSBGP TEXT IS 'Subgroup master file subgroup number' ,
MBLINE TEXT IS 'New catalog line number' ,
XPDNBR TEXT IS 'XPD-Link Number' ,
VNITM TEXT IS 'Vendor item number' ,
ADUNQ TEXT IS 'UPC Number System' ,
BRAND TEXT IS 'Brand' ,
LKPRC TEXT IS 'Lock price code' ,
DFTWH TEXT IS 'Default Warehouse' ) ;

The alter table:

ALTER TABLE JEFF/DMITMMST
CONSTRAINT CatalogFK FOREIGN KEY (CATCD1)
REFERENCES DMCATMST (CTCODE)
On Delete Restrict
On Update Restrict ;