Global: ^DMSQ("K"

Information

FileMan FileNo	FileMan Filename	Package
1.52101	SQLI_KEY_WORD	VA Fileman

SQL identifiers that may not be used for column and table names. SQL, ODBC and vendors all have lists of restricted words, which should be put in this table before SQLI table generation.

Package	Total	Routines
VA Fileman	2	DMSQD DMSQU

Field # Name Loc Type Details

Field #	Name	Loc	Type	Details
.01	KEY_WORD	0;1	FREE TEXT	**********************REQUIRED FIELD********************** INPUT TRANSFORM: `K:$L(X)>30!($L(X)<2)!'($TR(X,"_")?1U.UN) X` LAST EDITED: `MAR 11, 1997` HELP-PROMPT: `Answer must be 2-30 characters in length.` WRITE AUTHORITY: ^ CROSS-REFERENCE: `1.52101^B` 1)= S ^DMSQ("K","B",$E(X,1,30),DA)="" 2)= K ^DMSQ("K","B",$E(X,1,30),DA)

KEY_WORD

0;1

FREE TEXT

************************REQUIRED FIELD************************

INPUT TRANSFORM: K:$L(X)>30!($L(X)<2)!'($TR(X,"_")?1U.UN) X
LAST EDITED: MAR 11, 1997
HELP-PROMPT: Answer must be 2-30 characters in length.
```
WRITE AUTHORITY:  ^
```

CROSS-REFERENCE: 1.52101^B

1)= S ^DMSQ("K","B",$E(X,1,30),DA)=""

2)= K ^DMSQ("K","B",$E(X,1,30),DA)