Routine: BMXSQL

Package	Total	Call Graph
M Transfer	7	(PARSE,POST2)^BMXPRS (KW,SCREEN)^BMXSQL1 SETX^BMXSQL2 (BLDIT,PLEVEL,XRTST)^BMXSQL3 SELECT^BMXSQL5 WRITE^BMXSQL6 WHERE^BMXSQL7
IHS VA Utilities	1	^XBKVAR
Kernel	1	$$EC^%ZOSV

Package	Total	Caller Graph
M Transfer	4	BMXRPC6 BMXSQL2 BMXSQL5 BMXSQL6

Entry Points

Name	Comments	DBIA/ICR reference
SQL(BMXGBL,BMXSQL)	;EP
F1(BMXC,BMXNAM,BMXNUM)	;EP
TLIST1	;
FROM
ERROUT(BMXERR,I)	;EP
EXEC	;Execute enumerator and screen code to call Output routine
INTSQL(BMXGBL,BMXSQL,BMXCOL)
ERROR	;EP - Error processing
FLDNDX(BMXGBL,BMXFL,BMXFLD)
SQLD(BMXGBL,BMXSQL)	;EP Serenji Debug Entrypoint
TLIST(BMXGBL,BMXFROM,BMXTO)
INDEX(BMXFF,BMXRET,BMXXCNT)	;
WPLAN	;Write execution plan
ERRTRAP	;
COLTYPE	;EP - Append column types and widths to output global
END
ERRTACK(I)	;EP
NUMCHAR(BMXN)
SQLCOL(BMXGBL,BMXSQL)
OUT	;Set result in ^BMXTMP

External References

Name	Field # of Occurrence
$$EC^%ZOSV	ERRTRAP+4
PARSE^BMXPRS	INTSQL+29
POST2^BMXPRS	FROM+30
KW^BMXSQL1	INTSQL+31, FROM+31
SCREEN^BMXSQL1	FROM+43
SETX^BMXSQL2	FROM+44
BLDIT^BMXSQL3	INDEX+41, INDEX+77
PLEVEL^BMXSQL3	INDEX+24
XRTST^BMXSQL3	INDEX+37, INDEX+64
SELECT^BMXSQL5	FROM+28
WRITE^BMXSQL6	EXEC+13
WHERE^BMXSQL7	FROM+33
^XBKVAR	INTSQL+19

Used in RPC

RPC Name	Call Tags
BMX SQL	SQL
BMX TLIST	TLIST
BMX SQL COLINFO	SQLCOL

Global Variables Directly Accessed

Name	Line Occurrences (* Changed, ! Killed)
^%ZOSF("MAXSIZ"	INTSQL+21
^%ZOSF("TRAP"	INTSQL+7
^BMXTEMP($J	FLDNDX+4!, FLDNDX+20, FLDNDX+33, TLIST+7!, TLIST+26, TLIST+41, INTSQL+22!, WPLAN+5, WPLAN+9, WPLAN+13* , WPLAN+14, WPLAN+16, WPLAN+20, WPLAN+21, WPLAN+25, WPLAN+27, WPLAN+28, COLTYPE+11, ERRTACK+2, ERRTACK+3* , ERRTRAP+2!, ERRTRAP+3, ERRTRAP+6, ERRTRAP+7*
^BMXTMP($J	FLDNDX+4!, TLIST+7!, INTSQL+22!, OUT+2, OUT+3
^BMXTMPD($J	INTSQL+22!
^DD(	FLDNDX+15, FLDNDX+16, FLDNDX+25, FLDNDX+27, FLDNDX+31, TLIST+33
^DIC - [#1]	TLIST+33, TLIST1+2, TLIST1+3, FROM+12
^DIC("B"	FLDNDX+8, FLDNDX+9, TLIST+36, TLIST+38, TLIST+39, FROM+8, FROM+11
^VA(200 - [#200]	TLIST1+4, TLIST1+6

Label References

Name	Line Occurrences
$$NUMCHAR	FLDNDX+20, COLTYPE+11
COLTYPE	WPLAN+30
END	FROM+29, FROM+36
ERROR	FROM+1, FROM+8, FROM+14
ERROUT	FLDNDX+10, FLDNDX+17
ERRTACK	WPLAN+32, ERROUT+3
F1	FROM+13
INDEX	FROM+38
INTSQL	SQLCOL+1, SQL+1
TLIST1	TLIST+33, TLIST+39
WPLAN	EXEC+8

Local Variables

Legend:

>>	Not killed explicitly
*	Changed
!	Killed
~	Newed

Name	Field # of Occurrence
A	TLIST+4~, TLIST1+3*, TLIST1+7
>> BMX31	FLDNDX+3*
BMXC	EXEC+2~, F1~, F1+3, NUMCHAR+3~, NUMCHAR+4*, NUMCHAR+5
BMXCNT	TLIST+4~, TLIST+28*, TLIST+33, TLIST+38
BMXCOD	FLDNDX+24~, FLDNDX+31, FLDNDX+32, FLDNDX+33
BMXCOL	INTSQL~, EXEC+10
BMXE	INDEX+22~, INDEX+31, INDEX+32, INDEX+34, INDEX+58, INDEX+59, INDEX+60, INDEX+62, INDEX+67, INDEX+74* , INDEX+75, INDEX+76, INDEX+77
BMXERR	FLDNDX+25, INTSQL+17~, INTSQL+32, FROM+1, FROM+3, FROM+8, FROM+14*, FROM+29, FROM+36, ERRTACK+3 , INDEX+16, ERROUT~
BMXF	TLIST+4~, TLIST+9, INTSQL+15~, FROM+2, FROM+9*, FROM+13
BMXF(	FROM+14, F1+1*, F1+3
BMXF("FILE"	TLIST+10*
BMXFF	INTSQL+16~, FROM+38, INDEX~, INDEX+11, INDEX+16, INDEX+24, INDEX+37, INDEX+41, INDEX+64, INDEX+77
BMXFF(	INDEX+16, INDEX+17, INDEX+34, INDEX+35, INDEX+38, INDEX+62, INDEX+66, INDEX+71!, INDEX+76
BMXFG	INTSQL+16~, FROM+44
BMXFJ	INTSQL+17~
BMXFL	FLDNDX~, FLDNDX+6, FLDNDX+7, FLDNDX+8, FLDNDX+9*, FLDNDX+10, FLDNDX+15, FLDNDX+16, FLDNDX+25, FLDNDX+27 , FLDNDX+31
BMXFLD	FLDNDX~, FLDNDX+13, FLDNDX+14, FLDNDX+15, FLDNDX+16*, FLDNDX+17, FLDNDX+25, FLDNDX+27, FLDNDX+31, TLIST+4~ , INTSQL+15~
BMXFLD("FILE"	TLIST+11*, TLIST+13
BMXFLD("NUMBER"	TLIST+12*, TLIST+15
BMXFLDA	INTSQL+18~
BMXFLDN	TLIST+13, TLIST+14, TLIST+15, TLIST+16, INTSQL+15~
BMXFLDN(1	TLIST+14, TLIST+16
BMXFLDNM	INDEX+7~
BMXFLDO	TLIST+17*, INTSQL+17~
BMXFLDO(0	TLIST+18*
BMXFLDO(1	TLIST+20*
BMXFLDOX	INTSQL+17~
BMXFLDOX(1	TLIST+19, TLIST+21
BMXFNT	FROM+5~, FROM+10, FROM+11, FROM+12, FROM+13
BMXFNUM	INDEX+7~
BMXFNX	INTSQL+17~
BMXFNX(	F1+2*
BMXFNX(1	TLIST+22*
BMXFO	INTSQL+17~
BMXFO(	F1+3*
BMXFO(1	TLIST+23*
BMXFROM	TLIST~, TLIST+6, TLIST+29, TLIST+30, TLIST+31, TLIST+32, TLIST+34, TLIST+36
BMXGBL	FLDNDX~, FLDNDX+5, TLIST~, TLIST+8, SQLCOL~, SQLCOL+1, SQLD~, SQL~, SQL+1, INTSQL~ , INTSQL+23*
BMXGL	INDEX+7~
BMXHIT	INDEX+7~, INDEX+12, INDEX+16, INDEX+17, INDEX+19, INDEX+30, INDEX+38*, INDEX+39, INDEX+45
>> BMXI	FLDNDX+23, FLDNDX+25, FLDNDX+27, FLDNDX+31
BMXLEN	WPLAN+2~
BMXLEN(	WPLAN+5, COLTYPE+8, COLTYPE+9, COLTYPE+10*, COLTYPE+11
BMXLEN(2	WPLAN+14, WPLAN+21, WPLAN+28*
BMXM	INTSQL+15~, EXEC+9, EXEC+10, OUT+4
BMXMAX	TLIST+4~, TLIST+28*, TLIST+33, TLIST+38
BMXMFL	TLIST+4~, INTSQL+18~
BMXMFL(	FROM+12*
BMXN	NUMCHAR~, NUMCHAR+4
BMXNAM	FLDNDX+24~, FLDNDX+28*, FLDNDX+33, F1~, F1+1, F1+2, F1+3
BMXNOD	FLDNDX+24~, FLDNDX+27, FLDNDX+28, FLDNDX+29, INDEX+7~, INDEX+16
BMXNUM	F1~, F1+1, F1+2
BMXOP	INDEX+7~
BMXOR	INDEX+23~, INDEX+41, INDEX+43, INDEX+77, INDEX+79
BMXOUT	EXEC+2~, EXEC+3, OUT+1, OUT+3
BMXPFF	INDEX+26~, INDEX+36, INDEX+63*
BMXPFP	INTSQL+16~, INDEX+36, INDEX+37, INDEX+41, INDEX+63, INDEX+64, INDEX+77
BMXR1	INDEX+22~, INDEX+24
BMXR1(	INDEX+32, INDEX+34, INDEX+60, INDEX+62, INDEX+67*, INDEX+75, INDEX+76, INDEX+77
BMXR2	INDEX+22~, INDEX+24, INDEX+30, INDEX+31, INDEX+50, INDEX+57, INDEX+58, INDEX+73, INDEX+74
BMXR3	INDEX+22~, INDEX+27*, INDEX+37, INDEX+38, INDEX+64, INDEX+65
BMXRD	TLIST+4~, TLIST+25*, TLIST+26
BMXREF	INDEX+7~
BMXRET	INDEX~
BMXRET(	INDEX+43, INDEX+79
BMXRET(1	INDEX+17*
BMXRNAM	INDEX+7~, INDEX+22~, INDEX+37, INDEX+41, INDEX+64, INDEX+67
BMXRNOD	INDEX+8~
BMXSCR	INTSQL+16~, FROM+44, WPLAN+18
BMXSCR("C"	WPLAN+24, WPLAN+27
BMXSCRT	WPLAN+2~, WPLAN+18, WPLAN+19, WPLAN+20
>> BMXSET	TLIST+27*, TLIST1+1, TLIST1+6, TLIST1+7
BMXSQL	SQLCOL~, SQLCOL+1, SQLD~, SQL~, SQL+1, INTSQL~, INTSQL+8, INTSQL+10, INTSQL+12, INTSQL+25 , INTSQL+26, INTSQL+27, INTSQL+28*, INTSQL+29
BMXSQL(	INTSQL+9, INTSQL+10
BMXSTOP	INDEX+23~, INDEX+56, INDEX+57, INDEX+60, INDEX+65*, INDEX+70
BMXT	WPLAN+2~, WPLAN+4*, WPLAN+5
BMXTK	INTSQL+14!, INTSQL+15~, INTSQL+31, FROM+31
BMXTK(	FROM+3, FROM+4, FROM+6, FROM+7, FROM+8, FROM+10, FROM+11, FROM+13, FROM+14, FROM+16 , FROM+19, FROM+23*, FROM+24!
BMXTK("FROM"	FROM
BMXTK("GROUP	BY" , FROM+3, FROM+22
BMXTK("ORDER	BY" , FROM+3, FROM+21
BMXTK("SHOWPLAN"	EXEC+8
BMXTK("WHERE"	FROM+3, FROM+20
BMXTMP	INTSQL+15~, FROM+38, FROM+40, INDEX+8~
BMXTMPI	INDEX+8~
BMXTMPL	INDEX+8~
BMXTMPN	INDEX+8~
BMXTMPP	INDEX+8~
BMXTMPV	INDEX+8~
BMXTO	TLIST~, TLIST+29, TLIST+31, TLIST+32, TLIST+37
BMXTYP	FLDNDX+24~, FLDNDX+29, FLDNDX+30, FLDNDX+33, WPLAN+2~
BMXTYP(	WPLAN+5*, COLTYPE+11
BMXU	TLIST+4~, TLIST+24*, TLIST1+1
BMXV	INTSQL+15~, INDEX+8~
BMXX	INTSQL+16~, FROM+38, FROM+40*, FROM+44, WPLAN+8
BMXX(	EXEC+10, EXEC+11, WPLAN+8, WPLAN+11
BMXXCNT	INDEX~, INDEX+9, INDEX+17, INDEX+42, INDEX+43, INDEX+72, INDEX+78*, INDEX+79
BMXXMAX	INTSQL+15~, INTSQL+30*, EXEC+10
BMXXT	WPLAN+2~
BMXXT(	WPLAN+11, WPLAN+12, WPLAN+13
>> BMXZE	ERRTRAP+4, ERRTRAP+5, ERRTRAP+6
C	INTSQL+9~, INTSQL+10, COLTYPE+6~, COLTYPE+7, COLTYPE+8*, COLTYPE+9, COLTYPE+10, COLTYPE+11
D0	TLIST+4~, TLIST+28, TLIST+33, TLIST+39*, TLIST1+2, TLIST1+3, TLIST1+4, TLIST1+6, OUT+2, OUT+3
DUZ	TLIST1+4, TLIST1+6
DUZ(0	TLIST+24, TLIST1+7
F	TLIST+4~, TLIST+31, TLIST+33, TLIST+35, TLIST+36, TLIST+38, TLIST+39, INDEX+7~, INDEX+12, INDEX+16 , INDEX+17
I	FLDNDX+23, FLDNDX+26, FLDNDX+33, TLIST+4~, TLIST+28, TLIST+41, WPLAN+3, WPLAN+5, WPLAN+6, WPLAN+9 , WPLAN+10, WPLAN+13, WPLAN+14, WPLAN+15, WPLAN+16, WPLAN+17, WPLAN+20, WPLAN+21, WPLAN+22, WPLAN+25 , WPLAN+26, WPLAN+27, WPLAN+28, WPLAN+29, WPLAN+31*, WPLAN+32, ERRTACK~, ERRTACK+2, ERRTACK+3, ERROUT~ , ERROUT+3
J	TLIST1+7, EXEC+2~, EXEC+10, EXEC+11, WPLAN+2~, WPLAN+7, WPLAN+8, WPLAN+9, WPLAN+11, WPLAN+12 , WPLAN+13, WPLAN+23, WPLAN+24, WPLAN+25, WPLAN+27, INDEX+30, INDEX+31, INDEX+57, INDEX+58, INDEX+71* , INDEX+73*, INDEX+74
>> K	INDEX+34, INDEX+35, INDEX+36, INDEX+37, INDEX+38, INDEX+41, INDEX+62, INDEX+63, INDEX+64, INDEX+66 , INDEX+76*, INDEX+77
Q	INDEX+7~, INDEX+10*
T	TLIST+31, TLIST+33, TLIST+35, TLIST+37, TLIST+38, INTSQL+15~, FROM, FROM+1, FROM+3*, FROM+4 , FROM+6, FROM+7, FROM+8, FROM+10, FROM+11, FROM+13, FROM+14, FROM+16, FROM+18, FROM+23
U	FLDNDX+28, FLDNDX+29, FLDNDX+33, TLIST+5, TLIST1+6, INTSQL+20
V	FROM+17~, FROM+18*, FROM+19, FROM+20, FROM+21, FROM+22, FROM+23, FROM+24
>> X	INTSQL+7, INTSQL+21

Customize PDF page

Package: M Transfer

Routine: BMXSQL

Information

Source Information

Call Graph

Call Graph Total: 9

Caller Graph

Caller Graph Total: 4

Entry Points

External References

Used in RPC

Global Variables Directly Accessed

Label References

Local Variables

Legend: