GLOBAL MAP DATA DICTIONARY #1.5218 -- SQLI_PRIMARY_KEY FILE                                                       3/24/25    PAGE 1
STORED IN ^DMSQ("P",  *** NO DATA STORED YET ***   SITE: WWW.BMIRWIN.COM   UCI: VISTA,VISTA                       (VERSION 22.2)   
-----------------------------------------------------------------------------------------------------------------------------------
A chosen set of columns which uniquely identify a table.  In the relational model (as in set theory) the columns of a primary key 
are not ordered. In SQLI they must be, in order to map to the quasi- hierarchical model of M globals.  
 
FileMan subfiles (multiples) have a primary key element for each parent plus one for the subfile. Each contains a pointer to its
primary key table element (SQLI_TABLE-ELEMENT), a sequence and a column in the local base 
 table (SQL_COLUMN).  


CROSS
REFERENCED BY: P_TBL_ELEMENT(B), P_SEQUENCE(C), P_COLUMN(D)



^DMSQ("P",D0,0)= (#.01) P_TBL_ELEMENT [1P:1.5216] ^ (#1) P_COLUMN [2P:1.5217] ^ (#2) P_SEQUENCE [3N] ^ (#3) P_START_AT [4F] ^ 
              ==>(#5) P_ROW_COUNT [5N] ^ (#7) P_KEY_FORMAT [6P:1.5213] ^ 
^DMSQ("P",D0,1)= (#4) P_END_IF [E1,245K] ^ 
^DMSQ("P",D0,2)= (#6) P_PRESELECT [E1,245K] ^ 


INPUT TEMPLATE(S):

PRINT TEMPLATE(S):

SORT TEMPLATE(S):

FORM(S)/BLOCK(S):