DMSQF2 ;SFISC/JHM-BUILD INDEX AND PARENT FOREIGN KEYS ;7/28/97 11:10
Source file <DMSQF2.m>
| Name | Comments | DBIA/ICR reference | 
|---|---|---|
| IDX(F,FI,IN,TC,TE) | ;BUILD INDEX | |
| INDEX(TI) | ;BUILD ALL REGULAR INDICIES FOR TABLE TI | |
| PFK(TI) | ;BUILD FOREIGN KEYS FOR PARENT TABLES | |
| BFK(L) | ;BUILD A LEVEL L FOREIGN KEY FOR TABLE PRIMARY KEYS | |
| INIT | ;SET PRIMARY KEY VARIABLES FOR TABLE TI | |
| PKI(S,PEI,G,E,C,P) | ;BUILD COLUMN ELEMENT, COLUMN AND PRIMARY KEY ELEMENT | |
| IN | ||
| T(F) | ||
| FI | ||
| BFKI(L) | ;BUILD FOREIGN KEY COLUMN ELEMENT | 
| Name | Line Occurrences (* Changed, ! Killed) | 
|---|---|
| ^DD( | INIT+3, FI, IN, IDX+2, IDX+5 | 
| ^DMSQ("C" - [#1.5217] | BFKI+1, INIT+6, IDX+7, IDX+11, PKI+5 | 
| ^DMSQ("DM" - [#1.5212] | IDX+31 | 
| ^DMSQ("E" - [#1.5216] | BFK+4, BFK+5, BFK+7, INIT+4, INIT+7, IDX+11, IDX+40 | 
| ^DMSQ("F" - [#1.5219] | BFK+16 | 
| ^DMSQ("KF" - [#1.5213] | PKI+2 | 
| ^DMSQ("P" - [#1.5218] | BFKI+3, INIT+5, INIT+6, PKI+3, PKI+4 | 
| ^DMSQ("T" - [#1.5215] | BFK+2, BFK+3, INIT+2, IDX+19, T | 
| Name | Line Occurrences | 
|---|---|
| $$T | IDX+7 | 
| BFK | PFK+2 | 
| BFKI | BFK+18 | 
| FI | IN | 
| IDX | IN | 
| IN | IN | 
| INIT | PFK+2, INDEX+3 | 
| PKI | IDX+51 | 
| Name | Field # of Occurrence | 
|---|---|
| ^(1 | INIT+2 | 
| >> | Not killed explicitly | 
| * | Changed | 
| ! | Killed | 
| ~ | Newed | 
| Name | Field # of Occurrence | 
|---|---|
| C | INDEX+2~, IDX+11*, IDX+12, PKI~, PKI+1 | 
| CE | IDX+1~, IDX+11*, IDX+12, IDX+14 | 
| CEI | BFKI+1*, INDEX+2~, IDX+1~, IDX+11*, PKI+1~*, PKI+5*, PKI+8, PKI+14*, PKI+15, PKI+18 | 
| CI | BFKI+1*, BFKI+2, BFKI+9, INDEX+2~, IDX+1~, IDX+7*, IDX+8, IDX+11, PKI+1~*, PKI+4* , PKI+5, PKI+17, PKI+21*, PKI+22, PKI+26, PKI+31 | 
| CIEN | INDEX+2~ | 
| CN | INDEX+2~, IDX+14*, IDX+15, IDX+24 | 
| DIEN | INDEX+2~, IDX+31*, IDX+33, IDX+38*, IDX+44 | 
| >> DIFM | INDEX+1 | 
| DT | IDX+27 | 
| E | PKI~, PKI+6, PKI+10 | 
| ERR | BFK+1~, BFK+14, BFKI+11, INDEX+2~, IDX+30, IDX+39, IDX+49, PKI+15, PKI+22, PKI+30 | 
| F | BFK+14, BFKI+2, BFKI+4, BFKI+11, INIT+2*, FI, IN, IDX~, IDX+2, IDX+3 , IDX+5, IDX+6, IDX+7, IDX+8, IDX+30, IDX+39, IDX+49, PKI+15, PKI+22, PKI+30 , T~ | 
| FDA | BFK+1~, INDEX+2~ | 
| FDA( | BFK+8*, BFK+9*, BFK+10*, BFK+11*, BFK+12*, BFKI+7*, BFKI+8*, BFKI+9*, IDX+22*, IDX+23* , IDX+24*, IDX+25*, IDX+26*, IDX+27*, IDX+28*, IDX+34*, IDX+35*, IDX+36*, IDX+37*, IDX+43* , IDX+44*, IDX+45*, IDX+46*, IDX+47*, PKI+9*, PKI+10*, PKI+11*, PKI+12*, PKI+13*, PKI+18* , PKI+19*, PKI+20*, PKI+25*, PKI+26*, PKI+27*, PKI+28* | 
| >> FDI | BFK+5*, BFK+9 | 
| FF | BFK+1~, BFK+2* | 
| FI | BFKI+6*, BFKI+10*, BFKI+11, INDEX+2~, INDEX+3*, FI*, IN, IDX~, IDX+2, IDX+3 , IDX+5, IDX+6, IDX+7, IDX+8, IDX+30, IDX+39, IDX+49, PKI+15, PKI+22, PKI+30 | 
| FIEN | BFK+1~, BFK+13*, BFK+14, BFK+16, BFKI+7 | 
| >> FKI | BFK+15*, BFK+16*, BFK+17 | 
| FKN | BFK+1~, BFK+3*, BFK+7, BFK+8 | 
| FL | PFK+1~, BFK+2, INIT+2*, INIT+3*, INDEX+2~, IDX+9 | 
| FPE | BFK+1~, BFK+5* | 
| FPEI | BFK+1~, BFK+4*, BFK+5, BFKI+3 | 
| FT | BFK+1~, BFK+3* | 
| FTI | BFK+1~, BFK+2*, BFK+3, BFK+4 | 
| FTN | BFK+1~, BFK+3*, BFK+12 | 
| G | PKI~, PKI+20 | 
| GF | IDX+1~, IDX+17*, IDX+18 | 
| GL | PFK+1~, INIT+2*, INDEX+2~, IDX+17, IDX+18 | 
| I | PFK+2*, BFK+1~, BFK+16*, BFK+17, BFK+18*, BFKI+6, INDEX+2~, IDX+1~, IDX+2*, IDX+3 , IDX+4, IDX+18* | 
| IC | INDEX+2~, IDX+1~, IDX+10* | 
| IC( | IDX+12*, IDX+51 | 
| ICN | PKI+1~, PKI+6*, PKI+9, PKI+13 | 
| IE | INDEX+2~, IDX+1~, IDX+10* | 
| IE( | IDX+12*, IDX+50, IDX+51 | 
| IEI | INDEX+2~, IDX+19*, IDX+21 | 
| IEN | BFK+1~, BFK+7*, BFK+8, BFK+9, BFK+10, BFK+11, BFK+12, BFK+13, BFKI+6*, BFKI+7 , BFKI+8, BFKI+9, BFKI+10, INDEX+2~, IDX+21*, IDX+22, IDX+23, IDX+24, IDX+25, IDX+26 , IDX+27, IDX+28, IDX+29, IDX+33*, IDX+34, IDX+35, IDX+36, IDX+37, IDX+38, IDX+42* , IDX+43, IDX+44, IDX+45, IDX+46, IDX+47, IDX+48, PKI+8*, PKI+9, PKI+10, PKI+11 , PKI+12, PKI+13, PKI+14, PKI+17*, PKI+18, PKI+19, PKI+20, PKI+21, PKI+24*, PKI+25 , PKI+26, PKI+27, PKI+28, PKI+29 | 
| >> IENL | BFK+15*, BFK+17*, BFKI+6 | 
| IF | INDEX+2~, IDX+1~, IDX+4*, IDX+7, IDX+9 | 
| IGL | IDX+1~, IDX+17*, IDX+18*, IDX+28, IDX+51 | 
| IN | INDEX+2~, FI*, IN*, IDX~, IDX+2, IDX+5 | 
| INM | INDEX+2~, IDX+16*, IDX+19, IDX+22, IDX+34, IDX+36, IDX+43, IDX+47, PKI+13 | 
| INM1 | IDX+1~, IDX+15*, IDX+16 | 
| INM2 | IDX+1~, IDX+15*, IDX+16 | 
| ITI | IDX+1~, IDX+7* | 
| IX | INDEX+2~, IDX+1~, IDX+4*, IDX+15, IDX+17 | 
| K | INIT+1~, INIT+6*, INDEX+2~, IDX+50*, IDX+51 | 
| KC | INIT+1~, INIT+6*, INIT+7, INDEX+2~ | 
| KCI | INIT+1~, INIT+6*, INDEX+2~ | 
| KFI | PKI+1~*, PKI+2*, PKI+28 | 
| L | BFK~, BFK+2, BFK+14, BFK+16, BFK+18, BFKI~, BFKI+1, BFKI+2, BFKI+3, BFKI+4 , BFKI+11, INDEX+2~, IDX+1~, IDX+9*, IDX+12, IDX+17, IDX+18 | 
| P | INIT+1~, INIT+2*, INIT+3*, IDX+1~, IDX+50*, IDX+51, PKI~, PKI+19, PKI+31* | 
| PEI | PFK+1~, INIT+1~, INIT+4*, INIT+5, PKI~, PKI+3, PKI+25 | 
| PI | BFK+1~, BFKI+3*, BFKI+4, BFKI+8, INIT+1~, INIT+4*, INIT+5*, INIT+6, INDEX+2~, PKI+1~* , PKI+3*, PKI+4, PKI+24, PKI+29*, PKI+30 | 
| PIEN | INDEX+2~, IDX+40*, IDX+42, IDX+48*, IDX+51 | 
| S | PFK+1~, INIT+1~, INIT+2*, INIT+6*, INIT+7, IDX+1~, IDX+50*, IDX+51*, PKI~, PKI+3 , PKI+13, PKI+27 | 
| T | PFK+1~, INIT+2*, INDEX+2~, IDX+14 | 
| TC | PFK+1~, INDEX+2~, IN, IDX~, IDX+10 | 
| TC( | BFKI+1, INIT+7* | 
| TE | PFK+1~, INDEX+2~, IN, IDX~, IDX+10 | 
| TE( | INIT+7* | 
| TE("" | PFK+2 | 
| TI | PFK~, BFK+7, BFK+10, INIT+2, INIT+4, INDEX~, IDX+25 | 
| TIEN | INDEX+2~, IDX+29*, IDX+31, IDX+37, IDX+40, IDX+45, PKI+11 | 
| TN | INDEX+2~, IDX+1~, IDX+14*, IDX+24 | 
| TN1 | IDX+1~, IDX+14*, IDX+15 | 
| TN2 | IDX+1~, IDX+14*, IDX+16 | 
| TT | BFK+1~, BFK+7*, BFK+8, BFK+9, BFK+10, BFK+11, BFK+12, BFKI+6*, BFKI+7, BFKI+8 , BFKI+9, IDX+21*, IDX+22, IDX+23, IDX+24, IDX+25, IDX+26, IDX+27, IDX+28, IDX+33* , IDX+34, IDX+35, IDX+36, IDX+37, IDX+42*, IDX+43, IDX+44, IDX+45, IDX+46, IDX+47 , PKI+8*, PKI+9, PKI+10, PKI+11, PKI+12, PKI+13, PKI+17*, PKI+18, PKI+19, PKI+20 , PKI+24*, PKI+25, PKI+26, PKI+27, PKI+28 | 
| U | BFK+3, BFK+5, BFK+17, BFKI+1, BFKI+6, INIT+2, INIT+6, INIT+7, IDX+2, IDX+4 , IDX+11, IDX+14, PKI+1, PKI+4, PKI+5, PKI+6, PKI+10 | 
| W | PKI+1~*, PKI+2 |