Home   Package List   Routine Alphabetical List   Global Alphabetical List   FileMan Files List   FileMan Sub-Files List   Package Component Lists   Package-Namespace Mapping  
Info |  Desc |  Directly Accessed By Routines |  Pointed To By FileMan Files |  Pointer To FileMan Files |  Fields |  Found Entries |  External References |  Global Variables Directly Accessed |  Local Variables |  All
Print Page as PDF
Global: ^DMSQ("P"

Package: VA FileMan

Global: ^DMSQ("P"


Information

FileMan FileNo FileMan Filename Package
1.5218 SQLI_PRIMARY_KEY VA FileMan

Description

Directly Accessed By Routines, Total: 7

Package Total Routines
VA FileMan 7 DMSQF1    DMSQF2    DMSQP5    DMSQS    DMSQT    ^DMSQ("P"    DMSQU    

Pointed To By FileMan Files, Total: 1

Package Total FileMan Files
VA FileMan 1 SQLI_FOREIGN_KEY(#1.5219)[1]    

Pointer To FileMan Files, Total: 3

Package Total FileMan Files
VA FileMan 3 SQLI_COLUMN(#1.5217)[1]    SQLI_TABLE_ELEMENT(#1.5216)[.01]    SQLI_KEY_FORMAT(#1.5213)[7]    

Fields, Total: 8

Field # Name Loc Type Details
.01 P_TBL_ELEMENT 0;1 POINTER TO SQLI_TABLE_ELEMENT FILE (#1.5216)
************************REQUIRED FIELD************************
SQLI_TABLE_ELEMENT(#1.5216)

  • LAST EDITED:  AUG 23, 1996
  • DESCRIPTION:  
    IEN of table element in SQLI_TABLE_ELEMENT
    WRITE AUTHORITY:  ^
  • CROSS-REFERENCE:  1.5218^B
    1)= S ^DMSQ("P","B",$E(X,1,30),DA)=""
    2)= K ^DMSQ("P","B",$E(X,1,30),DA)
1 P_COLUMN 0;2 POINTER TO SQLI_COLUMN FILE (#1.5217)
************************REQUIRED FIELD************************
SQLI_COLUMN(#1.5217)

  • LAST EDITED:  AUG 30, 1996
  • DESCRIPTION:  
    IEN of column in SQLI_COLUMN corresponding to this primary key
    WRITE AUTHORITY:  ^
  • CROSS-REFERENCE:  1.5218^D
    1)= S ^DMSQ("P","D",$E(X,1,30),DA)=""
    2)= K ^DMSQ("P","D",$E(X,1,30),DA)
2 P_SEQUENCE 0;3 NUMBER
************************REQUIRED FIELD************************

  • INPUT TRANSFORM:  K:+X'=X!(X>9)!(X<1)!(X?.E1"."1N.N) X
  • LAST EDITED:  SEP 26, 1996
  • HELP-PROMPT:  Type a Number between 1 and 9, 0 Decimal Digits
  • DESCRIPTION:  
    Sequence number of primary key
  • TECHNICAL DESCR:  
    Sequence is automatically generated and must not be changed.
    WRITE AUTHORITY:  ^
  • CROSS-REFERENCE:  1.5218^C^MUMPS
    1)= S ^DMSQ("P","C",$P(^DMSQ("P",DA,0),U),X,DA)=""
    2)= K ^DMSQ("P","C",$P(^DMSQ("P",DA,0),U),X,DA)
    Primary key by table by sequence
3 P_START_AT 0;4 FREE TEXT

  • INPUT TRANSFORM:  K:$L(X)>30!($L(X)<1) X
  • LAST EDITED:  AUG 20, 1996
  • HELP-PROMPT:  Answer must be 1-30 characters in length.
  • DESCRIPTION:  
    Initial value of key before a $ORDER loop
    WRITE AUTHORITY:  ^
4 P_END_IF 1;E1,245 MUMPS

  • INPUT TRANSFORM:  K:$L(X)>245 X D:$D(X) ^DIM
  • LAST EDITED:  SEP 26, 1996
  • HELP-PROMPT:  This is a Standard M expression returning False at end
  • DESCRIPTION:  
    M expression in key value, {K}, which, if false, ends the $ORDER loop
    WRITE AUTHORITY:  ^
5 P_ROW_COUNT 0;5 NUMBER

  • INPUT TRANSFORM:  K:+X'=X!(X>9999999)!(X<1)!(X?.E1"."3N.N) X
  • LAST EDITED:  SEP 26, 1996
  • HELP-PROMPT:  Type a Number between 1 and 9999999, 2 Decimal Digits
  • DESCRIPTION:  
    Estimated number of rows per record set at this level
    WRITE AUTHORITY:  ^
6 P_PRESELECT 2;E1,245 MUMPS

  • INPUT TRANSFORM:  K:$L(X)>245 X D:$D(X) ^DIM
  • LAST EDITED:  SEP 26, 1996
  • HELP-PROMPT:  This is Standard MUMPS code.
  • DESCRIPTION:  
    Code to be executed before selecting this key, before optimization.
    WRITE AUTHORITY:  ^
7 P_KEY_FORMAT 0;6 POINTER TO SQLI_KEY_FORMAT FILE (#1.5213) SQLI_KEY_FORMAT(#1.5213)

  • LAST EDITED:  OCT 14, 1996
  • DESCRIPTION:  Key formats map internal storage values to their value when used as keys. In general, information is lost in the process; they can't be converted back. This means data must be converted to key format before it can be
    compared to such a key.
    WRITE AUTHORITY:  ^

External References

Name Field # of Occurrence
^DIM 4+1, 6+1

Global Variables Directly Accessed

Name Line Occurrences  (* Changed,  ! Killed)
^DMSQ("P" - [#1.5218] .01(XREF 1S), .01(XREF 1K), 1(XREF 1S), 1(XREF 1K), 2(XREF 1S), 2(XREF 1K)

Local Variables

Legend:

>> Not killed explicitly
* Changed
! Killed
~ Newed

Name Field # of Occurrence
>> DA .01(XREF 1S), .01(XREF 1K), 1(XREF 1S), 1(XREF 1K), 2(XREF 1S), 2(XREF 1K)
U 2(XREF 1S), 2(XREF 1K)
X .01(XREF 1S), .01(XREF 1K), 1(XREF 1S), 1(XREF 1K), 2+1!, 2(XREF 1S), 2(XREF 1K), 3+1!, 4+1!, 5+1!
, 6+1!
Info |  Desc |  Directly Accessed By Routines |  Pointed To By FileMan Files |  Pointer To FileMan Files |  Fields |  Found Entries |  External References |  Global Variables Directly Accessed |  Local Variables |  All