Home   Package List   Routine Alphabetical List   Global Alphabetical List   FileMan Files List   FileMan Sub-Files List   Package Component Lists   Package-Namespace Mapping  
Info |  Source |  Call Graph |  Caller Graph |  Entry Points |  External References |  Used in RPC |  Global Variables Directly Accessed |  Label References |  Local Variables |  All
Print Page as PDF
Routine: BMXSQL

Package: M Transfer

Routine: BMXSQL


Information

BMXSQL ; IHS/OIT/HMW - BMX REMOTE PROCEDURE CALLS ;

Source Information

Source file <BMXSQL.m>

Call Graph

Call Graph Total: 9

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  

Caller Graph

Caller Graph Total: 4

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*
Info |  Source |  Call Graph |  Caller Graph |  Entry Points |  External References |  Used in RPC |  Global Variables Directly Accessed |  Label References |  Local Variables |  All