DMSQF2 ;SFISC/JHM-BUILD INDEX AND PARENT FOREIGN KEYS ;7/28/97 11:10
Source file <DMSQF2.m>
| action | A | extended action | Ea | event driver | Ed | subscriber | Su | protocol | O | limited protocol | LP | run routine | RR | broker | B | edit | E | server | Se | P | screenman | SM | inquire | I |
| Name | Comments | DBIA/ICR reference |
|---|---|---|
| PFK(TI) | ;BUILD FOREIGN KEYS FOR PARENT TABLES
|
|
| BFK(L) | ;BUILD A LEVEL L FOREIGN KEY FOR TABLE PRIMARY KEYS
|
|
| BFKI(L) | ;BUILD FOREIGN KEY COLUMN ELEMENT
|
|
| INIT | ;SET PRIMARY KEY VARIABLES FOR TABLE TI
|
|
| INDEX(TI) | ;BUILD ALL REGULAR INDICIES FOR TABLE TI
|
|
| FI | ||
| IN | ||
| IDX(F,FI,IN,TC,TE) | ;BUILD INDEX
|
|
| PKI(S,PEI,G,E,C,P) | ;BUILD COLUMN ELEMENT, COLUMN AND PRIMARY KEY ELEMENT
|
|
| T(F) |
| 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 | 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 |
