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 | External References | Global Variables Directly Accessed | Local Variables | All

Print Page as PDF

Global: ^DMSQ("C"

Package: VA FileMan

Global: ^DMSQ("C"

Information

FileMan FileNo	FileMan Filename	Package
1.5217	SQLI_COLUMN	VA FileMan

Description

A set of formatting and physical structure specifications. Each column specification has a column type table element (SQLI_TABLE_ELEMENT) which contains the relational specifications, name and domain. The column specification contains those attributes required to locate the value in the global structure, and to project the value to the user.

Directly Accessed By Routines, Total: 9

Package	Total	Routines
VA FileMan	9	DMSQP3 ^DMSQ("C" DMSQF DMSQF1 DMSQF2 DMSQP5 DMSQT DMSQT1 YEAR

Pointed To By FileMan Files, Total: 3

Package	Total	FileMan Files
VA FileMan	3	SQLI_COLUMN(#1.5217)[8] SQLI_FOREIGN_KEY(#1.5219)[2] SQLI_PRIMARY_KEY(#1.5218)[1]

Pointer To FileMan Files, Total: 3

Package	Total	FileMan Files
VA FileMan	3	SQLI_COLUMN(#1.5217)[8] SQLI_TABLE_ELEMENT(#1.5216)[.01] SQLI_OUTPUT_FORMAT(#1.5214)[16]

Fields, Total: 17

Field #	Name	Loc	Type	Details
.01	C_TABLE_ELEMENT	0;1	POINTER TO SQLI_TABLE_ELEMENT FILE (#1.5216)	**********************REQUIRED FIELD********************** SQLI_TABLE_ELEMENT(#1.5216) LAST EDITED: `AUG 20, 1996` DESCRIPTION: `IEN of table element.` `WRITE AUTHORITY: ^` CROSS-REFERENCE: `1.5217^B` `1)= S ^DMSQ("C","B",$E(X,1,30),DA)=""` `2)= K ^DMSQ("C","B",$E(X,1,30),DA)`
1	C_FILE	0;5	NUMBER	INPUT TRANSFORM: `K:+X'=X!(X>999999999.999999)!(X<1)!(X?.E1"."7N.N) X` LAST EDITED: `SEP 26, 1996` HELP-PROMPT: `Type a Number between 1 and 999999999.999999, 6 Decimal Digits` DESCRIPTION: `FileMan file (or subfile) ID, if column was derived from ^DD.` `NULL if column is generated by SQLI.` `WRITE AUTHORITY: ^`
2	C_WIDTH	0;2	NUMBER	INPUT TRANSFORM: `K:+X'=X!(X>22)!(X<1)!(X?.E1"."1N.N) X` LAST EDITED: `AUG 20, 1996` HELP-PROMPT: `Type an integer between 1 and 999999999999999` DESCRIPTION: `Field width for display This field is estimated by SQLI from evidence in ^DD unless it's specified with J modifier.` `WRITE AUTHORITY: ^`
3	C_SCALE	0;3	NUMBER	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: `Number of decimal points to display on output (numeric only). If scale is specified as 0, SQLI projects column as integer.` `WRITE AUTHORITY: ^`
4	C_FIELD	0;6	NUMBER	INPUT TRANSFORM: `K:+X'=X!(X>9999999.9999999)!(X<.001)!(X?.E1"."8N.N) X` LAST EDITED: `MAR 11, 1997` HELP-PROMPT: `Type a Number between .001 and 9999999.9999999, 7 Decimal Digits` DESCRIPTION: `FileMan field ID from ^DD NULL unless column is derived directly from the data dictionary.` `WRITE AUTHORITY: ^` CROSS-REFERENCE: `1.5217^D^MUMPS` `1)= S ^DMSQ("C","D",$P(^DMSQ("C",DA,0),U,5),X,DA)=""` `2)= K ^DMSQ("C","D",$P(^DMSQ("C",DA,0),U,5),X,DA)` `Column by FileMan File number, by field number`
5	C_NOT_NULL	0;7	SET	'0' FOR Not required; '1' FOR Required; LAST EDITED: `SEP 26, 1996` DESCRIPTION: `When true (1) value is required, when false (0) not required.` `WRITE AUTHORITY: ^`
6	C_SECURE	0;8	SET	'0' FOR Not secure; '1' FOR Secure; LAST EDITED: `SEP 26, 1996` DESCRIPTION: `If true, there is a security screen, else not. When this flag is set, vendors should use DBS to retrieve data.` `WRITE AUTHORITY: ^`
7	C_VIRTUAL	0;9	SET	'0' FOR Base column; '1' FOR Calculated value column; LAST EDITED: `SEP 26, 1996` DESCRIPTION: `If true, the value is computed. Vendors should use DBS to get value.` `WRITE AUTHORITY: ^`
8	C_PARENT	0;10	POINTER TO SQLI_COLUMN FILE (#1.5217)	SQLI_COLUMN(#1.5217) LAST EDITED: `SEP 26, 1996` DESCRIPTION: `Column whose physical global structure precedes this column. Used to construct global root. Chain goes back to ^DIC.` `WRITE AUTHORITY: ^` CROSS-REFERENCE: `1.5217^C` `1)= S ^DMSQ("C","C",$E(X,1,30),DA)=""` `2)= K ^DMSQ("C","C",$E(X,1,30),DA)` `Column by parent column`
9	C_GLOBAL	1;E1,245	MUMPS	INPUT TRANSFORM: `K:$L(X)>245 X D:$D(X) ^DIM` LAST EDITED: `SEP 26, 1996` HELP-PROMPT: `M global fragment which precedes this element` DESCRIPTION: `M global fragment between this column and parent column. Contains node specifier for non-key columns. Key columns are constructed by SQLI and contain the multiple node specifier or ^DIC root.` `WRITE AUTHORITY: ^`
10	C_PIECE	0;11	NUMBER	INPUT TRANSFORM: `K:+X'=X!(X>99)!(X<1)!(X?.E1"."1N.N) X` LAST EDITED: `SEP 26, 1996` HELP-PROMPT: `Type a Number between 1 and 99, 0 Decimal Digits` DESCRIPTION: `The piece address of the column in a data string. If the piece address was of form E1,30, this value is null.` `WRITE AUTHORITY: ^`
11	C_EXTRACT_FROM	0;12	NUMBER	INPUT TRANSFORM: `K:+X'=X!(X>511)!(X<1)!(X?.E1"."1N.N) X` LAST EDITED: `SEP 26, 1996` HELP-PROMPT: `Type a Number between 1 and 511, 0 Decimal Digits` DESCRIPTION: `First character to be extracted with $EXTRACT NULL unless specified by form E1,30.` `WRITE AUTHORITY: ^`
12	C_EXTRACT_THRU	0;13	NUMBER	INPUT TRANSFORM: `K:+X'=X!(X>511)!(X<1)!(X?.E1"."1N.N) X` LAST EDITED: `SEP 26, 1996` HELP-PROMPT: `Type a Number between 1 and 511, 0 Decimal Digits` DESCRIPTION: `Last character to extract with $E` `WRITE AUTHORITY: ^`
13	C_COMPUTE_EXEC	2;E1,245	MUMPS	INPUT TRANSFORM: `K:$L(X)>245 X D:$D(X) ^DIM` LAST EDITED: `SEP 26, 1996` HELP-PROMPT: `M code to return value in {V}: machine generated` DESCRIPTION: `Computation execute uses $$GET1^DIQ to return code by default` EXECUTABLE HELP: `W ?5,"Enter code to return value in {V}"` `WRITE AUTHORITY: ^`
14	C_FM_EXEC	3;E1,245	MUMPS	INPUT TRANSFORM: `K:$L(X)>245 X D:$D(X) ^DIM` LAST EDITED: `SEP 26, 1996` HELP-PROMPT: `Don't enter manually: machine generated.` DESCRIPTION: `Standard $$GET1^DIQ code to return value of pointer, variable pointer and computed values, or when security flag is set` EXECUTABLE HELP: `W ?5,"Don't enter this. It should be auto-generated."` `WRITE AUTHORITY: ^`
15	C_POINTER	4;E1,245	MUMPS	INPUT TRANSFORM: `K:$L(X)>245 X D:$D(X) ^DIM` LAST EDITED: `SEP 06, 1996` HELP-PROMPT: `This is Standard MUMPS code.` DESCRIPTION: `Set translation string for SET, or global root for POINTER` `WRITE AUTHORITY: ^`
16	C_OUTPUT_FORMAT	0;4	POINTER TO SQLI_OUTPUT_FORMAT FILE (#1.5214)	SQLI_OUTPUT_FORMAT(#1.5214) LAST EDITED: `SEP 26, 1996` DESCRIPTION: `IEN of default output format in SQLI_OUTPUT_FORMAT for this column Always present for SET, POINTER and VARIABLE-POINTER data types` `WRITE AUTHORITY: ^` CROSS-REFERENCE: `1.5217^E` `1)= S ^DMSQ("C","E",$E(X,1,30),DA)=""` `2)= K ^DMSQ("C","E",$E(X,1,30),DA)` `Column by output format`

External References

Name	Field # of Occurrence
^DIM	9+1, 13+1, 14+1, 15+1

Global Variables Directly Accessed

Name	Line Occurrences (* Changed, ! Killed)
^DMSQ("C" - [#1.5217]	.01(XREF 1S), .01(XREF 1K), 4(XREF 1S), 4(XREF 1K), 8(XREF 1S), 8(XREF 1K), 16(XREF 1S), 16(XREF 1K)

Local Variables

Legend:

>>	Not killed explicitly
*	Changed
!	Killed
~	Newed

Name	Field # of Occurrence
>> DA	.01(XREF 1S), .01(XREF 1K), 4(XREF 1S), 4(XREF 1K), 8(XREF 1S), 8(XREF 1K), 16(XREF 1S), 16(XREF 1K)
U	4(XREF 1S), 4(XREF 1K)
X	.01(XREF 1S), .01(XREF 1K), 1+1!, 2+1!, 3+1!, 4+1!, 4(XREF 1S), 4(XREF 1K), 8(XREF 1S), 8(XREF 1K) , 9+1!, 10+1!, 11+1!, 12+1!, 13+1!, 14+1!, 15+1!, 16(XREF 1S), 16(XREF 1K)

Info | Desc | Directly Accessed By Routines | Pointed To By FileMan Files | Pointer To FileMan Files | Fields | External References | Global Variables Directly Accessed | Local Variables | All