BMXSQL ; IHS/OIT/HMW - BMX REMOTE PROCEDURE CALLS ;
Source file <BMXSQL.m>
| Package | Total | Caller Graph | 
|---|---|---|
| M Transfer | 4 | BMXRPC6 BMXSQL2 BMXSQL5 BMXSQL6 | 
| 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 | 
| 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 | 
| RPC Name | Call Tags | 
|---|---|
| BMX SQL | SQL | 
| BMX TLIST | TLIST | 
| BMX SQL COLINFO | SQLCOL | 
| 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 | 
| 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 | 
| >> | 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* |