QUERYING NPIC DATA SYSTEM (NDS) FILES VIA THE COINS NETWORK
Document Type:
Collection:
Document Number (FOIA) /ESDN (CREST):
CIA-RDP80T01355A000100250001-0
Release Decision:
RIPPUB
Original Classification:
T
Document Page Count:
15
Document Creation Date:
December 28, 2016
Document Release Date:
December 13, 2010
Sequence Number:
1
Case Number:
Publication Date:
January 1, 1980
Content Type:
REPORT
File:
Attachment | Size |
---|---|
CIA-RDP80T01355A000100250001-0.pdf | 450.17 KB |
Body:
Sanitized Copy Approved for Release 2010/12/13: CIA-RDP80T01355A000100250001-0
Sanitized Copy Approved for Release 2010/12/13: CIA-RDP80T01355A000100250001-0
Sanitized Copy Approved for Release 2010/12/13: CIA-RDP80T01355A000100250001-0
DISSEMINATION CONTROL ABBREVIATIONS
NOFORN- Not Releasable to Foreign Nationals
NOCONTRACT- Not Releasable to Contractors or
Contractor; Consultants
PROPIN- Caution-Proprietary Information Involved
USIBONLY- USIB Departments Only
ORCON- Dissemination and Extraction of Information
Controlled by Originator
REL. ..- This Information has been Authorized for
Release to ...
Sanitized Copy Approved for Release 2010/12/13: CIA-RDP80TO1355A000100250001-0
Sanitized Copy Approved for Release 2010/12/13: CIA-RDP80T01355A000100250001-0
Top Secret RUFF
UPDATE FOR NDS DOCUMENTATION
June 1980
QUERYING NPIC DATA SYSTEM (NDS) FILES
VIA THE COINS NETWORK
Destroy old pages. Insert new pages.
Top Secret
Sanitized Copy Approved for Release 2010/12/13: CIA-RDP80T01355A000100250001-0
Sanitized Copy Approved for Release 2010/12/13: CIA-RDP80T01355A000100250001-0
1. THE QUERY LANGUAGE PROCESSOR (QLP)
At present only a limited version of QLP is available for COINS II. In this section you
will find instructions for constructing and formatting a QLP query.
QUERY STATEMENTS
The following syntax skeleton summarizes the three QLP statements that comprise a query.
INVOKE subschema-name of PRODSCHEMA (newline)
CALL procedure-name 'argument l','argument 2....... argument II' (newline)
EXIT (newline)
where: subschema-name will indicate the file to be queried
(newline) represents the carriage return or newline key
on your terminal
procedure-name will indicate the predefined library
query you want to use
argument(s) will be the actual data base values for
which you are querying the file
Each query is initiated by an INVOKE statement. The INVOKE statement establishes com-
munication with the NDS data base system and states which file (subschema) of the NDS data
base is to be queried. The subschema-name parameter of this statement should be selected
based upon the file you wish to query. (See the following table.)
0
U)
eD
n
CD
C
m
T
M
m
Z
M
V)
M
w
0
Sanitized Copy Approved for Release 2010/12/13: CIA-RDP80T01355A000100250001-0
Sanitized Copy Approved for Release 2010/12/13: CIA-RDP80T01355A000100250001-0
Subschema Name File to be queried
COINSIDF IDF
COINSEPF EPF
COINSODF ODF
COINSMPF MPF
For example, if you want to query the Installations Data File (IDF), the first statement of
your query would be:
INVOKE COINSIDF OF PRODSCHEMA (newline)
The CALL Statement
The CALL statement consists of a procedure-name followed by the appropriate number of
arguments for the procedure-name you are using. A procedure-name is a combination of two
acronyms. The first indicates the output you want as a result of your query and is called a
report acronym. The second, indicates the type of data for which you are querying the file
and is called a query acronym. Arguments consist of the actual data base values that must be
matched in order to retrieve any output. Actually, procedure-names call predefined queries
from the query library. (See sections 2, 3, and 4 for a discussion of the predefined queries
available for the IDF, EPF, and ODF.)
For example, if you want to print output from a header record in the IDF for an instal-
lation with this BE number, 0123-45678, you would use the IHEDIBE procedure-name. The report
acronym, IHED, indicates that you want output from a header record, and the query acronym,
1BE, indicates that the record is to be retrieved based on a single BE number. The IHEDIBE
procedure name requires one argument, namely, the value for the BE number to be match in the
file. Arguments are always set off by single quotes. Thus the CALL statement for this
query is:
CALL IHEDIBE '0123-45678' (newline)
-i
0
N
CD
n
CD
C
T
T
Sanitized Copy Approved for Release 2010/12/13: CIA-RDP80T01355A000100250001-0
Sanitized Copy Approved for Release 2010/12/13: CIA-RDP80TO1355AO00100250001-0
The EXIT Statement
The EXIT statement terminates the query. Simply type the word EXIT and press the car-
riage return or the newline key on your terminal, e.g.:
EXIT (newline)
Summary
Thus the QLP queries presently available for COINS consist of three query statements:
* the INVOKE statement which indicates the file to be queried
* the CALL statement which indicates the data to be retrieved and the
output format for the answer
* the EXIT statement which terminates the query
Here is an example of a query against the IDF:
INVOKE COINSIDF OF PRODSCHEMA (newline)
CALL IHEDIBE '0123-45678' (newline)
EXIT (newline)
QUERY FORMAT
The format for a QLP query is very simple and must conform to the following rules.
* Each query must consist of an INVOKE statement, a CALL statement, and
an EXIT statement in that order.
* Each statement must begin on a new line, therefore, you must terminate
each statement by pressing the newline or carriage return key on your
terminal.
* Each word in a statement must be separated by one or more spaces except
when using multiple arguments; then separate each argument with a comma.
Sanitized Copy Approved for Release 2010/12/13: CIA-RDP80TO1355AO00100250001-0
Sanitized Copy Approved for Release 2010/12/13: CIA-RDP80T01355A000100250001-0
This exception does not apply to the arguments for the CIRC query
acronymn (see QUERY CONDITIONS) nor to the arguments used in MPF
queries. (See Chapter VI.) Arguments used with the CIRC query
acronymn and in MPF queries must be separated by one or more spaces.
* Arguments must be set off by single quotes. Each procedure-name has
a required number of arguments and they must be entered in the CALL
statement in a set order. (See Sections 2, 3, and 4 in this chapter.)
As mentioned above, multiple arguments must be separated by commas and
not spaces except when using the CIRC query acronymn and in MPF queries.
In these two cases, separate multiple arguments with one or more spaces.
* Generally a statement will not require more than one line. But if you
need or want to continue a statement on a new line, you can do so by
keying in a semicolon. The semicolon can be placed anywhere within a
line, even in the middle of a word, but you must press the carriage
return or newline key immediately after entering the semicolon. When
QLP encounters a semicolon, it appends the first character of the new
line to the character preceding the semicolon on the previous line.
Therefore if a semicolon is placed immediately after a completed argu-
ment the first character on the new line must be a comma for all
queries except those using the CIRC query acronymn and MPF queries.
In these two cases, use spaces instead of commas to separate multiple
arguments. Note the following examples where (N/L) represents a new
line and }6 represents a space.
Two Ways to Continue a Line
With Commas as Separators
Two Ways to Continue a Line
With Spaces as Separators
1.
CALL procedure-name 'argument l';
,'argument 2','argument 3' (N/L)
(N/L)
1.
CALL INHDCIRC 'argument 1'; (N/L)
}'argument 2'$'argument 3' (N/L)
2.
CALL procedure-name 'argument 1',;
'argument 2','argument 3' (N/L)
(N/L)
2.
CALL INHDCIRC 'argument 1W (N/L)
'agrument 2'~'argument 3' (N/L)
c m
Z m
M
N
M
CO 0
0
Sanitized Copy Approved for Release 2010/12/13: CIA-RDP80T01355A000100250001-0
Sanitized Copy Approved for Release 2010/12/13: CIA-RDP80T01355A000100250001-0
Query Acronym
Conditions in Query
Number and Order of Arguments
Select targets with specified WAC
Select targets with specified WAC
and specified IDHS code
Select targets with specified WAC
and with specified NPIC category
code
Select targets and readouts which
were input on a specified Julian
date
Select targets which fall with a
circle with specified center point
and radius
One argument : WAC from
TGT-HDR
Two arguments:
1st is WAC from TGT-HDR
2nd is IDHS from TGT-HDR
Two arguments:
1st is WAC from TGT-HDR
2nd is NCAT from TGT-HDR
One argument: Julian date;
three digits, e.g., 050
is the 50th day of the
current year, i.e., 19 Feb.
1980
Three arguments:
1st is LAT from TGT-HDR
2nd is LONG from TGT-HDR
3rd is radius in nautical
miles; three digits, lead-
ing zeros, e.g., 025
expresses a radius of 25
nautical miles; NB: do
not separate arguments
with commas; use a space.
QUERY PROCEDURES
The table on the following pages summarizes the library of available report and query
combinations for the IDF. The entries inside the table represent the required procedure-
name and the order and meaning of the arguments for the CALL statement.
Sanitized Copy Approved for Release 2010/12/13: CIA-RDP80T01355A000100250001-0
Sanitized Copy Approved for Release 2010/12/13: CIA-RDP80T01355A000100250001-0
Top Secret RUFF
TABLE OF PROCEDURE-NAMES AND ARGUMENTS FOR IDF QUERIES
REVISED
JUNE 1980
QUERY ACRONYM
1BE 5BE 10BE COUN CTCN NCCN WAC NCWC CTWC JDAT CIRC
IHEDIBE
IHED5BE
IHED1OBE
IHEDCOUN
IHEDCTCN
IHEDNCWN
IHEDWAC
IHEDNCWC
IHEDCTWC
IHEDJDAT
NOT
'BWAC'
1st 'BWAC'
1st 'BWAC'
'COUN'
'COUN'
'NCAT'
'WAC'
'WAC'
'WAC'
'NNN'
ALLOWED
IHED
2nd 'BWAC'
2nd 'BWAC'
'IDHS'
'COUN'
'NCAT'
'IDHS'
(Julian day)
5th 'BWAC'
10th 'BWAC'
INHDIBE
INHD5BE
INHD10BE
INHDCOUN
INHDCTCN
INHDNCCN
INHDWAC
INHDNCWC
INHDCTWC
NOT
INHDCIRC
R
'BWAC'
1st 'BWAC'
lst 'BWAC'
'COUN'
'COUN'
'NCAT'
'WAC'
'WAC'
'WAC'
ALLOWED
'LAT'
E INHD
2nd 'BWAC'
2nd 'BWAC'
'IDHS'
'COUN'
'NCAT'
'IDHS'
'LONG'
P
"'
"'
'NNN'
0
5th 'BWAC'
10th 'BWAC'
(radius)
R
T
IDESIBE
IDES5BE
IDESIOBE
IDESCOUN
IDESCTCN
IDESNCCN
IDESWAC
IDESNCWC
IDESCTWC
IDESJDAT
NOT
'BWAC'
1st 'BWAC'
lst 'BWAC'
ICOUN'
'COUN'
'NCAT'
'WAC'
'WAC'
'WAC'
'NNN'
ALLOWED
IDES
2nd 'BWAC'
2nd 'BWAC'
'IDHS'
'COUN'
'NCAT'
'IDHS'
(Julian day)
A
C
5th 'BWAC'
10th 'BWAC'
R
0
IOBJIBE
IOBJ5BE
IOBJ10BE
IOBJCOUN
IOBJCTCN
IOBJNCCN
IOBJWAC
IOBJNCWC
IOBJCTWC
NOT
NOT
N
'BWAC'
1st 'BWAC'
1st 'BWAC'
'COUN'
'COUN'
'NCAT'
'WAC'
'WAC'
'WAC'
ALLOWED
ALLOWED
y IOBJ
2nd 'BWAC'
2nd 'BWAC'
'IDHS'
'COUN'
'NCAT'
'IDHS'
M
...
5th 'BWAC'
10th 'BWAC'
IPHO1BE
IPH05BE
IPHO1OBE
IPHOCOUN
IPHOCTCN
IPHONCCN
IPHOWAC
IPHONCWC
IPHOCTWC
IPHOJDAT
NOT
'BWAC'
1st 'BWAC'
1st 'BWAC'
'COUN
'COUN'
'NCAT'
'WAC'
'WAC'
'WAC'
'NNN'
ALLOWED
IPHO
2nd 'BWAC'
2nd 'BWAC'
'IDHS'
'COUN'
'NCAT'
'IDHS'
(Julian day)
5th 'BWAC'
loth ;BWAC'
Top Secret
Sanitized Copy Approved for Release 2010/12/13: CIA-RDP80T01355A000100250001-0
Sanitized Copy Approved for Release 2010/12/13: CIA-RDP80T01355A000100250001-0
Top Secret RUFF
TABLE OF PROCEDURE-NAMES AND ARGUMENTS FOR IDF QUERIES (CONTINUED)
REVISED
JUNE 1980
QUERY ACRONYM
1BE 5BE LOBE COUN CTCN NCCN WAC NCWC CTWC JDAT CIRC
ILOCIBE
ILOC5BE
ILOC10BE
ILOCCOUN
ILOCCTCN
ILOCNCCN
ILOCWAC
ILOCNCWC
ILOCCTWC
NOT
NOT
'BWAC'
1st 'BWAC'
1st 'BWAC'
'COUN'
'COUN'
'NCAT'
'WAC'
'WAC'
'WAC'
ALLOWED
ALLOWED
ILOC
2nd 'BWAC'
2nd 'BWAC'
'IDHS'
'COUN'
'NCAT'
'IDHS'
5th 'BWAC'
loth BWAC'
ICOLIBE
ICOL5BE
ICOL10BE
ICOLCOUN
ICOLCTCN
ICOLNCCN
ICOLWAC
ICOLNCWC
ICOLCTWC
NOT
NOT
R
'BWAC`
1st 'BWAC'
1st 'BWAC'
'COUN'
'COUN'
'NCAT'
'WAC'
'WAC'
'WAC'
ALLOWED
ALLOWED
E ICOL
2nd 'BWAC'
2nd 'BWAC'
'IDHS'
'COUN'
'NCAT'
'IDHS'
P
0
5th 'BWAC'
loth 'BWAC'
R
T
IREQIBE
IREQ5BE
IREQ10BE
IREQCOUN
IREQCTCN
IREQNCCN
'IREQWAC
IREQNCWC
IREQCTWC
NOT
NOT
'BWAC'
1st 'BWAC'
1st 'BWAC'
'COUN'
'COUN'
'NCAT'
'WAC'
'WAC'
'WAC'
ALLOWED
ALLOWED
IREQ
2nd 'BWAC'
2nd 'BWAC'
'IDHS'
'COUN'
'NCAT'
'IDHS'
A
..
...
C
5th 'BWAC'
loth 'BWAC'
R
0
ISTAIBE
ISTA5BE
ISTA10BE
ISTACOUN
ISTACTCN
ISTANCCN
ISTAWAC
ISTANCWC
ISTACTWC
ISTAJDAT
NOT
N
'BWAC'
1st 'BWAC'
1st 'BWAC'
'COUN'
'COUN'
'NCAT'
'WAC'
'WAC'
'WAC'
'NNN'
ALLOWED
Y ISTA
2nd 'BWAC'
2nd 'BWAC'
'IDHS'
'COUN'
'NCAT'
'IDHS'
(Julian day)
M
...
5th 'BWAC'
loth 'BWAC'
IIBRIBE
IIBR5BE?
IIBR10BE
IIBRCOUN
IIBRCTCN
IIBRNCCN
IIBRWAC
IIBRNCWC,
IIBRCTWC
NOT
NOT
'BWAC'
1st 'BWAC'
lst 'BWAC'
'COUN'
'COUN'
'NCAT'
'WAC'
'WAC'
'WAC'
ALLOWED
ALLOWED
IIBR
2nd 'BWAC'
2nd 'BWAC'
'IDHS'
'COUN'
'NCAT'
'IDHS'
5thBWAC'
loth 'BWAC'
11-13
Top Secret 25X1
Sanitized Copy Approved for Release 2010/12/13: CIA-RDP80T01355A000100250001-0
Sanitized Copy Approved for Release 2010/12/13: CIA-RDP80T01355A000100250001-0
iop aecrei purr
TABLE OF PROCEDURE-NAMES AND ARGUMENTS FOR IDF QUERIES (CONTINUED)
ISECIBE
'BWAC'
IPROIBE
'BWAC'
CON11BE
'BWAC'
IDATIBE
'BWAC'
low 'MISS-DAT'
high 'MISS-DAT'
IALLIBE
'BWAC'
ISEC5BE
lst 'BWAC'
2nd 'BWAC'
IPR05BE
lst 'BWAC'
2nd 'BWAC'
CON15BE
1st 'BWAC'
2nd 'BWAC'
IDAT5BE
1st 'BWAC'
2nd 'BWAC'
5th 'BWAC'
low 'MISS-DAT'
high 'MISS-DAT'
IALL5BE
1st 'BWAC'
2nd 'BWAC'
10BE
ISEC10BE
lst 'BWAC'
2nd 'BWAC'
loth BWAC'
IPRO1OBE
1st 'BWAC'
2nd 'BWAC'
loth BWAC'
CON110BE
1st 'BWAC'
2nd 'BWAC'
loth BWAC'
IDATIOBE
lst 'BWAC'
2nd 'BWAC'
loth 'BWAC'
low 'MISS-DAT'
high 'MISS-DAT'
IALL10BE
1st 'BWAC'
2nd 'BWAC'
loth 'BWAC'
ISECCOUN
'COUN'
IPROCOUN
'COUN'
NOT
ALLOWED
IDATCOUN
'COUN'
low 'MISS-DAT'
high 'MISS-DAT'
NOT
ALLOWED
ISECCTCN
'COUN'
'IDHS'
IPROCTCN
'COUN'
'IDHS'
NOT
ALLOWED
IDATCTCN
'COUN'
'IDHS'
low 'MISS-DAT'
high 'MISS-DAT'
NOT
ALLOWED
ISECNCCN
'NCAT'
'COUN'
IPRONCCN
'NCAT'
'COUN'
NOT
ALLOWED
IDATNCCN
'NCAT'
'COUN'
low 'MISS-DAT'
high 'MISS-DAT'
NOT
ALLOWED
11-14
Top Secret
ISECWAC
'WAC'
IPROWAC
'WAC'
NOT
ALLOWED
IDATWAC
'WAC'
low 'MISS-DAT'
high 'MISS-DAT'
NOT
ALLOWED
ISECNCWC
'WAC'
'NCAT'
IPRONCWC
'WAC'
'NCAT'
NOT
ALLOWED
IDATNCWC
'WAC'
'NCAT'
low 'MISS-DAT'
high 'MISS-DAT'
NOT
ALLOWED
ISECCTWC
'WAC'
'IDHS'
IPROCTWC
'WAC'
'IDHS'
NOT
ALLOWED
IDATCTWC
'WAC'
'IDHS'
low 'MISS-DAT'
high 'MISS-DAT'
NOT
ALLOWED
NOT
ALLOWED
NOT
ALLOWED
NOT
ALLOWED
NOT
ALLOWED
NOT
ALLOWED
REVISED
JUNE 1980
NOT
ALLOWED
NOT
ALLOWED
NOT
ALLOWED
NOT
ALLOWED
NOT
ALLOWED
Sanitized Copy Approved for Release 2010/12/13: CIA-RDP80T01355A000100250001-0
Sanitized Copy Approved for Release 2010/12/13: CIA-RDP80T01355A000100250001-0
ITEM ENTRY CHARACTER FORMAT OF ENTRY
POSITIONS N=number A=letter b=blank
TGT-STAT (Cont.)
R = retired target
S = SALT target
X = record retired by IEG but re-
activated by CIA/OIA
0
U)
CD
AGEN Codes for agencies responsible for 4
installation exploitation
0
AAAA
cD
C
Pl-SAT-AGEN Code for agency responsible for 1
1st phase satellite exploitation
A T
T
Pl-AC-AGEN Code for agency responsible for 1
1st phase aircraft exploitation
A
P2-SAT-AGEN Code for agency responsible for 1
2nd phase satellite exploitation
A
P2-AC-AGEN Code for agency responsible for 1
2nd phase aircraft exploitation
A
`
C mm
Z <
m N
m
w
0
Sanitized Copy Approved for Release 2010/12/13: CIA-RDP80T01355A000100250001-0
Sanitized Copy Approved for Release 2010/12/13: CIA-RDP80T01355A000100250001-0
ITEM ENTRY CHARACTER
POSITIONS
FORMAT OF ENTRY
N=number A=letter b=blank
MAP-REF WAC WAG cell for this installation 10
Alphanumeric; no adjustment
PI-SKILL Code for Photo Interpretation 2
skills necessary for this target
NA
P2-RPT-DUE-DAT Date that next second phase read- 6
out of this target is due; YYMMDD
NNNNNN
format
FR-MISS-ID Last film return mission on which 9
Alphanumeric; left justified;
target was exploited
trailing blanks
FR-COLL-DAT Last film return collection date; 6
YYMMDD format
NNNNNN
FR-RD-OUT-DAT Last film return exploitation 6
date; YYMMDD format
NNNNNN
Sanitized Copy Approved for Release 2010/12/13: CIA-RDP80T01355A000100250001-0
Sanitized Copy Approved for Release 2010/12/13: CIA-RDP80T01355A000100250001-0
1. RETRIEVING DATA FROM THE
MENSURATION PARAMETERS FILE
The 14PFQRY Program is called and run from a teletype in the COINS network. The structure of
your input query is identical to all other NDS query structures with the following exception.
When using multiple arguments, separate them with one or more spaces; do not use commas.
See Chapter II for a discussion of this structure. To query the 14PF, the first statement of
your query should read INVOKE COINS '.1PF of PRODSCHEMA. The possible CALL statements and
their meaning are given in the following paragraph. Instructions for accessing the network
and making a batch NDS request are available in your office.
The program may be used 24 hours a day, 7 days a week.
Sanitized Copy Approved for Release 2010/12/13: CIA-RDP80T01355A000100250001-0
Sanitized Copy Approved for Release 2010/12/13: CIA-RDP80T01355A000100250001-0
Sanitized Copy Approved for Release 2010/12/13: CIA-RDP80T01355A000100250001-0