-------
Figure 6-6. Dun & Bradstreet Keywords
6.4 Looking at a GO Names Quay
lit
Once you have returned the facility
CORP. PROF. Y or N, and pressing
SCREEN and displays the GO Names
to your query by selecting Y, A, or M, and
< Enter >, IDEA takes you to the EDIT
query you have constructed.
Figure 6-7 represents a portion of a GO Names-generated facility query based on
EPA ID numbers. The first three lines (numbers 000001-000003) on the screen
contain comments indicating the selection criteria, and how many names were
selected. The Keyword query logic follows these comments. (A brief explanation of
Keywords will be given here - see Chapter 8, Conducting a Search Using Keywords
for a more detailed treatment of the sjibject.)
The first line of the actual query logic (line no. 000004) indicates that when you run
this query, you will receive pUTptlT in REPORT format 1A. The next line
indicates-that the INPUT data that IDEA will use to process your query will be
LINKED; i.e. the FINDS system will be used to integrate data taken from the
different databases (see Chapter 2, IDEA: What it Does & How it Works).
6-12
IDEA
-------
KfcOiK f»t 07Z
Figure 6-7. A GO Names Query in the Edit Screen
Line 000006 indicates the SELECTion criteria that IDEA is using in the query.
When you form a GO Names query, IDEA takes the name you enter and looks up
all the facilities with matching names in the FINDS database (FIN). FINDS provides
a list of EPA identification numbers (EPID) for all the facilities with matching
names. Finally, IDEA sets up the query as shown in Figure 6-7 and returns it to you
with the EPA ID numbers of all the facilities. IDEA also provides the facility names
for your convenience, but they are not actually part of the query. The characters /*
tell IDEA to ignore anything to their right on the same line.
Technical Note:
IDEA uses an enhanced version of the FINDS database. It is enhanced during
the monthly program file refresh/update cycle to include facilities which the
OIRM FINDS file does not contain. If a facility from a program office data
system is not included in the OIRM FINDS file, IDEA will generate a pseudo
EPA ID Number for that facility record. These IDEA/EPA ID Numbers can
be readily distinguished from officially assigned numbers as they contain the
character string "IDEA" starting in the third position of the number. In this
way, every facility that is provided to IDEA from EPA's program office data
systems can be included hi this enhanced FINDS file.
User's Guide
6-13
-------
6.4.1 Modifying a GO Names
Query
As discussed in Section 6.2.1, when IDEA searches for names, it uses a system that
looks for matches to the first character and the next three consonants or numbers of
each word you enter, it does not attempt an exact character-for-character match. For
this reason, you may wish to delete [lines that contain "false positives" - facility
names that are not of interest to you.
Hie ISPF EDIT SCREEN, in which yoiir GO Names query is displayed, is a scrolling
display text editor (word processor) that allows you to type over any data displayed
and perform certain editing functions. General commands (e.g., END, CANCEL)
are entered next to the COMMAND prompt on the second line of the screen. Any
editing operations (e.g. deleting or moving lines) are performed by entering a
command directly on the line numbers) of the affected line(s).
Table 6-2 lists several of the line commands available.
Table 6-2. Line Editing Command!
C
M
D
CC, MM, or DD
G>,Mn,Dn
A
B
I
In
Cepy (his line
Move tfai. line
Delete thii line
M*rk starting and ending line* for copying, moving, or
deleting a block of HUM.
Ctpy, Move, Delete next n lines
PI ice moved/copied lines after tint line
PI tee moved/copied lines before thit line
Inert a line
In: ert n lines
As an example of how these oommandh are used, suppose that you are only interested
in the first facility listed in the above query (Figure 6-7), the one with EPA ID
number CAD009111212. You would perform the following steps to delete lines 12
through 21 and edit the query:
1.
2.
Use or the
you wish to delete
in the line number.
a TOW
keys to move the cursor to the first line
(line 000012) and type DD directly over the zeros
or arrow
delete (line 000021, the
line number as well.
down
to the last line of the block you wish to
last line in the query) and type DD over that
6-14
IDEA
-------
3. Check your work to make sure you marked the correct lines (deletions
axe permanent!!), then press to delete the block of lines.
4. Use < Tab > and the arrow keys to move the cursor to the end of the
EPA ID number in tine 000007, and < Space > over the comma to
remove it.
If you delete the last facility in the query, you must make sure that there
are no commas in the entry that is last in the resulting list. Note that the
facilities in lines 7, 12, IS, 17, and 19 of Figure 6-7 have commas, but
the facility entry in line 21 does not.
Table 6-3 below highlights several other commands available for use hi the EDIT
SCREEN, including commands for scrolling (should your query be too long to fit on
a single screen). Chapter 9, Managing Keyword Queries and the ISPF Editor
contains detailed instructions for using all of the ISPF Editor features introduced in
this Chapter.
Table 6-3. ISPF Keys and Commands (default values)
Command
END
PF3/PF15
RETURN
PF4/PP16
UP
PF7/PF19
DOWN
PFS/PF20
LEFT
PF10/PF22
RIGHT
FP11/PF23
To muMUVM tb«
cursor Mound
IDBAicnwu
TonMtm*
keyboard when H
lock* up
Mod*
Edit
Blown
Edit*
Brows*
Edh&
»
IXwWBV
Edit*
Brow**
Edit A
»__— .-*
ncvwpv
Edit «t
BrowM
DMcription
Sew ctunfM tad Mum*
k«y to mow* ID* eunor from prompt to prompt;
u«* to raov* A* eunor to «h» lop-l*ft
prompt
k«y; k«y with R; right
, depending on your kvybottd
coafiguntioa
User's Guide
6-15
-------
Report 1A is the default report format i
by typing another format over 1A,
in RETORT on the same line and
"REPORT" must be entered each tune
you want reports 1A, 2, and SUMMARY
ised by GO Names. You may change formats
you may select additional formats by typing
specifying another format. The keyword
another report is specified. For example, if
the OUTPUT line should look like this:
OUTPUT RETORT 1A REPORT 2 REPORT SUMMARY
See figure 6-8 for a brief description of the different report formats available in
IDEA.
IDEA Reports
Them are currently four standard IDE^
REPORT 1A
A brief report of individual facilities.
displays die facility name and
information, noncompuance oi|
reports: 1A, IB, 2, and Summary.
Organized by the ii«imd database, IDEA
database identifier, location and other business
violation status, and enforcement information.
REPORT IB
A more detailed presentation I of information on individual facilities, including
historical and programmatic data such as dates and results of inspections, specific
toxic substances reported, and details of enforcement actions.
REPORT2
A linked docket table mat indicates whether each facility is listed as a significant
noncomplier or high priority violator.
REPORT SUMMARY
Provides total facility counts by, program and EPA region; sum of faculties that an
actions by program; and total |oxic substance release information for the selected
facilities.
Figure 6-8. IDEA Standard Report
Formats
6-16
IDEA
-------
6.5 Running a CO N.
On en'
Once you are satisfied with the content of your query, you are ready to run the query
and receive the report(s) you have specified. To run a Keyword query, use
or < Tab > to move your cursor to the COMMAND prompt, type GO,
and press < Enter >.
From here, IDEA processes the query and then presents the QUERY STATUS
SCREEN, shown below in Figure 6-11.
figure 6-11. Query Status Screen
Viewing a Query Report
If you choose to see the reports, IDEA will deliver information to your screen
according to die format(s) you selected earlier. The report is presented to you in the
BROWSE mode (see Figure 6-12) which allows you to view, print, or save data, but
not alter it. To maneuver through the report, use FF7 to page up, PF8 to page
down, PF10 to scroll left, and PF11 to scroll right. If you selected multiple report
User's Guide
6-17
-------
formats, type SW at the COMMAND
Chapter 10, IDEA. Standard Reports for
prompt to switch to the next report. See
more details.
Figure 6-12. Report 1A in Browse
Mode
6. 7 Exiling GO
To exit the Keyword Interface at any time follow these procedures:
To save your current work, use
the program screen by screen.
the END command (PF3 key) to back out of
saving, use the CANCEL command at the
If you would rather exit
EDIT screen then use END or t»F3 to back out screen by screen.
Use the RETURN (PF4) command to return to the OFFICE OF
ENFORCEMENT DATA INTEGRATION PRIMARY MENU (your current work
will be saved), then type I for IDEA at the OPTION prompt to get back to
the IDEA WELCOME SCREEN, or type X to exit to the TSO READY
prompt.
6-18
IDEA
-------
Or type »X at the COMMAND line to go directly to the TSO READY
prompt (your work will be saved automatically).
6.8 Summary
GO Names is a utility that allows IDEA users to build a query based on a facility
name or location parameters. This utility applies an algorithm which recognizes
consonant character strings within names. GO Names allows users to specify how
much information is returned to the ISPF editor. It will return a Dun & Bradstreet
corporate profile if the CORP. PROF. (Y/N) option is selected. GO Names will
return facility information to the ISPF editor where it can be reviewed, edited, or run
as a query.
User's Guide
6-19
-------
6-20
IDEA
-------
Chapter 7
Conducting a Search Using GO MenuA
IDEA'S GO MenuA utility allows you to build a query in the Keyword Interface by
using the Menu Interface.
Sections:
7.1 Introduction to GO MenuA
7.2 Getting Started
7.3 Using GO MenuA
7.3.1 Editing GO MenuA Queries
7.3.2 Combining GO MenuA and GO Names Queries
7.4 Running a GO MenuA Query
7.5 Viewing Reports
7.6 Exiting GO MenuA
7.7 Summary
7.1 Introduction to GO MenuA
The GO MenuA utility allows you to build a query in the Menu Interface and edit it
in the Keyword Interface. The Menu Interface is the simplest means of retrieving
information from IDEA. It provides convenient pop-up windows for you to form
queries simply by selecting criteria from lists. Although easy to use, the Menu
Interface is fairly rigid because it makes some assumptions about the data selection
and logical structure of a query. These assumptions cannot be altered in this
interface.
The Keyword Interface, on the other hand, is not as easy to use but allows you more
freedom. It is a word processor that allows you to build queries from scotch
according to almost any criteria found in the linked IDEA databases. This wide
range of choices gives you the ability to form very detailed queries involving many
variables. The hard part is that you must know the correct query syntax to build
Keyword queries from scratch. You have more freedom because you can tailor the
query, including the query logic, to suit your needs. By using the GO MenuA utility.
User's Guide i \
-------
you have the advantages of both interfaces — the convenience of a ready-built query
from the Menu Interface and the flexibility to edit it within the Keyword Interface to
suit more specific needs.
7.2 Getting Started
Before you can access the GO
Interface from the INTERFACE
select a library in the INPUT
Your IDEA library is where you
information on this topic, refer to
feature, you must choose the Keyword
'ONSCREEN. IDEA will then ask you to
SELECTION SCREEN (set Figure 7-1).
build and store your queries. For more
5, Managing Libraries.
When working in the INPUT LIBRARY SELECTION SCREEN, do not
press < Enter > until you are finished editing the options on the screen;
otherwise, IDEA will take you to the next screen. If < Enter > is
pressed accidently, press PP3 or type END at the COMMAND prompt
and press < Enter > to tsdim to the INPUT LIBRARY SELECTION
Figure 7-1. Library Selection
7-2
IDEA
-------
To accept the default values listed at the LIBRARY NAME and the LIBRARY
STATUS(Shr/New/Old) prompts, press < ENTER >; and the MEMBER LIST
SCREEN will appear (see Figure 7-2). Members are queries that you compose and
store in your library as with books on a shelf or files in a WordPerfect directory.
The queries in the Member list will be available to you each time you use IDEA.
If you have not created any queries up to now, there will be no entries under the
headings.
Figure 7-2. Member List Screen
When you create a new member in the library, you actually set up a work space for
composing and running your query. If you decide to save the query, the contents of
the work space will be saved to die member you named. Simple commands allow
you to browse, create, retrieve, rename, describe, and delete the queries in your
Member List. These commands are listed in Table 7-11 Member List Commands
below. They should be typed to the left of the member name or at the COMMAND
prompt followed by a space and the member name.
User's Guide
7-3
-------
Table 7-1. Library Member List Commands
B
E (or S)
R
U
D
Browse/Read the query; no editing possible.
Edit/Sel ect an existing query or create a new one
in the e liter.
Rename the query.
Update the query description.
Delete Jhe query from the MEMBER LIST.
To create a query, type E at the COMMAND prompt, press < Space >, type the
name of the new query (for example, E NEWQUERY as in Figure 7-2), and press
< Enter >.
Query names can be up to
eight characters long including numbers and
After you choose to create or edit a c uery
EDIT SCREEN will appear (see Figun t 7-3)
letters but not special characters such as @#$%*&*0"?/!.
query from the MEMBER LIST SCREEN, the
Using
GO McmiA
To access the GO MenuA utility,
a blank EDIT SCREEN, and press
type GO MENUA at the COMMAND prompt of
(see Figure 7-3).
< Enter >
The GO MenuA utility has a destructive overwrite function that erases
other queries in the EDIT SCREEN before writing the query generated
from GO MenuA. To avoid deleting parts of your query, access GO
MenuA from a blank EDF1' SCREEN.
7-4
IDEA
-------
Figure 7-3. Blank Edit Screen
As shown in Figure 7-4, the M4/7V M£M/ SCREEN of the Menu Interface will
i^pear. With this utility, you can select criteria from the Menu Interface, and GO
MenuA will generate a Keyword query for you back in the Keyword Interlace.
Figure 7-4. Main Menu Screen
User's Guide
7-5
-------
To choose a categoiy in the
cursor to the left of the category
by < Enter >. This sequence
selection from the IDEA Mrau
Menu Interface, use to move the
name, then type S (for select) followed
is used whenever you want to make a
Interface.
For more information on building a query in the Menu Interface, refer to Chapter 4,
Conducting a Search Using the Menu Interface.
To illustrate one possible use of the GO
some noncompliance keyword logic, th sn combine that with a
Names. The combined query will thep select only those named facilities which are
also noncompliers.
This is merely an exercise that has i
going enforcement initiatives. The
facilities that are:
MenuA utility, we will use it to generate
name search using GO
basis in fact regarding any planned or on-
3O MenuA portion of the query will find
Noncompliers or signifu ant noncompliers in any of the program office
databases accessed by 13HA.
i
Select noncompliance criteria in the ft^enu Interface as shown in Figure 7-5.
Figure 7-5. Noncompliance Criteria in the Menu Interface
7-6
IDEA
-------
When you are satisfied with the content of your query, type S next to RUN QUERY,
and press < Enter >. The INPUT REPORT SELECTION SCREEN will appear.
Select the type of search you want to conduct (linked, nonlinked, or linked
nonlinked), the report format(s) you want to view (1A, IB, 2, SUMMARY), and
press < Enter >.
If you were simply building a query in the Menu Interface, IDEA would run your
search at this point, and the QUERY STATUS SCREEN would appear. The GO
MenuA utility of the Keyword Interface, however, generates a Keyword query and
returns it to the editor for you to edit before you run it. Therefore, the EDIT
SCREEN will appear with the Keyword query you have just generated. For example,
the query criteria in Figure 7-5 generated the keywords in Figure 7-6,
Figure 7-6. Edit Screen
The GO MenuA keywords that are displayed are in the following format:
• Lines 000001 to 000007 - Comment lines that highlight the keywords
generated by GO MenuA always precede the keywords. Comment
lines also precede some sections of keywords in order to indicate from
which Menu category they came, as in Line 000010.
• Lines 000008 & 000009 - Contain the OUTPUT, INPUT, and
SELECT statements that are necessary for any query.
User's Guide
7-7
-------
OUTPUT - Indicates that you will receive output in the form
of Reports 1A, Report 2, and Report Summary. For more
information on (these reports, refer to Chapter 10, IDEA
Standard Repot
INPUT - Indicates that the input data that IDEA, will use to
process your qufry will be linked, which means that FENDS
will be used to:
(as opposed
information on i
i data taken from the different databases
nonlinked or linked nonlinked). For
i options, refer to Chapter 2, IDEA: What
it Does & Haw it Works.
SELECT - Selection criteria that IDEA will use when it
searches for facilities in the copies of the program office
databases. In this case, the selection criteria are the
noncompliance criteria that were selected from GO MenuA in
Figure 7-5.
Line 000010 - A comment line that notes the Menu category from
which the following keywords were generated. In this case, the
keywords came from the Noncompliance Category.
Lines 000011 to 000016 - Parentheses are included for each
condition and for each Menu category. These lines make up the rest
of the SELECT statenu nt.
Once you have generated a Keyword
options. You can edit the query, add
Names utility), or run it as it is.
query using GO MenuA, you have several
more criteria to it (e.g., by accessing the GO
7.3.1 Editing GO MenuA Qutries
The ISPF EDIT SCREEN is a scrollk g display
any data that is being displayed. You
commands in Table 7-3, Line Editing
line numbers at the left of the £D/7
Queries and the ISPF. Editor describe i
format that allows you to type over
can edit the lines in the query with the
Commands. Type these commands over the
SCREEN, Chapter 9, Managing Keyword
how .to edit Keyword queries in detail.
7-8
IDEA
-------
Table 7-3. Line Editing Commands
C
M
D
CC, MM, or DD
Cn,Mn,Dn
A
B
I
In
Copy this line
Move this line
Delete this line
Marie starting and ending lines for copying, moving, or
deleting a block of lines.
Copy, Move, Delete next n lines
Place moved/copied lines after this line
Place moved/copied lines before this line
Insert aline
Insert n lines
For mote information on the Keyword query you generated, refer to Chapter 8,
Conducting a Search Using Keywords.
7.3.2 Combining GO MenuA and GO Names Queries
You can add facility name and/or location parameters to your query using the GO
Names utility. To access this utility, type GO NAMES at the COMMAND prompt,
and press < Enter >.
U^> While you are using the GO NAMES NAME SELECTION MENU, do not
press the < Enter > key until you have finished typing in all the
necessary information. Pressing < Enter > will instruct IDEA to run the
name search function, so use the < Tab > key and arrow keys to navigate
the screen.
Enter name and/or location parameters in the NAME SELECTION MENU SCREEN,
and press < Enter >. To recreate the example in Figure 7-7, type CAMPBELL
SOIJP at the NAME prompt and NJ at the STATE (SS) prompt. After you are
satisfied with your entries, press the < Enter > key to run the facility selection
function. IDEA will display the number of possible matches it found for your name
and/or location criteria followed by two prompts which are explained below. If you
are not satisfied with the number of possible matches, you can edit your entries, and
press < Enter >. IDEA will display the number of possible matches for your new
criteria.
User's Guide
7-9
-------
Figure 7-7. Name Selection Menu Si Teen
The prompt, RETURN NAMES TO QUERY, gives you the option of specifying one
of three ways to return the names to the EDIT SCREEN. Type Y at this prompt,
press , and the GO Namss keywords will be returned to the EDIT
SCREEN followed by those generated 1 rom GO MenuA. In Figure 7-8, lines 000001
to 000009 were generated by GO Names and lines 000010 to 000021 came from GO
MenuA.
Note: When IDEA searches for nam «, it uses a soundex algorithm that looks for
matches to the first character and the i lext three consonants of each word you enter.
For this reason, your query may contain some "false positives" - faculties with
names that do not exactly match the oije you are looking for. You should delete any
extraneous facilities from your list.
If you delete the last facility
must make sure that there
resulting list. Note that
Figure 7-8 have commas,
in the GO Names portion of the query, you
ire no commas in the entry that is last in the
the facilities in lines 000007 and 000008 of
the facility entry in line 000009 does not.
tut
If you need more information about (JK> Names, refer to Chapter 6, Conducting a
Search Using GO Names.
7-10
IDEA
-------
v
v CQtJMIS 001 072
Figure 7-8. Edit Screen
Since the GO MenuA and GO Names utilities were designed to generate self-
contained Keyword queries, you have to modify the query that results from
combining diem in order to preserve proper query syntax. There are two steps to
modifying the query:
1. Insert the word AND between the two queries (between lines 000009
and 000010 in Figure 7-8). To do this step, type I on line 000009
(over the line number itself), and press < Enter >. Then type AND,
and press < Enter > two times.
2. Delete the INPUT, OUTPUT, and SELECT statements in the second
query which occupy lines 000019 and 000020 in your query now. To
do this step, type D2 on line 000019 (over the line number itself), and
press < Enter >.
Figure 7-9 shows the sample query after these changes have been made.
User's Guide
711
-------
Figure 7-9. Edit Screen
Ritnnin<' ci GO Menu A ()ncr\
To run the query, use or to move your cursor to the
COMMAND prompt, type GO, and press < Enter >. From this point, IDEA will
process the query and display the QU&RY STATUS SCREEN shown below in Figure
7-10. In the sample query, two facilities were found that met all of the criteria.
7-12
IDEA
-------
Figure 7-10. Quay Status Screen
Viewing Reports
If you choose to see the report, IDEA will deliver information to your screen
according to the format designated on the OUTPUT line of your query. The report
is presented to you in BROWSE mode which allows you to view, print, or save data,
but not alter it (see Figure 7*77). To maneuver through the report, use PF7 to page
up, PF8 to page down, PF10 to scroll left, and PF11 to scroll right. If you selected
multiple report formats, type SW at the COMMAND prompt to switch to the next
report.
User's Guide
7-13
-------
Figure 7-11. Report 1A in Browse Mode
Exiting
CO McmiA
Since the GO MenuA utility runs from within the Keyword Interface and uses the
Menu Interface, you can exit this utility from either of these interfaces.
To exit from the Menu Interface, follow these steps:
• Press PF3 to back up to
The criteria you have se
in the Menu Interface,
unless you select RUN
the EDIT SCREEN of the Keyword Interface.
ected in the Menu Interface will be preserved
but the keyword query will not be generated
QUERY from the Menu Interface.
From the Keyword Interface, you havis the following options:
• To get back to the INTERFACE SELECTION SCREEN (at any time)
And save your w ork - Type END at the COMMAND prompt
or press PF3 to lack out of the program screen by screen. This
method saves your work.
Without saving. your work - Type CANCEL at the
COMMAND prompt of the EDIT SCREEN then use END or
PF3 to back out screen by screen.
7-14
IDEA
-------
To return to the OFFICE OF ENFORCEMENT DATA INTEGRATION
PRIMARY MENU, use the RETURN (PF4) command (your current
work will be saved). Type I for IDEA at the OPTION prompt to get
back to the IDEA WELCOME SCREEN, or type X to exit to the TSO
READY prompt.
To go directly to the TSO READY prompt, type =X at the
COMMAND prompt. Your work will be saved automatically.
7 7 Sunwum
GO MenuA is a utility that allows you to build a Keyword query by selecting criteria
from lists in the Menu Interface. If you use GO MenuA, you can have the
convenience of the Menu Interface and the flexibility of the Keyword Interface while
assembling your query. After constructing a query with GO MenuA, you can edit
it, add to it using die GO Names utility, or run it as it stands.
User's Guide 7-15
-------
7-16
IDEA
-------
Chapter 8
Conducting a Search Using Keywords
This chapter provides detailed information on IDEA. Keyword Queries.
Sections:
8.1 Introduction to IDEA Keywords
8.2 Using Keywords to Write Queries
8.2.1 The Input Statement
8.2.1.1 Using Linked & Nonlinked Keywords
8.2.2 The Select Statement
8.2.2.1 Choosing a SELECT Database
8.2.2.2 Choosing a SELECT Data Element
8.2.2.3 Using a Boolean Operator
8.2.2.4 Providing SELECT Data Values
8.3 Using Boolean Connectors in a Query
8.4 Using Parentheses in a Query
8.5 Output Report Selection
VF 8.6 Specify ing Report Destinations
8.7 Adding Comments to a Query
8.8 JOB, ROUTE & DD Statements
8.9 Running a Keyword Query
8.9.1 Viewing the Query Report
8.10 Exiting Keywords
8.11 Summary
8.1 Introduction to IDEA Keywords
The Keyword Interface allows you to conduct a search according to almost any
criteria that can be found in the linked IDEA databases. This wide range of choice
User's Guide 8-1
-------
gives you the ability to form very detail sd queries involving many variables; a luxury
the Menu functions. To use Keywords you
: catching for and how to find it. This chapter
that is not available to you when using
must have a good idea of what you are
will teach you how to take the search criteria you have and use Keywords to gather
the information you need.
To build a Keyword query, choose the Keyword Interface from the INTERFACE
SELECTION SCREEN. IDEA will thin ask you to select a library in the INPUT
LIBRARY SELECTION SCREEN (see / igure &-I). Your IDEA library is where you
will build and store your queries. For more information on this topic, refer to
Chapter 5, Managing Libraries.
ng* When working in the INPUT LIBRARY SELECTION SCREEN, do not
press until you are finished editing the options on the screen;
otherwise, IDEA will take you to the next screen. If is
pressed accidently, press PF3 or type END at the COMMAND prompt
and press < Enter > to return to the INPUT LIBRARY SELECTION
SCREEN.
Figure 8-1. Input Library Selection
Screen
To accept the default values listed at the LIBRARY NAME and the LIBRARY
STATUS(Shr/New/Old) prompts, pitss ; and the MEMBER LIST
SCREEN win appear (see Figure 8-2). Members are queries that you compose and
store in your library as with books on a shelf or files in a WordPerfect directory.
The queries in the Member List will be available to you each time you use IDEA.
The list displays the member name, the date and time that it was created or last
8-2
IDEA
-------
changed, an optional description of the member's contents, and the user ID of the
person who last modified the member (see Figure 8-2). If you have not created any
queries up to now, there will be no entries under the headings.
m
Figure 8-2. Member List
When you create a new member in the library, you actually set up a work space for
composing and running your query. If you decide to save the query, the contents of
the work space will be saved to the member you named.
Table 8-1 below is a summary of the command options used for managing a member
list. They should be typed to the left of the member name, or at the COMMAND
prompt followed by a space and the member name. An existing member can be
selected and edited or a new one created by typing E or S followed by the member
name at the COMMAND prompt.
User's Guide
8-3
-------
Table 8-1. Library Member List Commands
B
E (or S)
R
U
D
Browse/1 lead the query; no editing possible.
Edit/Seh ct an existing query or create a new one
in the ec itor.
Rename the query.
i
Update the query description.
Delete tfre query from the MEMBER LIST.
After you select a query to edit, or create a new one, press < Enter >. IDEA will
bring you to the EDIT SCREEN illustrated in Figure 8-3.
Figure 8-3. Edit Screen
8-4
Before getting started, a glance at Tabl'.
for maneuvering around the Keyword Ii iterface
Keyword screens, see Chapter 9,
8-2 will provide you with some helpful tips
. For more information on navigating
Managing Keyword Queries and the ISPF Editor.
IDEA
-------
Table 8-2. ISPF Keys and Commands (Default Values)
Command
ISPF HELP
PF1/PF13
SPLIT SCREEN
PFMPF14
END
Mn/pm<
tuflUKN
PF4/PFU
REF1ND
PFWPF17
RECHANGE
PW/PFlg
UP
PF7/PF19
DOWN
PFWPFM
SWAP
PI9/PF21
LEFT
PF10/PF22
RIGHT
PF11/PF23
RETRIEVE
PFU/PF24
FIND
CHANdrfi
SAVE
CANCEL
Mode
Edit*
Browse
Edit*
Browse
Edit
Browse
Eon OJ
Browte
Edit 4
Brown
Edit
Edit*
Browse
Edit*
BnwM
Edit*
BlWWM
Edit*
Browse
Ed*&
Browse
Edit*
Browse
Edit*
Browse
Edit
Browse
Edit
DescriptioB
Displays mformatioa abort the current screen.
SptiH the screen into two ISPF MCSMM.
SAVCI CQaUgcs md nctokHmS to tbc pnvionv SCTMB*
Rctui'Ui to PK pnvimi icreau
Men.
Repeats the previous FIND fommapd.
Repeats the prerioas CHANGE fnaimaiid.
Scrolls «p by the aaumt set at Oe SCROLL or
COMMAND prompt.
Scrobdmn by the amoont set at the SCROLL
or COMMAND prompt.
fc J,,— ^ AiV^ ^^.^MribB 4^h^B j.^^. •jk«^t^^ A«K AaV^ ^rfla^Mt «W
mom VJmV limUaTOT IIUHI QBB •CaTVCmi CW (•*? OHPBr ami
the fptit-fcreca mode.
ScnOs left by the amount set at the SCROLL or
COMMAND prompt.
Serous right by the amount set at the SCROLL or
COMMAND prompt.
Moves the conor to the fint mpat fidd on the
Locates the firrt nae coataiamf a specified
character or striae, of characters.
another character^).
Savei TOW work and roaums m the edk senkw.
Refer to the Savimg Jtajwtt portioa of Oupttr 10.
Ends an edk nssioa wttboat savmf any changes.
8.2 Using Keywords to Write Queries
The typical Keyword query contains three basic elements, or statements, made up of
required keywords and parameters, as well as optional keyword qualifiers. These
User's Guide
8-5
-------
8-6
three elements are the INPUT statement, the SELECT statement, and the OUTPUT
statement.
Figure 8-4. Example Keyword
Figure 8-4 is an example of a keyword query
statement (line 1), an INPUT statement
Lines 5 and 7 show the Boolean connector
can appear before the INPUT
names and values.
statetn !nt
. Notice that it consists of an OUTPUT
(tine 2), and a SELECT statement (line 3).
AND. (Note: the OUTPUT statement
.) Lines 4, 6, and 7 show data element
Note: There may only be one INPUT statement and one OUTPUT statement.
"SELECT" may only be entered once.
8.2,1 The INPUT Statement
The INPUT statement, which instruct! i IDEA how to process the search criteria, is
a necessary component of every Keyword query. It will affect how many facilities
may be selected and how the output will be organized. The INPUT qualifiers:
LINKED, NONIINKED, and the combination LINKED NONUNKED, determine
IDEA
-------
exactly how your query is processed. These qualifiers are discussed in Section
8.2.1.2.
At the blank EDIT SCREEN, the cursor will be flashing by the COMMAND prompt
(see Figure 8-3). IDEA may include messages at the top of the screen. To remove
these, type RESET at the COMMAND prompt (optional). To begin building a
query, you will have to move the cursor below these messages and to the right of the
six apostrophes on the left hand side of the screen. After you have formed your
query and pressed < Enter > these apostrophes will turn into line numbers. If you
press < Enter > before completing your query, insert lines by typing i on a line
number; press < Enter >. This will insert a line after that line.
Use or the arrow keys to move your cursor down to the first open line on
the EDIT screen. Type the word INPUT. If you do not include an INPUT qualifier,
IDEA assumes the default: LINKED. INPUT should typically appear as the first
statement in a Keyword query. Two notable exceptions, however, are GO Names
and GO MenuA generated queries.
8.2.1.1 Using Linked and NonUriked Keywords
When you include the keywords LINKED and/or NONUNKED in your query, you
are telling IDEA what type of information to retrieve; namely, data that has been
integrated using FINDS, non-integrated data from the separate databases, or both
together. Refer to Section 2.3, How IDEA Processes Queries for complete details.
Linked
LINKED is the default; that is, if you do not specify LINKED and/or NONUNKED
in your query, IDEA will retrieve data that has been integrated using FINDS.
NonUnked
The NONUNKED keyword instructs IDEA to retrieve information from the separate
systems without using FINDS to integrate the data.
The benefit of choosing NONUNKED is that you will receive all the data you are
seeking. (LINKED data may not be complete since FINDS does not contain data for
all facilities.) The drawback of NONUNKED data is that you will have to manually
match facilities from separate systems in order to integrate the data.
If you would like to retrieve non-integrated data without using FINDS, type
NONUNKED after INPUT and use. only Boolean ORs as connectors between
databases. If you use a Boolean AND between databases, IDEA will interpret it as
User's Guide 8-7
-------
8-8
an OR since integration of data is no
separately.
Linked Nonlinked
\ be combined in a query to get both integrated and
JKED after INPUT will instruct IDEA
integrated by FINDS and data that has not been
LINKED and NONLINKED can
nonintegiateddata. Typing LINKED NONLINKED after INPUT will instruct IDEA
to retrieve data that has been
integrated by FINDS.
This INPUT criteria will generate two
will contain those facilities that meet i
FINDS. The second part will consist
each of the particular
man 119
possible when you are searching databases
parts to reports 1A, IB, and 2. The first part
your selection criteria and are linked using
of the facilities that meet your criteria within
but ha e not been linked using FINDS. Data in the
second, but facilities may.
first section will not be repeated in the
Note that all the facilities in the second section were selected because they fulfill only
the criteria that pertain to a particular database and could not be linked using FINDS.
For example, if you form such a query looking for facilities that are violators of both
the Clean Air Act and the Clean
contain all air violators and, separate!;
provide the link, you will have to
integrated data.
- 9 - —
Act, the non-linked part of the report will
all water violators. Since FINDS does not
illy correlate the facilities in order to obtain
8.2.2 The SELECT Statemen
The SELECT statement is the core of
allows you to specify the database(s)
you want IDEA, to test for. The S
selection criteria for the query will
follow the INPUT statement and
Type SELECT after or below the
Keyword query. This required statement
want IDEA to search and the information
keyword tells IDEA that the facility
The required keyword SELECT should
ly precede your Keywords search criteria.
statement.
8.2.2.1 Choosing a SELECT Database
As described in Chapter 2, the IDEA
databases. You must first enter the
before entering other selection
description and their IDEA
criteria.
system integrates information from several
cfode for a database you want IDEA to access
These databases, along with a short
abbreviations, are listed in Table 8-3 below.
IDEA
-------
Table 8-3. Database Select Codes
IDEA
Abbreviation
AFS
CER
DCK
DUN
FFI
FIN
LOT
NCB
PCS
RCR
SET
TRI
Database
AIRS Facility Subsystem
CERCLA Infonnition
System
Civil Docket
DUD &. Bradstreet Marketing
Index
Federal Facilities Index
System
Facilities Index System
Contractor Listing Docket
National Compliance Data
Base (for FIFRA,
TSCA, EPCRA 313)
Pennit Compliance System
RCRA Information System
Site Enforcement Tracking
System
Toxic Chemical Release
Inventory
Description
Information regarding airborne pollution in the
U.S. The AFS contains emission and
compliance data on individual facilities.
Information regarding the official inventory of
CERCLA sites, including enforcement, financial
and rile/incident data.
Tracking system of enforcement case activity,
including court-related information, violation,
and penalty data.
Information regarding corporations and their
locations, parent-subsidiary relationships,
industrial classification, and sales figures.
Information about environmental regulatory
projects that target federal facilities, including
compliance status and budget data.
A computerized inventory of facilities under EPA
regulation. Provides facility EPA ID numbers as
well as pointers to other databases.
Information on contractors that have been listed
as ineligible for EPA contracts under CAA and
CWA.
Compliance data under FIFRA, TSCA, and
EPCRA 313 including inspections, case reviews,
and enforcement actions.
Contains permit compliance and enforcement
information under NPDES of CWA, including
inspection data, facility data, monitoring
information and description of outfalls (pipes).
Contains tracking of RCRA handlers and
information on compliance monitoring and
enforcement, corrective action, handler IDs,
permitting, and facility management planning.
Contains tracking of the names and addresses of
PRPs who have been issued CERCLA 104
•general* notice letters, or CERCLA 122
'special" notice letters, date of letters, and
Notice Letter Addressee name and address.
Information on manufacturing facilities that
release manufactured toxic pollutants; data
concerns pollution prevention, chemical uses, on-
site chemicals, and waste treatment.
User's Guide
8-9
-------
After the word SELECT, enter a three
letter code for the database(s) that you want
IDEA to search. For instance, if you wpuld like to query information from the Toxic
Chemical Release Inventory, you would type TRI after the INPUT and SELECT
statements, like this:
INPUT LINKED
SELECT
TRI
8.2.2.2 Choosing a SELECT bata Element
Directly after the database code is entered, type a period (.) followed by the data
dement code.
The data element is a multi-character code that tells IDEA where to look for the
information you wish to test for. Each database has a large number of data elements
that are available for selection. For instance, in the TRI database you may select
TOD to search according to chemical: D numbers or RFYR to indicate the chemical
reporting year. In RCRIS you may sel set, for example, HUSML to search for small
quantity generators or WAMTT to inc icate waste amounts in tons. These specific
elements are listed in Appendix C: Data Elements in IDEA Shadow Files in the Data
Element column. Only data elements which have been indexed may be used in IDEA
queries (refer to the Index column in Appendix Q.
The specific codes, dates, amounts, eft:. are called data values and will be explained
in Section 8.2.2,4, Providing SELEC.r Data Values. Before these can be entered
however, you must first include a Boolean operator (see Section 8.2.2.3, Using a
Boolean Operator).
8.2.2.3 Using a Boolean Operator
At this point you -have already told IDEA which database to search and which data
element to focus on. To complete your SELECT statement, and be more specific at
the same time, you will have to include a data value or values. The Boolean <
employs Boolean logic to tell IDEA ejxactly how you want it to search for the data
value you have specified.
Leave a < Space > after database.dat ^element and type in the appropriate Boolean
operator.
8-10
IDEA
-------
IDEA currently uses seven Boolean operators. These operators and examples of their
use are presented below. The first two operators, EQ and NE, are concerned with
definite values. The other five deal with ranges of values based on less than, greater
than, or in between status.
EQ M
The EQual operator tells IDEA to select all facilities that have a data value equal to
the one you have specified. In other words, EQ is only used with definite values.
For example, if you typed in the following SELECT statement
SELECT
TRI.TOD EQ 000108883
IDEA would select all TRI releasers of the chemical with this ID number, which is
toluene. IDEA also allows you to search for more than one data value at a time
within the same data element To do so, you must separate the values by a comma.
IDEA performs the search by placing a Boolean OR between the values you list In
other words, IDEA will retrieve the names of all facilities that fulfill the first data
value OR the second OR the third. For example, if you wanted to search for all
facilities that release toluene (TRI code 000108883) or xylene (TRI code 001330207)
or trichloroethylene (TRI code 000079016) then you would enter the following
SELECT statement (note: the "=" sign may be used interchangeably with EQ):
SELECT
TRI.TCID - 000108883, 001330207, 000079016
In this case, IDEA will search for all TRI releasers of toluene OR xylene OR
trichloroethylene.
NE
The present and Not Equal operator tells IDEA to select all facilities that have a data
value that is present and not equal to the value you have specified. In RCRIS, for
instance, you can choose to search for facilities in the State of Pennsylvania by using
the data element LSTATE set equal (EQ) to PA. On the other hand, if you were
interested in searching for RCRIS facilities that were not in Pennsylvania, then you
could type the following SELECT statement:
SELECT
RCR.LSTATB NE PA
IN
The Excludes operator tells IDEA to select all facilities that have a data value that is
included in a range of values that you specify. The IN operator allows you to
perform an indefinite search. For example, if you typed in the following SELECT
statement
User's Guide 8-11
-------
SELECT
RCR.WAMTT IN 100, 1000
IDEA would select all RCRA facilites that produce amounts of waste that fall
between 100 and 1000 tons. You are required to separate the values by a comma,
putting the lower value first and the higl ler value second (IDEA will not automatically
check for proper arrangement).
LT
Than operator tells IDEA
The present and Less
value Oat is present and less than the
search for any RCRA facility that
write the following SELECT statemen
produced
to select all facilities that have a data
value you have specified. For example, to
less than 1000 tons of waste, you could
RCR.WAMTTLriOOO
LE
The present and Less than or Equal to
operator tells IDEA to select all facilities that
have a data value that is present and less than or equal to the value you have
specified. So if you wanted to search Wall RCRA facilities that produce 1000 tons
following SELECT statement:
of waste or less, you would write the
SELECT
RCR.WAMTTZ£ 1000
GT
The present and Greater Than operator tells IDEA to select all facilities that have a
data value that is present and greater than the value you have specified. So to search
for all RCRA facilities that produce over 1000 tons of waste, you would write the
following SELECT statement:
SELECT
RCR.WAMTT GT 1000
GE
The present and Greater than or Equal to operator tells IDEA to select all facilities
that have a data value that is present and greater than or equal to the value you have
specified. Thus, if you wanted to se irch for the names of all RCRA facilities that
produce 1000 or more tons of waste, you would enter the following SELECT
statement:
SELECT
RCR.WAMTT GE 1000
8-12
IDEA
-------
The operators LT, LE, GT, GE, and NE tell IDEA to evaluate only data that is
present. In other words, when these operators are used IDEA, will ignore any data
field that is left blank, even if the absence of data has an implied meaning. For
instance, the major discharge indicator (MADI) Meld in the PCS database is blank
unless the facility is a major discharger, in which case an M is stored. A blank in
PCS for MADI implies that the discharger is a minor, but no blanks are stored in the
PCS shadow file, or any IDEA shadow files.
IDEA retrieves all its data from these shadow files, which are copies of the original
databases. The shadow files preserve the data intact; however, in order to conserve
computer storage space, blanks or missing values have been excluded.
How, then, can you select a minor facility in PCS when the keyword statement
PCS.MADI=blank is not valid? In this case you could use the operator NOT to
select all facilities that are not equal to M:
SELECT
JVOrPCS.MADI = M
Since a minor facility is any one that is not M, the NOT operator gets the job done.
IDEA is not counting the blanks in this case. Instead, it is eliminating the facilities
that have PCS.MADI = M and counting the ones that are left (Le., the ones that are
not M).
The operators LT, LE, GT, and GE are also dependent on the presence of data; that
is, they also ignore blank data fields. NOT can be used to accurately count facilities
that are not equal to a value, as in the PCS example above, but the same cannot be
done when the operator calls for less than or greater than. Nor would NOT be
accurate if the blanks were the result of missing information. Keep in mind that
when a data field has a blank or missing value, nothing can be assumed about what
the real value may be and, consequently, it is neither greater or less than any value
you select.
8.2.2.4 Providing SELECT Data Values
The data value is a more specific classification within each data element. Each
database has its own list of data elements and corresponding values that you can
reference before forming your query. Appendix C: Data Elements in IDEA Shadow
Files lists SELECT value types, but does not currently list the actual values which
could be used in a query. For this information refer to Appendix B: Database
Descriptions which lists User Support numbers for each database used by IDEA or
refer to the database's data element dictionary.
User's Guide
8-13
-------
Some examples of data values were
Other examples are ZIP codes,
significant violator status, Standard
enforcement actions, amounts of waste
I'resented in the SELECT statements above.
two-letter state abbreviations, chemical codes,
Industrial Classification codes (SICs), dates of
releases, etc.
When you have finished composing yoi^r SELECT statement it should have the same
format as the following expression:
SELECT
database.data_element Bootean_operator datajralue
This is the basic format for any S!
ELECT
statement.
8.3 Using Boolean Connectors in a Query
The true power of IDEA comes into focus when you begin to form queries that
request information from more than one data element or database. To form these
more intricate queries you will have to learn to use Boolean ORs, AMDs and other
connectors, as well as parentheses.
OR
The Boolean OR tells IDEA to retrieve! a facility record if it fulfills one criterion OR
a second criterion, OR a third, et;. Use the OR as a connector between
database.data_element expressions. IDEA interprets commas between data values
as ORs, so spelling out OR is not necei sary when you are setting value criteria in the
same data element.
To demonstrate, let's say you are sear ;hing for all RCRA facilities that are either in
the transporter universe or the land di sposal universe. The data elements for these
criteria are HUTRAN and HULAND, respectively, and these criteria are selected by
typing X after the = sign. So, remem wring to insert the Boolean OR, the SELECT
criteria would look like this:
e
SELECT
RCR.HUTRAN = X OR
RCR.HULAND = X
The same can be done between databases; for instance, if you wanted to search for
facilities that are either fully regulated RCRA generators (HUFUL) or are NPDES
"major" dischargers the SELECT statement would be as follows:
8-14
IDEA
-------
SELECT
RCR.HUFUL = X OR
PCS.MADI - M
AND
The Boolean AND is a handy tool to use when you are performing very specific,
targeted searches. AND tells IDEA to retrieve facility names only when they fulful
all the specified criteria, i.e., the first criterion AND the second AND the third, etc.
AND is used as simply as OR, by inserting it between search criteria. AND may be
used between databases; for instance, if we change the search above to all facilities
that are fully regulated RCRA generators AND NPDES "major* dischargers:
SELECT
RCR.HUFUL = X AND
PCS.MADI = M
Additionally, the AND may be used between data elements within same database,
when commas (ORs) are not appropriate. Let's say for instance that you are looking
for all TRIS facilities that produce both toluene AND trichloroethylene:
SELECT
TRI.TCID - 000108883 AND
TRLTCID - 000079016
Use the Boolean connector AND between "database.data_element Boolean_operator
data value" statements in order to select facilities according to one criterion AND a
second criterion AND a third, etc.
Using Parentheses in a Query
IDEA prioritizes the logical operators present in a query. This mechanism causes
IDEA to process some parts of a query before others. IDEA will consider
information between parentheses first, then it will consider ANDed criteria, then it
will consider ORed criteria.
You can use parentheses to instruct IDEA to consider any.criteria inside the
parentheses before the rest of the query.
Use parentheses around an expression in the SELECT statement if you
want IDEA to consider the expression first.
User's Guide * 15
-------
You can see how in the following exjunple: Let's say you are searching for all
RCRA facilities in the State of Pennsylvania, LSTATE = PA, that are fully regulated
generators OR release toluene: j
SELECT
RCR.LSTATE = PA AND
(RCR.HUFUL - X OR TRI
TOD = 000108883)
To see the difference that parentheses can make, switch the parentheses to cover the
first two segments of this statement:
SELECT
(RCR. LSTATE
OR TRI.TCID
PA AND RCR.HUFUL = X)
000108883
This search would give you a much different list of facilities since IDEA would call
up all facilities that are either fully regulated RCRA generators in Pennsylvania OR
release toluene. |
While the SELECT keyword provides the core of a query, several necessary
components of the Keyword query aip still missing. The following sections will
introduce you to these keywords.
Output Report Selection
The keyword OUTPUT is another
OUTPUT statement must
about the query
necessary component in your query. The
immediately precede the keywords that provide directions
report format (REPORT) and its destination (PRINT or DATASET).
It can appear before the INPUT stater lent or after the SELECT statement.
Figure 8-5 offers a brief description of the report formats currently available in
IDEA. Refer to Chapter 10, IDEA Standard Reports for more detail.
Once you have chosen a report
the desired format (1A, IB, 2, or
by repeating the REPORT keyword fc
reports IB, 2, and Summary, the
| type REPORT followed by a < Space > and
IY). Multiple reports can be generated
I by another format. For example, to get
line should look like this:
OUTPUT REPORT IB REPORT 2 REPORT SUMMARY
Each report may be directed to a
saved in a dataset. Section 8.6,
diff srent destination: your terminal, a printer, or
Spec fying Report Destinations will tell you how.
8-16
IDEA
-------
IDEA Reports
There are currently four standard IDEA reports: 1A, IB, 2, and Summary.
REPORT 1A
A brief report of individual facilities. Organized by the linked database, IDEA
displays the facility name and database identifier, location and other business
information, noncompliance or violation status, and enforcement information.
REPORT IB
A more detailed presentation of. information on individual facilities, including
historical and programmatic data such as dates and results of inspections, specific
toxic substances reported, and details of enforcement actions.
REPORT 2
A linked docket table that indicates whether each facility is listed as a significant
noncomplier or high priority violator.
REPORT SUMMARY
Provides total facility counts by program and EPA region; sum of facilities that are
in compliance and not in compliance by program and total numbers of enforcement
actions by program; and total toxic substance release information for the selected
facilities.
Figure 8-5. IDEA Standard Report Formats
8.6 Specifying Report Destinations
The default output destination for your query report(s) is your computer terminal. If
you want to see your report before printing or saving, then you do not have to
specify a destination after the OUTPUT statement. You will then have the option of
saving or printing when you view the report(s) (see Section 8.9.1, Viewing the Query
Report). Simply type SAVE or PRINTO at the COMMAND prompt, press
< Enter >, then answer the prompts on the PRINT/SAVE PARAMETER SCREEN that
appears. This method of printing and saving reports is explained more fully in
Chapter 10, IDEA Standard Reports (see Sections 10.3 and 10.4).
If you do not wish to view the output at your terminal, but prefer to print it
immediately or save it directly to a dataset, you must use the keyword(s) PRINT
and/or DATASET in the output statement of your Keyword query. These two
keywords are discussed in the following paragraphs.
User's Guide
8-17
-------
Note that you may only specify one output destination - your terminal (default), a
printer, or a dataset - per REPORT statement. For example:
OUTPUT REPORT 1A REPORT 1A PRINT
This OUTPUT statement will send one copy of Report 1A to your terminal screen
and one copy to be printed.
PRINT
To print a report, type the keyword; PRINT on the OUTPUT line after the report
specification. If you would like to print multiple copies of the report, then type
PRINT COPIES X and substitute the number of copies you want for X.
After you ran the query as described in Section 8.9 and return to the EDIT SCREEN,
a message will appear at the top of the query saying "Your batch job is JOBxxxxx"
where xxxxx will be a 5-digit number. IDEA will have sent the requested report(s)
to a HOLD queue to await further instructions. You must then let the system know
to which printer you want the output to be routed by using the System Display and
Search Facility (SDSF). Take the following steps to release your print job from the
HOLD queue:
1. To access SDSF, type SDSF at the COMMAND line of any Keyword screen.
This will bring up the SDSF PRIMARY OPTION MENU SCREEN pictured in
Figure 8-6.
sowu
j--' tyvff ™
1ES2 f nput
: (E« output queue.-
th* 4ES2 ft****-* ' „,,-, s- >, %'';
A * ' O * , *' "" "" ^ j> ' ^ w»s
- \/ *ct^
N> . ; -,"Af" '"'
Figure 8-6. SDSF Primary Option Menu Screen
8-18
IDEA
-------
2. Type O at the COMMAND prompt and press < Enter > to "display jobs in
the JES2 output queue." Look for your user ID and batch job number
(JOBxxxxx) under the JOBNAME and Jobid headings, as in Figure 8-7.
OJTW Alt' cusses
****$'.'* .
Att few* > uitfs *« use t-
'.'' 'C far* pqi' OC« Write*- . 1
SCWH.t
cds
892
Figure 8-7. SDSF Output Queue
Press to move the cursor down to your print job, then over to the
DEST column. The text should read R255, which simply means that your
print job is in the HOLD queue. Type the identification number of the printer
at your site or one of the options listed below over R255, and press
< Enter > two times.
Destination options:
WIC Prints at the Washington Information Center (WIC) at EPA
Headquarters, Washington, DC.
LOCAL Prints at the National Computer Center (NCC), Research
Triangle Park, NC.
RMTO Same as LOCAL.
R + RP# Prints at the designated remote printer. Here RP# is the ID for
the remote printer. To view a list of the remote printers
available to IDEA users:
User's Guide
8-19
-------
A. Exit IDEA and type ISPF 3.4 at the TSO READY
prompt. The DATA SET LIST UTILITY SCREEN will
appear.
B. Type JUSD.REMOTE.DATA at the DSNAME
LEVEL prompt; press < Enter >. The DS LIST
SCREEN will appear.
C. down and type B (Browse) next to the
JUSD.REMOTE.DATA member. Press < Enter> to
view the list of remote printers.
D. When you are finished, use the RETURN command
(PF4) to go to the ISPF/PDF PRIMARY OPTION
MENU. Type X to return to the READY prompt.
The first time you press < Enter > in step 3 a message reading
COMMAND ISSUED will appear in the upper right hand corner of the
screen, and the printer destination you just typed in will change back to
R255. Don't panic! When you press < Enter > the second time, the
correct destination will again be displayed. (Compare Figure 8-8 with
Figure 8-9.)
SOSf OUTPUT Alt CUSSES *U FORKS
COHMMQ
LIMES
COMMAWJ
$t*ou
PACE
«t> JQWUWE Jobfd OtfSt ' CftmFOE DCS Writer T«t-*Cds Status Oevlc*
JC8»7Z2t *25? : ASTO
Figure 8-8. SDSF Output Queue - "Command Issued"
Figure 8-9. SDSF Output Queue - Print Destination Changed
8-20
IDEA
-------
If you decide not to print your job, type a P (Purge) under the NP column on
the line of the job you want to cancel; press < Enter >. Warning: a purged
record can not be recovered.
4. To exit SDSF, use the END command or PF3 two times. You will return to
the Keyword screen from which you issued the SDSF command in step 1.
DATASET
To save a report directly to a dataset, the output line must specify the report type,
the library, and the name of the member in which the report is to be saved. On the
OUTPUT line, type REPORT, specify a format, then type the keyword DATASET
followed by the dataset name. Since IDEA will automatically prefix your dataset
name with your user ID and account number (UIDACCT), you must either:
(A) not specify your user ID and account number on the OUTPUT line
e.g., type QUERY.REPORTS(MEMBERNAME)
or (B) enter your user ID, account number, and membername with single
quotes around the entire character string
e.g., 'UIDACCT.QUERY.REPORTS(MEMBERNAME)'
The dataset you specify may be NEW or OLD. By default, IDEA assumes that it is
NEW (i.e., that it does not yet exist and must be created). However, if you wish to
overwrite an existing dataset, you must type OLD after the dataset name. For
instance, let's say you want to save Report IB to an existing library called
QUERY.REPORTS and you have decided to name the member SEARCH1. Your
OUTPUT line would resemble the following:
OUTPUT REPORT IB DATASET QUERY.REPORTS(SEARCH1) OLD
If the data set you wish to overwrite does not actually exist, IDEA will give you an
error message and you will have to delete the OLD status to save the report.
8.7 Adding Comments to a Queiy
To identify your query in a way that is understandable and easy to read, you can add
comments that will not be a part of the query for processing purposes, but will
remind you of the query's contents. To do this, simply type the two characters /*.
The sequence /* makes IDEA ignore anything to the right of the two characters on
the same line. Comments can appear anywhere in the query, on separate comment
lines or on the same line with executable IDEA expressions.
User's Guide 8-21