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 |