Routine: BMXSQL7

Package	Total	Call Graph
M Transfer	4	$$FLDFILE^BMXSQL2 JOIN^BMXSQL4 SETMFL^BMXSQL5 $$CHKCR^BMXSQL7
VA Fileman	1	^%DT

Package	Total	Caller Graph
M Transfer	2	BMXSQL BMXSQL7

Entry Points

Name	Comments	DBIA/ICR reference
TMPLATE	;
ERROR
WHERE	;EP - WHERE-clause processing
OTM	;One-To-Many
CHKCR(BMXFNUM,BMXFLDNU,BMXRET)	;Returns cross reference to iterate on for related file

External References

Name	Field # of Occurrence
^%DT	WHERE+105, WHERE+126, WHERE+127
$$FLDFILE^BMXSQL2	WHERE+42
JOIN^BMXSQL4	WHERE+142
SETMFL^BMXSQL5	OTM+25
$$CHKCR^BMXSQL7	OTM+19

Global Variables Directly Accessed

Name	Line Occurrences (* Changed, ! Killed)
^DD(	CHKCR+4, CHKCR+7, CHKCR+8, CHKCR+9, WHERE+53, WHERE+64, OTM+10, OTM+12, OTM+13
^DIBT(	TMPLATE+7, TMPLATE+8, TMPLATE+10
^DIBT("B"	TMPLATE+5, TMPLATE+6
^DIC - [#1]	CHKCR+5, WHERE+14, WHERE+51

Label References

Name	Line Occurrences
ERROR	WHERE+120, WHERE+131, TMPLATE+5, TMPLATE+7, TMPLATE+9, TMPLATE+10
OTM	WHERE+91, WHERE+97
TMPLATE	WHERE+90

Local Variables

Legend:

>>	Not killed explicitly
*	Changed
!	Killed
~	Newed

Name	Field # of Occurrence
>> %DT	WHERE+105, WHERE+126, WHERE+127*
BMXA	OTM+1~, OTM+4*, OTM+8, OTM+9
BMXB	OTM+1~, OTM+5*, OTM+6, OTM+12, OTM+13
BMXDD	WHERE+59~, WHERE+60, WHERE+61, WHERE+62, WHERE+64, WHERE+65, WHERE+66
>> BMXERR	WHERE+28, WHERE+43, WHERE+120, WHERE+131, WHERE+141, TMPLATE+5, TMPLATE+7, TMPLATE+9, TMPLATE+10, OTM+8* , OTM+10, OTM+12, OTM+14, OTM+19
BMXEXEC	OTM+18~, OTM+19, OTM+25
>> BMXF(	WHERE+95, OTM+8, OTM+9
>> BMXFF	WHERE+26, WHERE+33, WHERE+45*
>> BMXFF(	WHERE+32, WHERE+47, WHERE+48, WHERE+49, WHERE+50, WHERE+51, WHERE+52, WHERE+53, WHERE+54, WHERE+57 , WHERE+60, WHERE+65, WHERE+66, WHERE+68, WHERE+70, WHERE+71, WHERE+72, WHERE+73, WHERE+77, WHERE+84* , WHERE+89, WHERE+99, WHERE+100, WHERE+101, WHERE+102, WHERE+103, WHERE+104, WHERE+106, WHERE+107, WHERE+109 , WHERE+110, WHERE+111, WHERE+114, WHERE+124, WHERE+125, WHERE+129, WHERE+131, TMPLATE+9, TMPLATE+11, TMPLATE+12* , OTM+22*
>> BMXFF("INDEX"	WHERE+138*
BMXFILE	WHERE+11~, WHERE+42*, WHERE+46, WHERE+47, WHERE+48, WHERE+49, WHERE+50, WHERE+51, WHERE+53
BMXFILN	WHERE+59~, WHERE+62, WHERE+63, WHERE+64
>> BMXFJ("JOIN"	WHERE+101, WHERE+102
BMXFLDN	WHERE+59~
BMXFLDNU	CHKCR~, CHKCR+4, CHKCR+7, CHKCR+8, CHKCR+9
BMXFNAM	OTM+1~, OTM+6*
BMXFNUM	CHKCR~, CHKCR+4, CHKCR+5, CHKCR+7, CHKCR+8, CHKCR+9
>> BMXFO(1	WHERE+14, WHERE+95, OTM+3
BMXGL	CHKCR+2~, CHKCR+5, CHKCR+12, CHKCR+17, CHKCR+19, CHKCR+25, WHERE+11~, WHERE+14, WHERE+16, WHERE+17 , WHERE+21
BMXHIT	CHKCR+1~, CHKCR+2~, CHKCR+6, CHKCR+7, CHKCR+29, CHKCR+30
BMXIEN	WHERE+13~, WHERE+38, WHERE+40, WHERE+41*, WHERE+52
BMXIND	WHERE+134~, WHERE+135, WHERE+136, WHERE+137*, WHERE+138
BMXINTNL	WHERE+12~, WHERE+36, WHERE+39, WHERE+54
BMXJN	WHERE+98~, WHERE+100*
BMXNOD	CHKCR+2~, CHKCR+4*, CHKCR+21
BMXOP	WHERE+11~, WHERE+81, WHERE+82, WHERE+83, WHERE+89, WHERE+113
BMXPFF	CHKCR+1~
BMXPFFN	CHKCR+1~
BMXREF	CHKCR+1~, CHKCR+2~, CHKCR+6, CHKCR+7, CHKCR+8, CHKCR+9
BMXRET	CHKCR~, CHKCR+6, CHKCR+29
BMXRNAM	CHKCR+2~, CHKCR+11*, CHKCR+12, CHKCR+17
BMXRNOD	CHKCR+1~, CHKCR+9*, CHKCR+10, CHKCR+11
BMXSBFLD	OTM+1~, OTM+13*, OTM+14, OTM+19
BMXSET	WHERE+69~, WHERE+73*, WHERE+74, WHERE+75
BMXSETP	WHERE+69~, WHERE+75*, WHERE+76, WHERE+77
BMXSUBFN	OTM+1~, OTM+9*, OTM+10, OTM+12, OTM+13, OTM+19, OTM+25
>> BMXTK(	WHERE+28, WHERE+30, WHERE+32, WHERE+34, WHERE+35, WHERE+39, WHERE+40, WHERE+41, WHERE+42, WHERE+81 , WHERE+84, WHERE+87, WHERE+91, WHERE+92, WHERE+94, WHERE+96, WHERE+117, WHERE+120, WHERE+122, WHERE+132 , WHERE+135
>> BMXTK("GROUP	BY" , WHERE+28
>> BMXTK("ORDER	BY" , WHERE+28
>> BMXTK("WHERE"	WHERE+25
BMXTMP	CHKCR+1~, CHKCR+12, CHKCR+13, CHKCR+14, CHKCR+15, CHKCR+17, CHKCR+18, CHKCR+19, CHKCR+20, CHKCR+25 , CHKCR+26, CHKCR+27, WHERE+11~, WHERE+17, WHERE+18, WHERE+19, WHERE+20, WHERE+87, WHERE+88, WHERE+89 , WHERE+91, WHERE+92, WHERE+94, WHERE+95, WHERE+96, WHERE+105, WHERE+108, WHERE+109, WHERE+110, WHERE+111 , WHERE+128, TMPLATE+2, TMPLATE+3, TMPLATE+5, TMPLATE+6, TMPLATE+12, OTM+2, OTM+4, OTM+5
BMXTMPI	CHKCR+1~, CHKCR+18*, CHKCR+20, CHKCR+25
BMXTMPL	CHKCR+2~, CHKCR+21, CHKCR+22, CHKCR+23, CHKCR+24, CHKCR+26, CHKCR+27
BMXTMPLT	WHERE+12~, WHERE+37, WHERE+40, WHERE+82, WHERE+90
BMXTMPN	CHKCR+2~, CHKCR+27*, CHKCR+28
BMXTMPP	CHKCR+1~, CHKCR+22, CHKCR+28, CHKCR+29
BMXTMPV	CHKCR+1~, CHKCR+15*, CHKCR+16, CHKCR+17, CHKCR+29
BMXTNOD	TMPLATE+1~, TMPLATE+8*, TMPLATE+9
BMXTNUM	TMPLATE+1~, TMPLATE+6*, TMPLATE+7, TMPLATE+8, TMPLATE+10
BMXTST	CHKCR+2~, CHKCR+13*, CHKCR+29
BMXTYP	WHERE+11~
BMXUPFN	OTM+1~, OTM+3*, OTM+25
BMXV	WHERE+11~
BMXV1	WHERE+11~, WHERE+117, WHERE+118, WHERE+126, WHERE+128, WHERE+129
BMXV2	WHERE+11~, WHERE+122, WHERE+123, WHERE+127, WHERE+128, WHERE+129
>> BMXX	WHERE+15*
>> BMXX(1	WHERE+16, WHERE+21
>> C	WHERE+26, WHERE+31, WHERE+32, WHERE+33, WHERE+44*, WHERE+45, WHERE+47, WHERE+48, WHERE+49, WHERE+50 , WHERE+51, WHERE+52, WHERE+53, WHERE+54, WHERE+57, WHERE+60, WHERE+65, WHERE+66, WHERE+68, WHERE+70 , WHERE+71, WHERE+72, WHERE+73, WHERE+77, WHERE+84, WHERE+89, WHERE+99, WHERE+100, WHERE+101, WHERE+102 , WHERE+103, WHERE+104, WHERE+106, WHERE+107, WHERE+109, WHERE+110, WHERE+111, WHERE+114, WHERE+124, WHERE+125 , WHERE+129, WHERE+131, TMPLATE+9, TMPLATE+11, TMPLATE+12, OTM+22
>> J	WHERE+74*, WHERE+75
Q	CHKCR+1~, CHKCR+6*, CHKCR+12, CHKCR+17
>> T	WHERE+25, WHERE+27, WHERE+28, WHERE+30, WHERE+32, WHERE+34, WHERE+35, WHERE+39, WHERE+40, WHERE+41 , WHERE+42, WHERE+80, WHERE+81, WHERE+84, WHERE+86, WHERE+87, WHERE+91, WHERE+92, WHERE+94, WHERE+96 , WHERE+116, WHERE+117, WHERE+119, WHERE+120, WHERE+121, WHERE+122, WHERE+132, WHERE+133*, WHERE+135
U	CHKCR+10, CHKCR+11, CHKCR+21, WHERE+47, WHERE+48, WHERE+49, WHERE+50, WHERE+51, WHERE+53, WHERE+57 , WHERE+61, WHERE+62, WHERE+65, WHERE+66, WHERE+68, WHERE+70, WHERE+72, WHERE+73, WHERE+84, WHERE+89 , WHERE+100, WHERE+101, WHERE+102, WHERE+103, WHERE+106, WHERE+111, WHERE+114, WHERE+124, WHERE+129, WHERE+131 , TMPLATE+9, TMPLATE+12
>> X	WHERE+105, WHERE+126, WHERE+127*
>> Y	WHERE+105, WHERE+126, WHERE+127

Customize PDF page

Package: M Transfer

Routine: BMXSQL7

Information

Source Information

Call Graph

Call Graph Total: 5

Caller Graph

Caller Graph Total: 2

Entry Points

External References

Global Variables Directly Accessed

Label References

Local Variables

Legend: