Global: ^DMSQ("C"

FileMan FileNo	FileMan Filename	Package
1.5217	SQLI_COLUMN	VA Fileman

Package	Total	Routines
VA Fileman	7	DMSQF DMSQF1 DMSQF2 DMSQP3 DMSQP5 DMSQT DMSQT1

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

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

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

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

Customize PDF page

Package: VA Fileman

Global: ^DMSQ("C"

Information

Description

Directly Accessed By Routines, Total: 7

Pointed To By FileMan Files, Total: 3

Pointer To FileMan Files, Total: 3

Fields, Total: 17