308 lines
11 KiB
Plaintext
308 lines
11 KiB
Plaintext
English French Notes Complete/Exclude
|
|
of table
|
|
INDEX PRIMARY KEY: COLUMN ELEMENT INSERT FAILED
|
|
INDEX PRIMARY KEY: COLUMN INSERT FAILED
|
|
INDEX PRIMARY KEY: TABLE ELEMENT INSERT FAILED
|
|
FOREIGN KEY: NO POINTED-TO FILE IN SPECIFIER
|
|
FOREIGN KEY: NO TABLE FOR POINTED-TO FILE
|
|
FOREIGN KEY: NO PRIMARY KEY TABLE ELEMENT
|
|
FOREIGN KEY: NO ASSOCIATED PRIMARY KEY
|
|
Foreign key to
|
|
FOREIGN KEY: TABLE ELEMENT INSERT FAILED
|
|
FOREIGN KEY: COLUMN ELEMENT INSERT FAILED
|
|
Foreign key to ancestor
|
|
FOREIGN KEY: ANCESTOR FOREIGN KEY INSERT FAILED
|
|
FOREIGN KEY: NO POINTED-TO COLUMN AT LEVEL
|
|
FOREIGN KEY: NO ANCESTOR PRIMARY KEY
|
|
FOREIGN KEY: ANCESTOR FOREIGN KEY COLUMN INSERT FAILED
|
|
INDEX: MISSING DATA DICTIONARY DATA
|
|
INDEX: IRREGULAR FORMAT
|
|
INDEX: NO ASSOCIATED COLUMN RECORD
|
|
Index of
|
|
INDEX: TABLE INSERT FAILED
|
|
INDEX: TABLE DOMAIN INSERT FAILED
|
|
Primary key header for
|
|
INDEX: PRIMARY KEY ELEMENT INSERT FAILED
|
|
Index Primary Key #
|
|
INDEX: COLUMN ELEMENT INSERT FAILED
|
|
INDEX: COLUMN INSERT FAILED
|
|
INDEX: PRIMARY KEY INSERT FAILED
|
|
NO POINTERS
|
|
You need 'Read' access to one SQLI file to run this report.
|
|
It is file 1.5212.
|
|
Contact your system manager to be granted single file access.
|
|
TABLES POINTING TO
|
|
FROM TABLE:
|
|
VIA FOREIGN KEY:
|
|
TABLES POINTED-TO BY
|
|
TO TABLE:
|
|
VA FOREIGN KEY:
|
|
DMSQ(
|
|
SQLI TABLE COUNT (EXCLUDING INDEX-TYPE)
|
|
REGULAR TABLES
|
|
SQLI COLUMN COUNT FOR ALL TABLES
|
|
SQLI INDEX COUNT (INDEX-TYPE TABLES)
|
|
SQLI TABLE ELEMENT TYPE TOTALS
|
|
TYPE=
|
|
SQLI COLUMN TOTALS BY TABLE
|
|
TABLE:
|
|
SQLI TABLES SORTED BY TOTAL COLUMNS
|
|
COLUMN COUNT:
|
|
SQLI COLUMN COUNT FOR REGULAR TABLES (EXCLUDING INDEXES)
|
|
SQLI COLUMN COUNT, REGULAR TABLES, EXCLUDING TABLE_IDS
|
|
SQLI COLUMN COUNT BY DOMAIN (REGULAR TABLES, EXCLUDING TABLE_IDS)
|
|
DOMAIN=
|
|
You need 'Read' access to four SQLI files to run this report.
|
|
They are files 1.5211, 1.5212, 1.5214, and 1.5216.
|
|
Starting File Number
|
|
Enter the number of the file, e.g. 200 or 1.5215
|
|
SQLI table not found.
|
|
Ending File Number
|
|
Optionally enter a larger number for a range, e.g. 1.5217
|
|
There isn't a table for the file number you've entered.
|
|
(The highest possible number is
|
|
Enter a LARGER number to get a range.
|
|
The highest possible number here is
|
|
SQLI PROJECTION OF FIELDS AS COLUMNS
|
|
INTERNAL(#4);C1;S;X,.01;C15;X,7;C15;X,5;C42;X,
|
|
OF_DATA_TYPE:
|
|
OF_EXT_EXPR:
|
|
DM_DATA_TYPE:
|
|
DM_WIDTH/DM_SCALE:
|
|
SQLI TABLE NAME:
|
|
FILE NUMBER:
|
|
INTERNAL(#6);
|
|
FILE#
|
|
FILEMAN FILE NAME
|
|
SQLI TABLE NAME
|
|
SQLI TABLES BY FILE NUMBER
|
|
(1) SELF Tables with Self-referential Pointers
|
|
(2) UP Tables with Upward Links
|
|
(3) DOWN Tables Linked from Below
|
|
(4) OUT Tables Pointing Outward
|
|
(5) IN Tables with Incoming Pointers
|
|
(9) QUIT Exit this Menu
|
|
Select a report:
|
|
This can take 1-2 minutes. Continue
|
|
These reports show counts. Or would you prefer details
|
|
WORD_PROCESSING
|
|
Please wait...
|
|
SQLI TABLE POINTER COUNTS
|
|
FILE/SUBFILE:
|
|
WORD-PROCESSING TABLE?
|
|
SELF-REFERENTIAL POINTERS:
|
|
POINTERS DOWNWARD TO THIS SUBFILE:
|
|
POINTERS UPWARD FROM DEEPER SUBFILES:
|
|
POINTERS OUTWARD TO OTHER FILES:
|
|
POINTERS INWARD FROM OTHER FILES:
|
|
SQLI WORD-PROCESSING TABLE
|
|
- SUBSET OF SUBFILES
|
|
WORD-PROCESSING?
|
|
SQLI POINTING TABLE
|
|
- SELF-REFERENTIAL POINTERS
|
|
TIMES POINTED-TO BY ITSELF:
|
|
- UPWARD FROM THIS SUBFILE LEVEL
|
|
TIMES POINTING UPWARD (SUBFILE LEVELS):
|
|
SQLI POINTED-TO TABLE
|
|
- UP FROM ONE OR MORE SUBFILE LEVELS
|
|
TIMES POINTED-TO FROM BELOW:
|
|
(EXCLUDES SUBFILE POINTERS)
|
|
TIMES POINTING (GOING OUTWARD):
|
|
TIMES POINTED-TO (COMING INWARD):
|
|
WARNING: REPORT JUST WRITES TO THE SCREEN WITHOUT PAGE BREAKS
|
|
(INTENDED FOR SCREEN CAPTURES) SO PICK ONE TABLE
|
|
OR A SMALL RANGE WHEN TESTING
|
|
LABEL;TYPE
|
|
TBL:
|
|
COL:
|
|
SUBFILE OF:
|
|
This can take 5-10 minutes. Continue
|
|
Maximum pointing references
|
|
This cutoff is used as an upper limit on pointer links. Tables with
|
|
more links than this upper limit are displayed as the set of shared tables.
|
|
Others with common pointer links are then grouped together. The resulting
|
|
subsets could be used in SQL Grant statements.
|
|
Try using cutoffs between 3 and 10, comparing results.
|
|
Select a Table of Special Interest (Optional):
|
|
LISTING OF SHARED TABLES
|
|
SHARED TABLES =
|
|
(CUTOFF OF
|
|
DETAILED GROUP REPORT
|
|
DETAIL OF GROUPS =
|
|
GROUP:
|
|
COMPLETE REPORT OF ALL GROUPS
|
|
TABLE GROUPS =
|
|
TABLE COUNT=
|
|
PRINT OF JUST ONE GROUP (INCLUDING THE SPECIFIED TABLE)
|
|
The selected table doesn't fall in a group; see the shared set.
|
|
There isn't a group for the selected table; it doesn't have pointer links.
|
|
GROUP INCLUDING
|
|
...... Please wait. Reports take a few minutes to process ......
|
|
FileMan SQL/ODBC interface tables
|
|
SCHEMA: RECORD INSERT FAILED
|
|
STATS: RECORD INSERT FAILED
|
|
STATS: KEY COUNT INSERT FAILED
|
|
EDIT-PROTECTING SQLI FILES...
|
|
EDIT-UNPROTECTING SQLI FILES...
|
|
Try again later. An SQLI projection is running right
|
|
now. It might take a few hours to finish, but then you
|
|
can try again and get a final status report.
|
|
SQLI DIAGNOSTICS REPORT
|
|
No date associated with first SQLI Table record.
|
|
No dates found in the SQLI Error Log.
|
|
Different dates on Table and Error Log files.
|
|
LAST SQLI TABLE UPDATE:
|
|
LAST SQLI ERROR UPDATE:
|
|
SQLI was run in the past. DDs may have changed since then.
|
|
No SQLI Schema records. Has the SQLI projection been run?
|
|
No records in the SQLI Table file.
|
|
All regular tables appear to have been built.
|
|
Not all files appear to have been built as tables.
|
|
The last regular file to be processed was
|
|
The next one, file
|
|
may be the problem.
|
|
The next one, subfile
|
|
No records in the SQLI Column file.
|
|
Columns have been built for the last table processed.
|
|
It looks like not all columns were processed.
|
|
The last file processed was
|
|
The last field processed was
|
|
The next field to be processed looks like
|
|
Having finished with all fields of
|
|
, SQLI was probably
|
|
trying to process
|
|
, the next file.
|
|
The last one (
|
|
) is a subfile of
|
|
It is field
|
|
of file
|
|
That looks like the last field in
|
|
The next file to be processed looks like
|
|
The next subfile to be processed looks like
|
|
SUGGESTION: Investigate this file/subfile as the potential
|
|
source of the problem. That's:
|
|
No foreign key records have been built.
|
|
No table elements have been built for foreign keys.
|
|
All regular foreign keys have been built (FKs).
|
|
Parent foreign keys (PFKs) have also been built, the
|
|
last one being for file/subfile
|
|
Only regular foreign keys (FKs) have been processed.
|
|
The last was for file/subfile
|
|
No records for SQLI index tables.
|
|
Index tables don't appear to have been built.
|
|
Index processing stopped at file
|
|
All index tables appear to have been built. The last was for
|
|
No problems detected in SQLI data structures themselves.
|
|
Problems found in SQLI data structures.
|
|
See SQLI Site Manual, trouble-shooting section, for ideas about
|
|
how to investigate the problem. For example, RUNONE^DMSQ may be
|
|
used to explore a potential problem file.
|
|
DI,DIQUIET,DIFM
|
|
Time elapsed:
|
|
FIELD: CALL TO RETRIEVE ATTRIBUTES FAILED
|
|
DECIMAL DEFAULT
|
|
FM_MUMPS
|
|
SET_OF_CODES
|
|
FM_DATE_TIME
|
|
FM_MOMENT
|
|
FM_DATE
|
|
FM_FLAG
|
|
VARIABLE_POINTER
|
|
FM_MUMPS^245
|
|
Unable to proceed. Fileman version node ^DD(
|
|
) is undefined.
|
|
Unable to proceed.
|
|
0th node of ^DPT missing
|
|
Fileman version must be at least 17.2
|
|
Answer with PATIENT NAME, or SOCIAL SECURITY NUMBER, or last 4 digits
|
|
of SOCIAL SECURITY NUMBER, or first initial of
|
|
last name with last
|
|
4 digits of SOCIAL SECURITY NUMBER
|
|
-Entry PATIENT List
|
|
Load/Edit Patient Data
|
|
Register a Patient
|
|
...Patient not in database, use ADT options to load patient
|
|
Patient not found...Create stub entry:
|
|
Could not add patient to patient file
|
|
There is more than one patient whose last name is '
|
|
whose social security number ends with '
|
|
Are you sure you wish to continue (Y/N)
|
|
Warning : You have selected a test patient.
|
|
IORVOFF;IORVON
|
|
*** PATIENT ENROLLMENT END
|
|
*** PATIENT ENROLLMENT ENDING. ENROLLMENT END DATE IS NOT KNOWN. ***
|
|
Combat Vet Status:
|
|
BS5,CN,RM
|
|
CN,RM
|
|
BS,SSN,CN,RM
|
|
SSN,CN,RM
|
|
CN,RM,BS,SSN
|
|
CN,RM,SSN
|
|
ADDITIONAL MATCHES FOUND BUT NOT RETURNED
|
|
ENTER '^' TO STOP, OR
|
|
ADDITIONAL MATCHES FOUND BUT NOT
|
|
Unable to Add Patient. Your Fileman Access Code is undefined.
|
|
...adding new patient
|
|
Please enter the following additional information:
|
|
A NEW PATIENT (THE
|
|
Enter 'YES' to add a new applicant, or 'NO' not to.
|
|
Sorry, '^' not allowed!
|
|
Entry in
|
|
) refers to this patient
|
|
Unable to search for potential duplicates, Date of Birth and
|
|
Social Security Number must be defined.
|
|
...searching for potential duplicates
|
|
No potential duplicates have been identified.
|
|
The following patients have been identified as potential duplicates:
|
|
Do you still want to add '
|
|
' as a new patient
|
|
Enter 'YES' to add new patient, or 'NO' not to.
|
|
-1^required parameter not passed
|
|
-1^Could not add patient to patient file
|
|
and whose social security number ends with
|
|
Are you sure you wish to continue?
|
|
Patient name components--
|
|
Family name cannot be deleted!
|
|
(deletion indicated)
|
|
Invalid values to file, full name must be at least 3 characters!
|
|
Ok to file '
|
|
' and its name components
|
|
Indicate if the edits to the name and its components should be filed.
|
|
WARNING: Do not enter single name values for patients (no given or
|
|
first name) unless this is actually their legal name!!!
|
|
Are you sure you want to enter the patient name in this manner
|
|
Specify 'YES' to enter a single name value, or 'NO' to discontinue.
|
|
Input values less than 3 characters in length must be all alpha characters.
|
|
middle name.
|
|
Middle names of 'NMI' and 'NMN' are prohibited.
|
|
name prefix, such as MR or MS.
|
|
suffix(es), such as JR, SR, II, or II.
|
|
academic degree, such as BS, BA, MD, or PHD.
|
|
Answer with this persons
|
|
The response must be
|
|
characters in length and may only contain
|
|
uppercase alpha characters, spaces, hyphens and apostrophes.
|
|
While editing name components, only jumping to other components is allowed!
|
|
Edited:
|
|
>>> Changing name of 'IRT TYPE OF RECORD' file (#393.3)
|
|
to 'IRT TYPE OF DEFICIENCY'...
|
|
.01///IRT TYPE OF DEFICIENCY
|
|
>>> Initialization of Version
|
|
of DPT Complete.
|
|
-1^No detailed description found
|
|
Data
|
|
-1^Getting submultiples not supported.
|
|
-1^Only a single field number allowed with the W flag
|
|
-1^The W flag must be used by itself
|
|
-1^No data retrieved
|
|
Field number
|
|
-1^Error Message
|
|
-1^Error text
|
|
FILE,
|
|
VALUE,
|
|
#################### #################### ####################
|
|
#################### #################### ####################
|
|
#################### #################### ####################
|
|
#################### #################### ####################
|
|
#################### #################### ####################
|