Global: ^DMSQ("S"

FileMan FileNo	FileMan Filename	Package
1.521	SQLI_SCHEMA	VA Fileman

Directly Accessed By Routines, Total: 9

Package	Total	Routines
VA Fileman	9	DMSQE DMSQP DMSQP1 DMSQP2 DMSQP3 DMSQP5 DMSQP6 DMSQS DMSQT

Package	Total	FileMan Files
VA Fileman	1	SQLI_TABLE(#1.5215)[1]

Field # Name Loc Type Details

Field #	Name	Loc	Type	Details
.01	S_NAME	0;1	FREE TEXT	**********************REQUIRED FIELD********************** INPUT TRANSFORM: `K:$L(X)>30!($L(X)<1)!'($TR(X,"_")?1U.UN) X` LAST EDITED: `AUG 20, 1996` HELP-PROMPT: `SQL identifier start with upper case letter, only letters, numbers and _.` DESCRIPTION: In FileMan, application groups are assigned SQL schema names Names are valid SQL identifiers, and are unique by site WRITE AUTHORITY: ^ CROSS-REFERENCE: `1.521^B` 1)= S ^DMSQ("S","B",$E(X,1,30),DA)="" 2)= K ^DMSQ("S","B",$E(X,1,30),DA)
1	S_SECURITY	1;1	FREE TEXT	INPUT TRANSFORM: `K:$L(X)>12!($L(X)<4) X` LAST EDITED: `SEP 26, 1996` HELP-PROMPT: `Answer must be 4-12 characters in length.` DESCRIPTION: A routine to check security by application group. EXECUTABLE HELP: `W ?5,"Routine to check access to schema"` WRITE AUTHORITY: ^
2	S_DESCRIPTION	0;2	FREE TEXT	INPUT TRANSFORM: `K:$L(X)>60!($L(X)<3) X` LAST EDITED: `AUG 20, 1996` HELP-PROMPT: `Describe schema. Answer must be 3-60 characters in length.` DESCRIPTION: A short description of the schema WRITE AUTHORITY: ^

S_NAME

0;1

FREE TEXT

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

INPUT TRANSFORM: K:$L(X)>30!($L(X)<1)!'($TR(X,"_")?1U.UN) X
LAST EDITED: AUG 20, 1996
HELP-PROMPT: SQL identifier start with upper case letter, only letters, numbers and _.

DESCRIPTION:

In FileMan, application groups are assigned SQL schema names Names are valid SQL identifiers, and are unique by site

WRITE AUTHORITY:  ^

CROSS-REFERENCE: 1.521^B

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

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

S_SECURITY

1;1

FREE TEXT

DESCRIPTION:

A routine to check security by application group.

EXECUTABLE HELP: W ?5,"Routine to check access to schema"
```
WRITE AUTHORITY:  ^
```

S_DESCRIPTION

0;2

FREE TEXT

DESCRIPTION:

A short description of the schema

WRITE AUTHORITY:  ^