Home   Package List   Routine Alphabetical List   Global Alphabetical List   FileMan Files List   FileMan Sub-Files List   Package Component Lists   Package-Namespace Mapping  
Info |  Desc |  Pointer To FileMan Files |  Fields |  Found Entries
Print Page as PDF
Global: ^DD("KEY"

Package: VA FileMan

Global: ^DD("KEY"


Information

FileMan FileNo FileMan Filename Package
.31 KEY VA FileMan

Description

Pointer To FileMan Files, Total: 1

Package Total FileMan Files
VA FileMan 1 INDEX(#.11)[3]    

Fields, Total: 5

Field # Name Loc Type Details
.01 FILE 0;1 NUMBER
************************REQUIRED FIELD************************

  • INPUT TRANSFORM:  K:+X'=X!(X>999999999999)!(X<0)!(X?.E1"."8N.N) X
  • LAST EDITED:  JUN 11, 1998
  • HELP-PROMPT:  Type a Number between 0 and 999999999999, 7 Decimal Digits. Answer '??' for more help.
  • DESCRIPTION:  
    Answer should be the number of the file or subfile identified by this key. A file may have more than one key, but only one primary key.
  • CROSS-REFERENCE:  .31^B
    1)= S ^DD("KEY","B",$E(X,1,30),DA)=""
    2)= K ^DD("KEY","B",$E(X,1,30),DA)
    3)= Lets developers pick keys by their file number
    The B index on the .01 (File) of the Key file lets developers pick keys by the file whose records they uniquely distinguish.
  • RECORD INDEXES:  AP (#.3102), BB (#.3101)
.02 NAME 0;2 FREE TEXT
************************REQUIRED FIELD************************

  • INPUT TRANSFORM:  K:$L(X)>1!($L(X)<1)!'(X?1U) X
  • LAST EDITED:  JAN 22, 1996
  • HELP-PROMPT:  Answer must be 1 upper case letter. Answer '??' for more help.
  • DESCRIPTION:  
    Answer must be the name of this key. The name of a file's primary key should be A, with subsequent keys for the same file named B, C, and so on.
  • RECORD INDEXES:  BB (#.3101)
1 PRIORITY 0;3 SET
************************REQUIRED FIELD************************
  • 'P' FOR PRIMARY;
  • 'S' FOR SECONDARY;

  • LAST EDITED:  JUL 25, 1997
  • HELP-PROMPT:  Answer '??' for more help.
  • DESCRIPTION:  
    Answer 'PRIMARY' if this is the primary key of the file, the key that will usually be used for identifying entries. Otherwise, answer 'SECONDARY'.
  • RECORD INDEXES:  AP (#.3102)
2 FIELD 2;0 Multiple #.312 .312

  • LAST EDITED:  MAR 10, 1998
  • IDENTIFIED BY:  
    "WRITE": D EN^DDIOL(" "_$P(^(0),U,2),"","?0")
  • PRIMARY KEY:  A (#.31201)
    Uniqueness Index: BB (#.31201)
    File, Field: 1) FIELD (.312,.01) 2) FILE (.312,.02)
  • INDEXED BY:  FIELD & FILE (BB), SEQUENCE NUMBER & FIELD & FILE (S)
3 UNIQUENESS INDEX 0;4 POINTER TO INDEX FILE (#.11) INDEX(#.11)

  • INPUT TRANSFORM:  S DIC("S")="I 1 Q:'$D(DDS)!'$D(DIKKEY) I $P(^(0),U,9)=$P(^DD(""KEY"",DIKKEY,0),U)" D ^DIC K DIC S DIC=DIE,X=+Y K:Y<0 X
  • LAST EDITED:  JUN 11, 1998
  • HELP-PROMPT:  Answer '??' for more help.
  • DESCRIPTION:  
    Answer with the index that FileMan should use to ensure that new key values are unique. It must be a new-style index that resides in the Index file, and must cross-reference the key fields in proper sequence.
  • SCREEN:  S DIC("S")="I 1 Q:'$D(DDS)!'$D(DIKKEY) I $P(^(0),U,9)=$P(^DD(""KEY"",DIKKEY,0),U)"
  • EXPLANATION:  Root File of Index must equal File of Key.
  • FIELD INDEX:  AU (#.3103) REGULAR IR SORTING ONLY
    Short Descr: Lets FileMan determine whether an index is a uniqueness index for a key
    Set Logic: S ^DD("KEY","AU",X,DA)=""
    Kill Logic: K ^DD("KEY","AU",X,DA)
    Whole Kill: K ^DD("KEY","AU")
    X(1): UNIQUENESS INDEX (.31,3) (Subscr 1) (forwards)

Found Entries, Total: 148

FILE: .11    FILE: .114    FILE: .31    FILE: .312    FILE: 3.81    FILE: 20    FILE: 798    FILE: 798.1    
FILE: 798.13    FILE: 798.128    FILE: 798.2    FILE: 798.02    FILE: 798.11    FILE: 8927.1    FILE: 161.45    FILE: 798.118    
FILE: 798.129    FILE: 798.122    FILE: 801.04    FILE: 101.15    FILE: 810.2    FILE: 810.21    FILE: 798.26    FILE: 798.31    
FILE: 810.4    FILE: 810.41    FILE: 798.9    FILE: 799.1    FILE: 799.22    FILE: 799.22    FILE: 712.5    FILE: 392.31    
FILE: 799.31    FILE: 365.11    FILE: 810.7    FILE: 810.701    FILE: 810.8    FILE: 4.9999    FILE: 776.3    FILE: 776.5    
FILE: 810.801    FILE: 799.34    FILE: 799.51    FILE: 810.9    FILE: 601.95    FILE: 344.73    FILE: 811.5    FILE: 130.4    
FILE: 839.7    FILE: 757.5    FILE: 799.53    FILE: 811.7    FILE: 779.5    FILE: 142    FILE: 661.5    FILE: 8985.1    
FILE: 8985.11    FILE: 414.02    FILE: 414.03    FILE: 414.04    FILE: 779.2    FILE: 779.21    FILE: 779.3    FILE: 779.4    
FILE: 799.6    FILE: 799.61    FILE: 799.63    FILE: 799.64    FILE: 409.55    FILE: 18.05    FILE: 18.05    FILE: 420.14    
FILE: 62.47    FILE: 164.18    FILE: 2005.88    FILE: 18.02    FILE: 18.12    FILE: 18.13    FILE: 2006.8    FILE: 2006.8    
FILE: 702.01    FILE: 702.09    FILE: 704.001    FILE: 704.002    FILE: 704.006    FILE: 704.006    FILE: 704.007    FILE: 704.008    
FILE: 704.101    FILE: 704.103    FILE: 704.104    FILE: 704.105    FILE: 704.106    FILE: 704.107    FILE: 704.108    FILE: 704.109    
FILE: 704.111    FILE: 704.1111    FILE: 704.1112    FILE: 704.112    FILE: 704.1121    FILE: 704.1122    FILE: 704.1123    FILE: 704.113    
FILE: 704.1131    FILE: 704.115    FILE: 704.116    FILE: 704.1161    FILE: 704.117    FILE: 704.118    FILE: 704.119    FILE: 704.121    
FILE: 704.1211    FILE: 853.9    FILE: 802.4    FILE: 811.4    FILE: 8991.9    FILE: 364.8    FILE: 801.1    FILE: 2006.9192    
FILE: .85    FILE: .85    FILE: 58.63    FILE: 58.64    FILE: 129.2    FILE: 129.21    FILE: 129.22    FILE: 129.23    
FILE: 125    FILE: 125.11    FILE: 802.1    FILE: 802.2    FILE: 802.3    FILE: 8993    FILE: 8993.03    FILE: 801.46    
FILE: 801.48    FILE: 811.8    FILE: 9999999.27    FILE: 811.6    FILE: 101.45    FILE: 801.41    FILE: 811.2    FILE: 811.23    
FILE: 811.9    FILE: 9999999.09    FILE: 9999999.15    FILE: 9999999.64    
Info |  Desc |  Pointer To FileMan Files |  Fields |  Found Entries