United States Office of Enforcement and 3OO-B-9G-OOS
Environmental Protection Compliance Assurance March 1996
Agency Washington, DC 20460
&EPAI IDEA Basic Training
Course
Student Booklet
Integrated
Data For
Enforcement
Analysis
-------
-------
Disclaimer
The information and examples contained
within this manual are strictly for training
purposes, with no basis in fact regarding any
actual or ongoing enforcement initiative(s).
The "screen shots" and examples that appear in
this manual are only intended to illustrate the
uses and functions of IDEA and do not contain
enforcement sensitive information.
-------
-------
Preface
The IDEA Basic Training Student Booklet is designed to provide
step-by-step instructions for individuals who want to become IDEA
users. This booklet includes instruction on IDEA processing and
the NCC/IBM (mainframe) environment. Previous experience with
the mainframe is not necessary. In depth information about the
topics presented in the IDEA Basic Training Student Booklet can be
obtained from the IDEA User's Guide.
The IDEA Basic Training Student Booklet was originally designed
to accompany the instructor-led IDEA Basic Training Course. It
has been revised as a self-paced workbook.
Additional information can be obtained by contacting:
EPA's Office of Enforcement and Compliance Assurance
IDEA User Support and Training
401 M Street, SW (M/C 2222-A)
Washington, D.C. 20460
Telephone: 9:00 am - 5:00 pm, Eastern
Monday through Friday
202 564-2475
-------
-------
Table of Contents
Student Exercises 1
Logging on to the Mainframe 1
National Computer Center Menu System 1
EPA TSO Logon Menu Screen 2
IDEA Welcome Screen 3
Running a Menu Interface Query 4
Interface Selection Screen 4
Main Menu Interface Screen 5
Location Menu ... 6
Pollutants Menu 9
Noncompliance Menu 13
Three Search Types 16
Input and Report Selection 16
IDEA Standard Report Formats 17
Query Status Screen 18
IDEA Report 1A in Browse Mode 19
ISPF Commands for Navigating IDEA Reports 20
Print/Save Parameter Screen 21
Running a Keyword GO Names Query 24
Interface Selection Screen 24
Input Library Selection Screen 25
Member List 26
Member List Commands 27
Edit Screen 27
Name Selection Menu 28
Name Selection Menu Returns 30
GO Names Keyword Query 31
Report Syntax and Query Execution 33
Query Status Screen 34
Report 1A in Browse Mode 34
ISPF Commands 35
Using Your Home ZIP Code in a GO Names Query 36
Editing a GO Names Query 37
Interface Selection Screen 37
Input Library Selection Screen 38
Member List Selection Screen 39
-------
Edit Screen 40
Name Selection Menu 41
Name Selection Menu - Counts Returned 41
Name Selection Menu - Return Names Selection 43
Edit Screen - Names Returned 44
Edit Screen - Block Copy Line Command 45
Edit Screen - CUT Command 46
CUT Default Values Screen 47
Member List Screen - Creating a Member 48
Edit Screen - PASTE Command . . 49
Edit Screen - Exclude (EX) Command 50
Edit Screen - Delete Not-Excluded (NX) Command 51
Edit Screen - FIND ALL Command 52
KODAK Facilities Retrieved 52
Copy LOGIC Member 53
Executing the GO Command 54
Query Status Screen 55
Summary of GO NamesCommand 56
Running a Keyword GO MenuA Query 57
Member List Screen - Create Member 57
Edit Screen - GO MenuA Command 58
Main Menu Interface Screen 59
Noncompliance Menu Screen 60
Main Menu Interface Screen - Noncompliance Keywords
. 61
Input and Report Selection Menu 62
Edit Screen - Noncompliance Keywords 63
Edit Screen - Block DELETE Command 64
Edit Screen - Noncompliance Keywords 65
Edit Screen - COPY Command 66
Query Status Screen 67
Summary of GO MenuA Command 68
Combining GO Names and GO MenuA . 68
Summary 69
Logging Off 70
Log and List Data Set Screen 71
-------
Student Exercises
Logging on to the Mainframe
IDEA is accessed through EPA's National Computer Center's (NCC) mainframe
computer. Logging on to this system requires a user ID and a password. Once logged
in, you must indicate which facility or program you intend to use.
Indicate that you want to go to TSO by typing T at the COMMAND line as shown
below:
Bate* ....
s
w , Tsttolaati T2515311
'" MeS^-^fter jS**ป6t?fflft ซf *M*na6d *6tf tfcm frirซi* iffitratic',^ / , \ " ^, ''*
,-%% 5- ^ ' "V --.> -, \ ,% -- - - ""- ..<<"< - - %^" -; - ,-
> /'K |^|!Oitซ?JQซ -"IfeU^M^tp tog ซfcsrปBm6$ "- "' *" " - ,""-" -*"; "- - -
fa* 3278
-- , " 4, jtePUB
<', > - 5>. JปTSR:*
to a
td 18 >
Figure 1. National Computer Center Menu System
The menu system will then present you with the EPA TSO LOGON MENU SCREEN
(see Figure 2). At this menu screen, you identify who you are, what account is to be
billed for your computer session, and set several user parameters. Once entered, the
computer establishes a profile and "remembers" all the parameters for the next logon
session. Figure 2 indicates the required parameters.
Student Booklet
-------
figure 2. EPA TSO Logon Menu Screen
The required fields are:
1. User ID: three characters; issued by TSSMS Office.
2. Password: six to eight characters with at least one number.
Procedure: use $EPATSO
Account Number: four characters; issued by TSSMS Office
FIMAS: five characters; use ffiSYP
3.
4.
5.
6.
Bin Number: four characters; from your ADP Coordinator,
or use M*** where *** is your User ID.
The first time you logon, you must change your initial password by tabbing to the
NEW PASSWORD input field and entering a new password. You will be asked to re-
enter this new password to confirm it.
For any logon session, you have only three opportunities to enter your password.
After the third attempt, your user ID will be revoked.
IDEA
-------
When you have successfully logged on, you will see a series of NEWS ALERT
messages followed by the TSO READY prompt.
At the READY prompt, type IDEA.. Press < Enter >. The IDEA WELCOME
SCREEN will appear (see Figure 3).
,
" ' - * "' '
- * -
_. t ?._ _ _._._._ _ *" !:___"_ _. *'.
%v % --.s
8-
fy-y'*- y- "
Figure 3. IDEA Welcome Screen
To move to the INTERFACE SELECTION SCREEN, press < Enter >.
Student Booklet
-------
Running a Menu Interface Query
The easiest way to build a query is to use the IDEA Menu Interface. This interface
allows users to scroll through different categories and select criteria to be used in a
query search. This section will focus on navigating the IDEA Menu Interface.
Queries developed using the Menu Interface can range in scope and complexity from a
broad one-category, one-database search to a very specific six-category, eight-database
search.
To access the Menu A Interface, type A at the ENTER INTERFACE OPTION prompt
which appears at the bottom of the INTERFACE SELECTION SCREEN (see Figure 4).
Figure 4. Interface Selection Screen
Upon selecting the IDEA Menu Interface option, the screen shown in Figure 5 will be
displayed.
IDEA
-------
Patiutarafrs
\f-'
s
<< *
ฃ01
'/ . ,
Figure 5. Main Menu Interface Screen
As an illustrative example of a targeting query, we will use IDEA to develop a list of
candidate facilities for a pollutant-based enforcement initiative (this is strictly a training
exercise, with no basis in fact regarding any actual planned or ongoing enforcement
initiative(s)). The enforcement candidates will be those facilities in Virginia and
Maryland that are currently tracked as "Significant Noncompliers" and which also
reported toxic chemical releases (according to TRI) of lead in an amount greater than
10,000 pounds in any reporting year.
In order to find facilities located in a particular region, ZIP code, state, or county,
select the LOCATION category by placing your cursor on the underscore mark to the
left of the word "Location," and typing S, followed by (see Figure 6).
Student Booklet
-------
+ -K H-.+ -4C*v Hvt + -K Hv+ + -h H
iv"ปg?r ;> ',,,..
&ป^.;.Kฃ^' **
^NV 'ซ >
\-"- viw' f> ~y~ * .. f *. - -
".. _ .rX^ "* -*,v.v v-l
--" *-- *- - "" v % S . V~
. *" - %., r
rci*ซ.wf*"*$ ft% % .0"*" *"'"-.
^tv.f'x?>s|-o\ *--.< -^- V
,,-, , ?*- s^^t^ *-x; - <" ,--"' ?- ' ~ ~
\Vn ettefy "\ / k > ',
iซ'^r^rr.:f :;x ^;^
-, - <
Users'
+ + 4v K-^- 4- +t H>H- 4- -K H-/4- 4- +C>4-
Figure 6. Choosing the Location Menu
Selecting LOCATION will prompt a new screen to "pop-up" on top of the Menu
SCREEN (see Figure 7).
wm x ? * *x- * -- -; ^^ -x - w*
:*ซ\. y'"i' ,"\ "V'.' ซ "'- ^. .M
f^^ป^v^Vi*<-H-*S-K'liV*.ii<*-4.*S!Ht**-irH-j.*4< toซiS't':t dfe ** R!* *M * * *" "*f"My* *'* ^ * "V* * ".'< '
%g$8Z* ^ซta*>iฅ^i'ปfttปiM^Wilt*,li //''---' -"' 'ซt - '- , -
*^f^>tป;it^6nt^ ^- x ซUME ;% , ,V* ' ' '-si,V' "'-
s-^>? "-X ^ ^ -t ?ซ>^.-. ซ -.-^ i-i'-*ซ.ป -A* I-.T-. *** **>f. y*^ *!* ** ซ* ** ซ* *fft*e.-ป. *** **. ซ-^* ซ--^ *^J *.^ *' *ซ.- *" *^> ^ " X _. _.
.sX \\ -, " k \ \ ""^^ \ < ,-v % ?f ' f -.'' s'' s *!* f
ซ.TJ.S.;- ?^s>. T ป*> ^ %-': sv%<* .. ^ ^ % , .f *
^ซti |;B0r^ -- ^ ^ -- ^-f m ~^M- ' $w* * *ซ&<**? - ^ t* ^ ~-
*ffij$.1^- CxC >t ?" ^ >* , L;L.~ ^'<*^b^,%&i*$bf ; *' s"'/
ISS^f-.^ &; ^^SfS^ft ' J^' '??C ' * ..;tf'....;.... .., ..,''ปป, iin-Anii'i-'r;iii>''niir-''"'%-'JJ * '
i,C_Ji!j!iv*.--S.*u. X >i . . % ' -ir -' TV ***ซ'ปป"*****? ซS(" '*ml ~T* TT" ~T /, ฑ j.^ .
toSGm.^
'.'' &&W&
Jfi&iywmwr"'' -, -
^i^flitSf Stat^t
(&Ve:
^*^,VA* Kป **,*'=; *; *? *f^"
\ \ '""v- '
*- 4^-" > *ฃ* * *
Figure?. The Location Menu
-------
Up to ten states can be selected in the LOCATION menu. To select a state, place the
postal abbreviation on the underscore line after STATE =.
Move the cursor back to the FINISHED? (Y/N) prompt using the key and
type Y. Figure 8 illustrates what your screen will look like once a state has been
selected.
WtmtW'"V" ',''-'" ' ' ' JtJฃ* ,,//, " ' - ***** ''ฎm
- % ^ % -ฑ
*: '
't % %'
"^" 4**vv- i****^ >****^ f.'- ฅ"'' ^
v T ' 'w
t , ซ
t
^ H-> +.* H-.+-+ K W#
ป
* ^
4- -H K-/f 4- -K K-,-f + 4\Hv* + -K H-^f +.-K Hvt +4% H-.-H--K H-^- + -
Figures. State Codes
After you complete your location selection and exit the LOCATION Menu, the MAIN
MENU INTERFACE SCREEN will look like this:
Student Booklet
-------
Figure 9. Maim Menu Interface Screen
The next step is to select the POLLUTANTS category by placing an S on the
underscore next to POLLUTANTS and pressing < Enter >. This will prompt a new
menu to appear (see Figure 10).
The pollutant we are looking for is lead; the source of the data is the Toxic Chemical
Release Inventory System. Figure 10 shows that a question mark can be placed in the
CHEMICAL CODES field to prompt a list of chemical codes to pop-up (see Figure
11). You may scroll through this list, using PF8 (down) or PF7 (up), and to
the underscore next to the appropriate code. Chemical codes can be selected by
placing an S on the underscore and typing Y at the FINISHED? (Y/N) prompt.
8
IDEA
-------
"fir-ease !
*V,| JปJ(. |
1 ,
1 T8J
Bati^Ileseftfcs
Typo*
^
tia
+ -KM ++ KM 4- + -KX +
$ I-
"Vw1-
'
-*
Figure 10. Pollutants Menu
Compare the length of the NEXT VALUE line with that of an actual data value in the
pick list. If the VALUES line is longer (as in this case), you can type a word(s) for
which you want to search on the VALUES line. IDEA will display the TRI chemical
codes that contain the word(s). In this case, type LEAD as in Figure 11.
***!ซซ.. ~rfr ~.TTs.rgr ^3. &} ^ ซ
. KK.A + * *ป<ป&!#KHvyj.ttvU.fc^ J ป!,;,,
--" -\ i" f^siiie^ J- W'J
ซr^^aw^'ซf-.(*fซftlfisi8. <ซ*,
>"'**<"*'ป4*-%^ ^
./"'"-- ซ " ^
^w''
C f f ^f^ffff
* -Of ' ',
Figure 11. Chemical Code List
Student Booklet
-------
Place an S next to LEAD and LEAD COMPOUNDS (see Figure 12). Press
to get to the FINISHED? prompt and type Y. Press < Enter >.
Cfcdest '
ife8rMbsf>^V^^ ^-! -- * xs .. , ' , - ' ,,,',>
^9K* ,*f .^X^x **.?%$ -.-^ - -'-'- ' VS\"< ,- ' "- - - ' ',*"'; '/',, -% ", '
st"$aV t "i -HV ^-^VLfx X^^>v.,r ,' / r 'V ^ ' * ^"
Si>* /**i*ซtt>'*.>, ^^"^%^'-1- tฐ% %. w '-f "err '' ' f'. . * 'i' '
^^^7$^
K-/**i ซ.H-> + -K ป+ +.-K-V(-j* + +t H-^t
*ซ.^* + '- ' '
4 +C Hv* +%-ซ H->l(+ -W H-.+ + -K H-/*- + -K W-/f ^+ -K ^
Figure 12. Lead Chemical Codes
After you exit the CHEMICAL CODES Menu, the codes for Lead and Lead
Compounds will automatically be entered into the POLLUTANTS Menu.
Next, provide the range, in pounds, of TRIS lead release. As illustrated by Figure 13,
to select those facilities releasing greater than 10000 pounds, supply 10000 as the low
end of the range, and 99999999 as the high end under RELEASE AMOUNT (in Ibs.).
10
IDEA
-------
mm
* -K Hv* + -K H- + + -K H-^- + +i rf- + + -K riv* + -K H-
,^^
Ifedluft ' * ' *
, f
fff ^ f % SS f V" ' ffff p. fr~'*f*
* K.X ป+'KJ< *+ KM *+ K X ** *"-K X- * + KM *+ KX *+^KX ป+ KX ++.KX ++..K
Figure 13. Pollutants Menu
Exit the POLLUTANTS MENU SCREEN by pressing to get to the
FINISHED? prompt. Type Y and press < Enter >.
Student Booklet 11
-------
Figure 14 illustrates what your screen should look like after you exit the POLLUTANTS
menu.
Afeaubta , mom * 99599999
figure 14. Main Menu Interface Screen
The next step is to tell IDEA to limit the search to "Significant Noncompliers." Select
NONCOMPLIANCE from the Menu Interface, and the NONCOMPLIANCE (NC)
menu will appear.
12
IDEA
-------
.
<', &ซt<ป
I laMts>---.v Sysfcem Bata Itwnenifes-
J^.,.j,4 ...._..,.,.^.,fc. ..^,fc.....^.. A.
^ ^ **"--*-'--'**ป'ซป*-'ซ**-- ->*.-*'-*-.- ป
or^more ^4 ' Z or _
^- t>
f
* - r '
-> 1
JL1KWI
*""* + ซ H-v* + -K H-+'-K H-/4- + -K44ซ- + -K H-j+-K *-* + +i,H-^- + -K H-A + -K H-/* + -K H-/+ + *v H-v* + -K K-^*- + -K H
Figure 15. Noncompliance Menu
To select significant noncompliers (SNCs), move the cursor down to each individual
media section, i.e., CAA, CWA, RCRA, FDFRA, TSCA, and EPCRA, and select the
line indicating significant violation/SNC status. Figure 16 illustrates this step.
Student Booklet 13
-------
Figure 16. Significant Noncompliance
Exit the NONCOMPLIANCE MENU SCREEN by pressing to get to the
FINISHED? prompt. Type Y and press < Enter >.
14
IDEA
-------
The MAIN MENU INTERFACE SCREEN now looks the same as Figure 17.
** , .
ป^;f:;KH%+T-ฃh%* + 4^:+^ ''
' % -HWftS , * ,
ป. S*. .*.. . . * ... .
-------
Figure 18. Three Search Types
Type
Description
Linked
Locates data about all sites with
specified characteristics through FINDS.
Nbnlinked
Locates data about all sites with
specified characteristics in individual
program office databases.
Linked
Nonlinked
Locates data about all sites with
specified characteristics through FINDS
and in individual program office
databases.
When you command IDEA to run your search, a pop-up box called INPUT AND
REPORT SELECTIONwill appear. This screen provides you with the opportunity to
choose a linked or nonlinked search and to pick up to four different Standard Reports.
Notice that the defaults are set for a LINKED search and REPORT 1A (see Figure 19).
Figure 19. Input and Report Selection
16
IDEA
-------
. .
After choosing a linked, nonlinked, or linked ndnlinked query, the next step is to select
the format for your report. Figure 20 lists and describes the four different types of
reports that IDEA can generate.
Figure 20. IDEA Standard Report Formats
IDEA Reports
There are currently four standard IDEA report formats: 1 A, 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 faculties 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 faculties.
To select a report format, move the cursor to the underscore mark to the left of the desired
report and type S. Once you are satisfied with the report format and search criteria, press
< Enter > to instruct IDEA to run your query. For example, if you want a detailed report
on your search, type S on the underscore mark to the left of Report IB and press
< Enter >. After the IDEA completes its initial facility selection, the QUERY STATUS
SCREEN shown in Figure 21 will appear.
Student Booklet
17
-------
Figure 21. Query Status Screen
The QUERY STATUS SCREEN shows the number of facilities that were selected by IDEA,
based on your selection criteria and the linked/nonlinked input qualifier.
If a facility count of zero is returned, pressing < Enter > will take you back to the Menu
Interface where you can modify your query. Similarly, if the facility count is higher or
lower than you expected, pressing the PF3 key or typing END at the command line will
return the cursor to the Menu Interface where the query can be modified.
18
IDEA
-------
If a facility count other than zero is returned and IDEA reports were selected, pressing
< Enter > will take you to the BROWSE SCREEN where you can view the reports your
query has generated. Figure 22 shows an example of IDEA Standard Report 1A. This
report contains information about facilities which meet our query criteria.
ซW^*SMfWW*ป^
J^ H661S1S7S58I5 %- "Fat* Samec Cffit
. ..
^v
Figure 22. IDEA Report 1A in Browse Mode
Student Booklet 19
-------
The following commands are used in navigating IDEA reports.
Figure 23. ISPF Commands for Navigating IDEA Reports
Commands
UP
PF7/PF19
DOWN
PF8/PF20
LEFT
PF10/PF22
RIGHT
PF11/PF23
END
PF3/PF15
SWAP
PF9/PF21
SW
MANEUVERING THE CURSOR
Arrow keys,
key to move to the next input field.
ป Use to move to the top-left input field.
Scrolls up to the first top line of a report;
Scrolls down to the last bottom line of a report;
Scrolls to the right marge of a report;
Scrolls to the left marge of a report
20
IDEA
-------
To print or save the report, you must issue a PRINTO or SAVE command on the
command line. The PRINT/SAVE PARAMETER SCREEN will pop-up. See Figure 24.
IA.-
"--"
>f ,
' for
,2
->-"--.ป*-
*< Hvf *,
a-
Figure 24. Print/Save Parameter Screen
Student Booklet
21
-------
You must supply the following parameters at this screen:
1. From line no.
2. to line no.:
Starting line number; for the entire report, always
use 1.
Ending line number (MAX).
For Printing:
3. Bin:
4. Destination:
5. No. of copies:
Four character code indicating location for the
printout.
The printer ID where you want the report to go;
default is the HOLD queue.
Default is one copy.
For Saving:
6. DSN or DSN(member)
The dataset name under which to store the report;
the default is UTOACCT.***, where UID is your
User ID, ACCT is your account, and *** is the
name (up to eight characters) you type in at the
prompt. If you want the report saved to your
library, type: QUERY.SPECS(***), where *** is a
member name that you provide.
Successfully completing this screen will return the cursor to the BROWSE SCREEN with
a message in the right-hand corner stating either: "PRINT COMPLETE" or "SAVED."
22
IDEA
-------
To return to the Menu Interface
To return to the MENU INTERFACE SCREEN, press the PF3 key, or type END then
< Enter > at the command line.
To save the Query
To save a query, select the SAVE QUERY option off the Main Menu, then enter a query
name (up to eight characters) and an optional description (up to 40 characters).
To exit the Menu Interface
To Exit the Menu Interface, press the PF3 key. IDEA will return to the INTERFACE
SELECTION SCREEN.
Student Booklet 23
-------
Running a Keyword GO Names Query
The easiest way to build a case screening query, i.e., look for only certain facilities by
their name, is to use the GO Names feature of the IDEA Keyword Interface. The
Keyword Interface allows you complete flexibility in constructing the selection criteria to
be used in your search. The GO Names NAME SELECTION MENU allows you to select
facilities based on their facility name(s) and location, then automatically builds a keyword-
structured query for you. This section of the Student Booklet, Running a Keyword GO
Names Query, will focus on navigating the IDEA Keyword Interface and the GO Names
feature.
The first step is to enter the Keyword Interface through the INTERFACE SELECTION
SCREEN. As Figure 25 illustrates, type K for the Keyword Interface at the ENTER
INTERFACE OPTION prompt in the INTERFACE SELECTION SCREEN.
Figure 25. Interface Selection Screen
24
-------
The Keyword Interface operates within a mainframe word processor. It first requires you
to tell it where to look (called libraries) for existing queries (called members), or where
you want to save new queries. The Interface defaults to a library called
UIDACCT.QUERY.SPECS, where UID is your user ID and ACCT is your mainframe
account number (see Figure 26).
' 1 - \M--^ ,,,' ^~
*.,>, - -- "'"'""', V* " -<' '- >
= ""ซ; "^ - "" "" s -"'- ', ,,*.-
Figure 26. Input Library Selection Screen
If you want to use the default library, press < Enter >.
If you want to change to a different library, type the different library name over the
default, then press < Enter >.
If you want to create a new library, make sure the library name is unique (change it i
necessary), and change the library status to NEW; press < Enter > .
if
Student Booklet
25
-------
Once the library is selected, the next screen displays the contents of the library as a
"MEMBER LIST." This list displays the member name, the date and time that it was
created or last changed, an optional description of the member's contents, and the user ID
of the person who created the member (see Figure 27).
. TO t*VS & */'
" j*'ซ. w.>
Jhtt
'"t ;- ""-, ",, "" '***" '
&W": ' '*' *' ^-"'SS- *
, , % - -,* ปuป ,- , ,
'- -- " ,i vw,,^ ;: %, ',-
^A,W*"9**S'*';>A?*r**:a1c'''*i*ftrf **ซS'<*' *ซ<ป** , ;,, ', f f,Z W*,,>, , ,, ,'
v ^%C ^5"J^?$:*''^&^5'::'' ^^'">'- s ^ x^ ' ''"' - ' "" '" ' ff '' "~ ffi^M '' '
^^A'X.*(ซ>J^>^^WJ^I^.O ''.., -^.^ '"** '^ , -. ' \ f '
-------
Figure 28. Member List Commands
B
E (or S)
R
U
D
Browse/Read the query; no editing possible.
Edit/Select an existing query or create a new one
in the editor.
Rename the query.
Update the query description.
Delete the query from the MEMBER LIST.
After you select a query or create a new query, press < Enter >. IDEA will bring up the
edit screen illustrated in Figure 29.
\ ft t't f
*****
iOTT -~ ..;';
f f f
, , * , ,
*********************'****'*** "
Figure 29. Edit Screen
Student Booklet
27
-------
As an example, we will use IDEA'S GO Names feature to search for a facility in your
area. The facility was selected at random, strictly as an illustrative but real example, for
IDEA training purposes only. For this course we will use Blue Plains as our example.
First, open a new query member at the MEMBER LIST screen by typing E BPLAINS on
the COMMAND Line, followed by < Enter >.
To access the GO Names function, use or < Tab > to place the cursor at the
COMMAND prompt and type GO NAMES. Press < Enter >.
The NAME SELECTION MENU SCREEN will appear for building a name-based query.
As Figure 30 illustrates, GO Names gives IDEA users the option of conducting a search
according to facility name, location or a combination of the two.
'$>, v,->X'
^-^r^^Xv s "- f", "' > ',, -'-^'- ',>''- '- , ^ - ff- '"''> ,
'*>'. feSSfelSye.-!-." .V* ...^ . ^-' -... \ \ <' i
grs^Mis:*!^ i$* ^ ^^i, -,**ซ*-- ;:^^ j%- /,-,-, r*v --- :
^j^^yV'^X, jซ3 -"',*' J^>V~'
^^ll^^1^^^^ ^ '^ -^v ;ซ^v-> W -i'"'- ^ J-"/
^f^l^^v-^^---^, -/-&?, r;%Viซซ^ ,^_ "a^" --,..J^'"'"', !'
: vis,. -.^.T? v. ^X^' -r"~-.-i * * ''*"*".' ff f f".fff
^^^^^-.. ~K-- ;,/,"*,- - : ' '
"-^^vj-ii^S vvt >.^-;.^ .... " " " f \ -. jf.
fff ffff 'S
Figure 30. Name Selection Menu
28
IDEA
-------
The "Name Selection Menu" options include:
1. Name: A single or multiple-word facility or company name.
2. State: A two-character postal abbreviation for a state.
3. County: A two-character state abbreviation plus a three-digit PIPS county
code number.
4. ZIP Code: A five-character postal ZIP code.
The locational criteria are ORed together and are then ANDed with name criteria. Here
is how IDEA sees this logic:
NAME and (State or County or Region or ZIP Code)
To begin, enter the name qualifier: Blue Plains (we could be more specific by using
additional qualifiers for the name and location, but this example allows us to use some of
the editor commands later). Press .
1ซ!ls*l>
Figure 31. Company Name and State Qualifiers
Student Booklet 29
-------
IDEA will then return a count of names that match the qualifiers -- facilities with words
that "sound like" Blue Plains.
_f_...
icciii i "*" .< U
A*. .# s '-?%% ^
f ?*" "?,\ ^\v5* !/"**'"^ V"% j. f ff-bf ff^-ff sff
,t**$$jk jway'b* p$m| tsgBtftftf ซrrf &ws
tft'^AStted: tfitfc .ttie .naisfe flfaov^i ,,',;,
ff^y^f-^-^'^^-i. SK,\!t '', \ >' ' ^ ^'
iiw._ t J^>WAL-ssSr^v^- \ s,y f. ,_****;?* f ****aft>
*^c
-^.v *-x^.. ^ ^ '%_. ?f f >^ ^ f / f, ' ' "< *'',
??$$''<&"'%', '"'!'?!*&',' '-ซ*"***<:,ฅ ^ *%!& ', J,' >'
' '*aปa* iปปtfc> aai*> 'att!t> v
i^" - - >/ " ' "'-"' '"'"- ! - "'% *i - '"S' 1 i
'S^KซCCN rซฃ^ " ,1***^ assa*- ^'aaawt "; mta^_ ^
^OStttfits^' ' s tssja*' ซ*ป>^ .. *ป!i*^ ' ^
iV;^ """!' $?&ป*' ''' "'' > A,. ^' %'' .' . ' 4: ,
Figure 32. Name Selection Menu Returns
A line will appear at the bottom of the NAME SELECTION MENU SCREEN asking you
to select a query building option. It reads, RETURN NAMES TO QUERY: Y(ES),
A(LL), M(AX). Your choice here will determine the level of facility name comments that
will be included in the query. Since the number of returns is small, for this example,
choose M.
IDEA will then return to the word processor, i.e., the editor, and fill it with the query in
the keyword syntax. You then look over the query, and identify the facility of interest
from the list of names. The Blue Plains records start on line number 6. Use the function
keys PF8 (down) and PF7 (up) to scroll through the rest of the query.
30
IDEA
-------
Notice the keyword syntax: an OUTPUT statement (selecting Report 1A), an INPUT
statement, and a SELECT statement consisting of the database code (FIN), the field name
(EPID = EPA ID Number), and operator (=), and then a listing of EPA ID Numbers,
separated by commas. The commas are treated as "OR"s. To the right of each EPA ID
Number are the characters "/*" indicating that everything to the right is a comment and
is ignored by the computer. Following the "/*" is the name of the facility from each
linked data system and its address.
if* 548720 1333 ซaaป& Seafซh fซ*xt
fW!l V
$-8ซ&esSฅ */'
Figure 33. GO Names Keyword Query
Student Booklet
31
-------
Since we only want records linked to the facility that we are interested in, we need to
delete the lines that contain EPA ID Numbers for other facilities. To do this, use the ISPF
block delete command. This is done by placing two D's (DD) on the number of the first
line of the text block you want to delete (see Figure 34). Move to the last line of the block
you want to delete and place two D's in the number string. Once you have completed
these two steps, press < Enter >. The editor will delete the specified lines. To learn
more ISPF Line Editing Commands, refer to Chapter 9, Managing Keyword Queries and
the ISPF Editor in the IDEA User's Guide.
Rgure34. ISPF Delete Commands
32
-------
If you want to see additional reports, type in the report syntax on line four, e.g.,
OUTPUT REPORT 1A REPORT IB (see Figure 35).
To run this query and generate the reports, type GO at the command line.
;- &t? -iwittpfe^ea^^i
* '
^ซBQ8sf, \~- --' \ -/*"*ซ
% ^iro^^
v ซ^ซซป-
: v* ซvปซtซpป!j
,, /* ; >-
s ^(ซ514
few ?
^c-
%
/*-
J9&,ซwfฑ ;>
m mm as pi {*/
' '
*/
' "
Figure 35. Report Syntax and Query Execution
Student Booklet
33
-------
From here, IDEA will process your GO Names Query and present a QUERY STATUS
SCREEN (see Figure 36).
S"!?'?t|*ฃ$,i'!>\^V.^ $< /VXV": ',,ป. ^ ,
^SsฃQSv&$ฃ'%iฃฃ&$ฃฃ&.J& jS&fg&f^tyss SX-"- "-1: ^ .'ซ' ซvซ* <. s t f ** \ f fff
?ปw
~.u..i.tป.i.vAu.t "' t ^- ^ sj^ ^ ^^^ w^,.; ; ^ -. - ' ' " *f f -.ซ s * fffS* $ ' sS's f< ป ^-X ^ ^ f
t?ฃ*pi>s*ซซ>- > -l^\t^ s - ,-J \"^ ,'- ,"'' ' ~ " .'' ' ' '',*?*< >",ซซ
%K*&3&>*'<&& -y --f'^"^ *;?- - - -
Mj; -*^;;;";'^r^^^
^M^^i^^^^^^ba^^^n^^p^^^^'''" '"' ' "'" '
^^^"^^is^tesl^fcwcdasft^fty wftro^t prwjfflst fe-ftt^j .. ^
^EJX".^ W s^.s-,t ' f f f >%>. s *.ซ.~ ป ^s <" " *\< ! " ^
<<
/S-''
iปaewป?-ป^"?'-*~f';^s^miป>s-s-\5w*w-w- " >"-^ ff ---.>> f - - -.-. r. - r .
ijs&f^-&w&&$&iฅirf?<& ?ซ f \-6j , "
%ปr-4^ftX%- 7;V"1-- ^"^ V " -"^ > \ - "S^ ' " v %' " -X: -,f >'
figure 36. Query Status Screen
The report, Report 1A, that returns might look like this:
Figure 37. Report 1A in Browse Mode
34
IDEA
-------
The following figure contains the ISP^ commands that can be issued at the COMMAND
prompt in Edit and/or Browse mode (as indicated).
Figure 38. ISPF Commands
(default values)
Command
ISPF HELP
PF1/PF13
SPLIT SCREEN
PF2/PF14
END
PF3/PF15
RETURN
PF4/PF16
REFIND
PF5/PF17
RECHANGE
PF6/PF18
UP
PF7/PF19
DOWN
PF8/PF20
SWAP
PF9/PF21
LEFT
PF10/PF22
RIGHT
PF11/PF23
RETRIEVE
PF12/PF24
FIND
CHANGE
SAVE
CANCEL
Mode
Edit&
Browse
Edit&
Browse
Edit
Browse
Edit&
Browse
Edit&
Browse
Edit
Edit&
Browse
Edit&
Browse
Edit&
Browse
Edit&
Browse
Edit&
Browse
Edit&
Browse
Edit&
Browse
Edit
Edit
Browse
Edit
Description
Displays information about the current screen.
Splits the screen into two ISPF sessions.
Saves changes and returns to the previous screen.
Returns to the previous screen.
Returns directly to the previous Primary Option
Menu.
Repeats the previous FIND command.
Repeats the previous CHANGE command.
Scrolls up by the amount set at the SCROLL or
COMMAND prompt
Scrolls down by the amount set at the SCROLL or
COMMAND prompt
Moves the cursor from one screen to the other in the
split-screen mode.
Scrolls left by the amount set at the SCROLL or
COMMAND prompt
Scrolls right by the amount set at the SCROLL or
COMMAND prompt
Moves the cursor to the first input field on the screen
and retrieves the last command entered.
Locates the first line containing a specified character
or string of characters.
Changes the first occurrence of a characters) to
another characters).
Saves your work and remains in the edit session.
Refer to the Saving Reports portion of the Query
Status Screen section.
Ends an edit session without saving any changes.
Student Booklet
35
-------
Using Your Home ZIP Code in a GO Names Query
As another example to demonstrate the GO Names utility, we will conduct a search based
on your home ZIP code. Using the key, move the cursor down to a ZIP code
field. Type in your home ZIP code.
:fiCSS'j &f'_jtiia& s *"*s ttฃa&- saw*
M*ar*"'/'i*M?~ "aas^r ^ ^^u
Figure 39. Using Your ZIP Code in GO Names
Once you have entered your ZIP code, press < Enter >. IDEA will return the number
of facility counts associated with your ZIP code. You may now choose how much
information you want to see in the Keyword editor. Y will return facility names and
FINDS ID numbers only. A will return facility name, FINDS ID numbers, and addresses.
M will return each name and address associated with a particular FINDS ID number.
Enter Y, A, or M on the RETURN NAMES TO QUERY: Y(ES), A(LL), M(AX) line.
Press < Enter >. IDEA will now return facility information from your ZIP code to the
Keyword editor. Type GO on the COMMAND line to see a report on these facilities.
36
IDEA
-------
Editing a GO Names Query
'*ป<
-news
,/,,
Figure 40. Interface Selection Screen
From the INTERFACE SELECTION SCREEN, press < Enter > to use the Keyword
Interface. (Note: this accepts the default value ofK - Keyword Interface). The INPUT
LIBRARY SELECTION SCREEN appears.
Student Booklet
37
-------
Figure 41. Input Library Selection Screen
From the INPUT LIBRARY SELECTION SCREEN, press < Enter > to move to the
MEMBER LIST SCREEN (see Figure 42). (Note: this accepts the default library specified
in the LIBRARY NAME prompt.)
38
IDEA
-------
* mmm
SfcMJSM&Z*
--5
ff ff f'f % _ _ t " f"*>fffjrtff Vฐ " : ...... jv-s
"", "--? * ""x " " s '' ", , ' ,
%%v _ %-. ,AWปf ^ป^,,,
^^ \ % '% ' %'^ "*< ^ , ' ' '' v-.: '
,f s$?sS~'~ ^ " * * ^v ff>ffffVf -. v ^ vw. ^ ^
4 s ' -Aft*' "'. '. - -.-. s , "/ ^'.,.
, " ' % TO v. ^ ~ ~ <
* ". -, ,-.<
ffปfff *-ff-r&*. ,
-%"\ "ฃ"f, "<.
ffff f f -^ If f f ^ ^
Figure 42. Member List Selection Screen
From the MEMBER LIST SELECTION SCREEN, create a new member for saving a GO
NAMES query on Eastman Kodak Corporation. At the COMMAND prompt, type E
KODAK. Press < Enter > to move to the EDIT SCREEN (KODAK) (see Figure 43).
Student Booklet 39
-------
OF O.S?A ***********************^******.-- '*
Kgure43. Edit Screen
From the EDJTSCREEN(KODAK), type GO NAMES at the COMMAND prompt. Press
to move to the NAME SELECTION MENU SCREEN (see Figure 44).
40
IDEA
-------
v.,*teirซ i
,
names irfwrt
- /
that
anct
ซ '
A-A- f A ATAV
^KvjV " .-.-.-. ^ V. w{
Figure 44. Name Selection Menu
From the NAME SELECTION MENU SCREEN, type KODAK at the NAME prompt.
Press < Enter >. The NAME SELECTION MENU SCREEN returns with the number of
names selected (see Figure 45).
w
f iisy.1. , VAV. % jfaf, -~f f .. 'fff.v.-, * f *y-f'f'f >ป*
\. feesfifflS.'-'' % ABWW^ m^aiat&- WปSP>
>X ^ ^ ^.i* -.N^s^ > ซ,..
^V^ ^v %% '"~f ffff "~
-.-. V^WBB^ ^ ^
,//,^' ,x^' /v^99jMtt^|^^M ,^,'
-. ' .,,:,, , $ ' v. f -^ l- . .. V '
^^ astatx - ปซ*> -... mwp> ' ^ , , ' ' ,
* ,ซ >, - .* --, '- 4- ,;^,-^ซ
*> ^ ^^ ^^^"-'^^"^^' j' z
s& ซia* mrs* >"-\''-\--'
^7 -^v^" ^-T"***^ f *ป' TSWT1^ ^ ^ .-.A- %i\ ^ %% ^.Ks ^^
^ sssi. .%% ^ j.j.v,'. f ^ffjf j.jfj. v. s,.. ^ "*Sf'$ff slP ^ ^N'^,
i-A- AJA- f &ff ', fff fff ?\ '' f * : : f ~" "" f f
Figure 45. Name Selection Menu - Counts Returned
Student Booklet
41
-------
Figure 46. Name Selection Menu - Data Options Selection
To eliminate the Emergency Response Notification System (ERNS) data, press
to position the cursor on the Data Options field. Press < Enter > to activate the pull-
down menu. Type 2 to eliminate ERNS data and press < Enter >.
The NAME SELECTION MENU SCREEN^ returns with the number of names selected (see
Figure 47).
42
IDEA
-------
** M-*+
"' , itore lesS-^Ukety oartes itften words Juttfe 2 Of
s-. f - - i^1-^ ^ ^ ^ ^ ^^^ ^^ .
.
ซ>, -':,. ,
Figure 47. Name Selection Menu - Return Names Selection
Type Y at the RETURN NAMES TO QUERY prompt. Press < Enter >. The EDIT
SCREENfKODAK) returns.
Student Booklet
43
-------
figure 48. Edit Screen - Names Returned
IDEA'S GO Names utility uses a soundex algorithm to search for facilities. It takes the
first character of the name and the next three distinct consonants and searches for facility
names that match them in an effort to find facilities that sound like the one you entered.
If a facility name matches this pattern, it will appear in the list that is returned to the EDIT
SCREEN.
Soundex Search Algorithm for KODAK: KODAK
For example, you entered KODAK. IDEA will search for facilities whose names contain
the characters K, D, and K. Therefore both KODAK and KODIAK facilities are
retrieved. The required query statements of OUTPUT, INPUT, and SELECT are also
returned.
In the following steps, we will use editing techniques (including block copy, cut, paste,
and find commands) to delete the KODIAK facilities while retaining the KODAK
facilities.
44
IDEA
-------
Figure 49. Edit Screen - Block Copy Line Command
ISPF (IBM's mainframe text editor) provides a method for storing information in a
temporary buffer. Use the block copy line command (CC) to tell ISPF which lines are to
be placed in the buffer. Use the CUT command to write this information to the buffer.
From the EDIT SCKEEN(KODAK), identify lines 000003 and 000005 (inclusive) to place
in the buffer. < Tab > to line 000003. Type CC. < Tab > to line 000005. Type CC.
Student Booklet
45
-------
li "* v-. *ซซ. .-. - -, %
3*nป!ป -COT " ., ^-.^ *s^ ,%% - s
SdftOLL tat** $$&
t*********'
' */ ' ' ,
T Tw^mv^-, rw*ปTrป-. f v- u
OtiimiT 8Eฃ0ปf Ifc , "
tซpotru^f6 "v v---
Figure 50. Edit Screen - CUT Command
Press to return to the COMMAND prompt. Type CUT. Press < Enter >.
Lines 000003 - 000005 are placed in a nondisplayed buffer. In the upper right hand corner
of the screen, ISPF returns the message "3 lines cut."
Press PF3 to exit and save the KODAK query. The MEMBER LIST SCREEN returns.
46
IDEA
-------
tซ0
'nauป f or
- --
1*9999 fซ
,***>
to 99999
OUT
MB&&
V
Figure 51. CUT Default Screen
Note: The default values for the CUT command must be specified the first time that the
CUT command is entered.
' o , . ; 'sv" % ''? , " .. *
Figure 52. CUT Default Values Screen
< Tab > to the CUT default prompt. Type REPLACE and type ZERO at the PASTE
default prompt. Press PF3 to save and exit the CUT DEFAULT SCREEN.
Student Booklet
47
-------
Figure 53. Member List Screen - Creating a Member
From the MEMBER LIST SCREEN, create a member to retrieve and save the lines that
were placed in the buffer. Type E LOGIC at the COMMAND prompt. Press
< Enter >. The EDIT SCREEN(LOGIC) appears.
48
IDEA
-------
, ,
A***** *w***^*******^***********w***-
" '" ' "
,' I Hf It
y... ..
* " s
----- Gta.y*iฃ ess m
- SC&a,L ***ป Oft- -
****************************** ..
Figure 54. Edit Screen - PASTE Command
From the EDIT SCREEN (LOGIC), type PASTE at the COMMAND prompt. < Tab >
to the line control position containing ******. Type A (After). Press . The
3 lines contained in the buffer are written to the screen.
Press PF3 to exit and save this member. The MEMBER LIST SCREEN returns.
From the MEMBER LIST SCREEN, select the KODAK member. Type E KODAK at the
COMMAND prompt. Press < Enter >. The EDIT SCREEN (KODAK) returns.
Student Booklet
49
-------
ISY63& fteate* fciarcirfn&ofi
Figure 55. Edit Screen - Exclude (EX) Command
Place the KODAK facilities (those that we want for our query) in a temporary buffer by
using the EXCLUDE command. In the following steps, we will delete the KODIAK
faculties using the DELETE NOT-EXCLUDED (NX) command. The FIND command
will be used to restore the KODAK facilities to the query. Finally, we will retrieve the
query statements of OUTPUT, INPUT, and SELECT to reconstruct our query with the
necessary query statements.
From \h&EDITSCKEEN(KODAK), type EXCLUDE ALL KODAK at the COMMAND
prompt Press < Enter >. All lines that contain the name "KODAK" are removed from
the screen. ISPF returns a message in the right hand corner of the screen: ### CHARS
"KODAK", which tells the number of hidden lines. Press to return to the
COMMAND prompt.
50
IDEA
-------
% " -s * -
/*"
, $S9&1E
1 >;aBQ9is
c ,$(M)6lV
ฎ&15,
-.^^>^jj00g^ y*" ^.
.. .. fi(J0.(J1S(
---.v^&l9
' 115 name** */ " " "'
Figure 56. Edit Screen - Delete Not-Excluded (NX) Command
Delete the KODIAK facilities. Type DELETE ALL NX at the COMMAND prompt.
Press . ISPF returns the message: "## LINES DELETED". Between the TOP
OF DATA and the BOTTOM OF DATA indicators, the message: "### Line(s) not
displayed" appears in place of the original lines (see Figure 57).
Student Booklet
51
-------
** gftfTQW OF BAT* ******.*******yi!***********'***
' '
Rgure 57. Edit Screen - FEND ALL Command
Retrieve the KODAK facilities. Type FEND ALL KODAK at the COMMAND prompt.
Press < Enter >. Press to return to the COMMAND prompt.
Figure 58. KODAK Facilities Retrieved
52
-------
*>ซpt v$x> *% --- , v r- "
Figure 59. Copy LOGIC Member
From the EDIT SCREEN(KODAK) complete the query by retrieving the previously saved
query statements. Type COPY LOGIC at the COMMAND prompt. to line
000001. Type A (for After). Press . The query statements of INPUT,
OUTPUT, and SELECT are placed in the KODAK member.
In this example, we know that IDEA will retrieve facilities based upon the FINDS EPA
ID (due to the SELECT FIN.EPID= statement). The comma (,) between facility IDs is
used to OR the selection. We need to make sure the last line of the query does not have
a comma.
Press to return to the COMMAND prompt. Type MAX. Press PF8 (PAGE
DOWN). < Tab > to the last line of data. Delete the comma (,).
Student Booklet
53
-------
%m&m*?...,.'"...'<': "--
Figure 60. Executing the GO Command
Press to return to the COMMAND prompt. Run the query. Type GO at the
COMMAND prompt. Press < Enter >. The QUERY STATUS SCREEN returns with the
message: ### Facilities Selected and in FINDS.
54
IDEA
-------
f by -datr-abase/ of
fv.-, A. .<,$-
^ - , ,^' , -L ^^ptSft-to- .. % ^ \- -. -1 x. -..; % sซ *
Figure 61. Query Status Screen
From the QUERY STATUS SCREEN, press PF3 to exit this screen. The EDIT
SCREEN(KODAK) returns. Press PF3 to save and exit this screen. The MEMBER LIST
SCREEN returns.
Student Booklet 55
-------
Summary of GO NamesCommand
GO Names allows you to form a query by entering a company name and/or location (state,
county, EPA region, or ZIP code). To use GO Names, you must be in the Keyword
Interface EDIT SCREEN.
ACCESSING GO NAMES
Type GO Names at the COMMAND prompt, and press < Enter >.
SELECTING QUERY CRITERIA
At the NAME SELECTION MENU, type a facility name and/or geographical area
for which you want to search, and press < Enter >. IDEA will then execute the
GO Names search and display the count of facilities found.
Before IDEA generates a list of facilities, you must select how you want them to
be returned to the query and whether or not you want corporate profile information
on them. When selecting how the facilities will be returned to your query, you
have the following options:
Y(es) Returns the FINDS number plus the facility name and the source database
name.
A01) Returns the same data as Y(es) plus the facility name in each of the
databases to which it is linked in FINDS and the source database names.
M(ax) Returns everything in A(ll) plus the address for the facility in each of the
databases and its EPA region.
After making these selections, press < Enter >. The facilities from your GO
Names search will appear on the EDIT SCREEN added to the beginning of your
query.
RUNNING YOUR QUERY
Type GO at the COMMAND prompt. The query you have constructed will be
executed, and the QUERY STATUS SCREEN will appear.
56
-------
Running a Keyword GO MenuA Query
In this exercise, we will create a new member that will contain the Noncompliance Keywords
retrieved using the GO MenuA utility. The member will be named SNIPPET as it will contain
a tidbit of information.
Figure 62. Member List Screen - Create Member
From the MEMBER LIST SCREEN, create a new member. Type E SNIPPET at the
COMMAND prompt. Press . The EDIT SCREEN(SNIPPET) returns.
Student Booklet
-------
- ,
T<^ f>F ปซ* *******************************
7^V^\*I/ *
S?.5^*
Figure 63. Edit Screen - GO MenuA Command
Type GO MENUA at the COMMAND prompt. Press . The MAIN MENU
INTERFACE SCREEN appears.
58
IDEA
-------
* ,-&_ . - . t :. * " .. ... ^ i.!.'' t s
\ ' 4. \ . v ' .. , - %- ' - - - o- , - - * - - -
,~sป, , ," , ;"" , - ', "*" ,"..-'.. " - , '
* > --- ' --"- -----,::, T",' ^"-\',, - " , " " ' ' >" '.''"<,< -
* ^%-- '- ^ - - ^ s t. -.-.
"' "*.-" ,' <,,",".. t "i % ,, . "ซ ; " ,
, o? - ,;,>- ~? * * -
^ - ,
Figure 64. Main Menu Interface Screen
From the M4/# MENU INTERFACE SCREEN, to the Noncompliance category.
TypeS. Press .
Student Booklet 59
-------
tO^jfe^'C* I- * * ** *S-* +& >*>* * * *** i +C^*-* + +J H-jf+
"--''''>
v 4fe< ' ' * ซ!ป< * # I
_,_. ,. *?**,. +K > ' ?*"* +K *ฐ * * ""
^&ft^i<^:4fir ^>:
Ddtt^t'' jgjt * + ^ *i^W.''4.^k M ?* k J **"k^ *+ kJ *+ k'rf 4-+ kJ ** kJ J-^kji-jt-Vk^ i-*''^^! ^V'kV** ^ * "" S v
^^.-^ff-^^^/'x^^- ./%," < ,"", ',*;, "& ;; "'ฃ'.., - ; ,>,>, * ,- ,
^t'^^v?^\; '....
Figure 65. Noncompliance Menu Screen
From the NONCOMPLIANCE MENU SCREEN, select noncompliers (NCs) and significant
noncompliers (SNCs) for each media section (CAA, CWA, RCRA, FIFRA, TSCA, and
EPCRA 313). Each media defines Noncompliers differently.
to
CAA
to
CWA
to
RCRA
FEFRA
TSCA
EPCRA
IN VIOLATION, type S.
SIGNIFICANT VIOLATION STATUS, type S.
REPORTABLE NONCOMPLIANCE, type S.
SIGNIFICANT NONCOMPLIANCE, type S.
UNRESOLVED VIOLATIONS, type S.
UNRESOLVED HIGH PRIORITY VIOLATIONS, type S.
NC te S. SNC te S.
NC, type S. SNC, type S.
NC, type S. SNC, type S.
NC, type S. SNC, type S.
Type Y at the FINISHED? (Y/N) prompt. Press . The MAIN MENU INTERFACE
SCREEN returns with the query criteria displayed.
60
IDEA
-------
ปซneซBp|.it*rซ?e>s v
Figure 66. Main Menu Interface Screen - Noncompliance Keywords
Run the query. From the MAIN MENU INTERFACE SCREEN, to RUN QUERY
prompt. TypeS. Press . The INPUT AND REPORT SELECTION SCREEN
appears.
Student Booklet
61
-------
, .
u^^U*^** ^ granary
" %
Figure 67. Input and Report Selection Menu
Accept the defaults (Linked and Report 1A). Press . The EDIT
SCREENfSNIPPET) returns with the query statements (INPUT, OUTPUT, and SELECT)
and the Noncompliance and Significant Noncompliance keywords.
62
IDEA
-------
?* "
f*
/*
>, SBB<f <
7; semi *ป*> 85*,
jst4..^a itt
., ""*/
*
-,-- -,
fcayworete for cwweftlffi^ Sft
*/ -- i ปป ':<
at
****ซ* *************!ซ***********-#**
- -
OP
Vr
*/
*-
:******** "
% -V '" "^
",ป, "'-/- '
.o ^^^
' t -.
Figure 68. Edit Screen - Noncompliance Keywords
Student Booklet
63
-------
Figure 69. Edit Screen - Block DELETE Command
In the following steps, we will show how to combine a corporate facility query (KODAK)
with noncompliance logic. The query appearing in the EDIT SCREEN(SNIPPET) could now
be executed, as it satisfies the query syntax rules. However, the results of this query would
be mammoth and thus of little or no value. To refine this query, we will edit SNIPPET to
contain only noncompliance logic and add the boolean operator of AND. We will then save
this noncompliance logic and copy it to the KODAK member.
The query statements (OUTPUT, INPUT, SELECT) and noncompliance keywords have been
returned to the EDIT'SCREEN(SNIPPET). Since we will be adding the noncompliance logic
to our KODAK query (which already has the query statements), we must delete these
statements from this query.
to line 000001. Type DD. to line 000008. Type DD. Press .
to the INPUT keyword.
Add the boolean operator AND to the beginning of this query. Type AND; the
remaining part of the line. Press . Press PF3 to exit and save the SNIPPET query.
TheMEMREK LIST SCREEN returns.
64
IDEA
-------
y ft
tj*
js>vt,f
.vi-
in ftifi
%
9R
Figure 70. Edit Screen - Noncompliance Keywords
From iheMEMBER LIST SCREEN, select the KODAK member. Type E KODAK at the
COMMAND prompt. Press . The EDIT SCREEN(KODAK) returns.
Student Booklet
65
-------
Figure 71. Edit Screen - COPY Command
From the EDITSCREENfKODAK) we will add the noncompliance keywords (SNIPPET) to
the bottom of the query. At the COMMAND prompt, type MAX. Press PF8 (Page Down).
to the last line. Type A (for After). Press . ISPF will return the message
COPY/MOVE PENDING. Press to return to the COMMAND prompt. Type
COPY SNIPPET. Press . ISPF returns the message COPY complete. The queries
are now combined.
Run the query. Type GO at the COMMAND prompt. Press . The QUERY
STATUS SCREEN returns with the message: ### Facilities Selected and in FINDS.
66
IDEA
-------
sassjK
extorted Because
- ' -Vlft - 8 t
not
fff f
V.V..V V.ป*. "* f '''
v "-'t -.^r-\
v1- , *"
Figure 72. Query Status Screen
Press PF3 to exit the QUERY STATUS SCREEN. Press PF3 to save and exit the EDIT
SCREEN(KODAK).
Student Booklet
67
-------
Summary of GO MenuA Command
The GO MenuA utility allows you to build a query in the Menu Interface and edit it in the
Keyword Interface. To use GO MenuA, you must be in the Keyword Interface EDIT
SCREEN.
ACCESSING GO MENUA
Type GO MenuA at the COMMAND prompt, and press < Enter > . IDEA will
display the MAIN MENU SCREEN of the Menu Interface. For information on
building a query with the Menu Interface, refer to the Menu Interface section.
RETURNING TO THE KEYWORD INTERFACE
Select RUN QUERY on the MAIN MENU SCREEN, choose the type of search and
the report format you want, and press < Enter > . The EDIT SCREEN of the
Keyword Interface will appear.
YOUR QUERY
For a list of commands to use in the EDIT SCREEN, refer to the Line Editing
Commands chart in the Keyword Interface section.
RUNNING YOUR QUERY
Type GO, and press < Enter > at the COMMAND prompt.
Combining GO Names and GO MenuA
Use GO MenuA before GO Names to build a query that combines the two.
Before running your combined queries, insert the word AND between the two
queries and delete the INPUT, OUTPUT, and SELECT lines in the second query
in order to preserve proper query syntax.
68
IDEA
-------
Summary
At this point, you should be familiar with some of IDEA'S basic features such as the Menu
Interface and the GO Names utility. Test your skills by answering these questions.
1. How do you access IDEA from the EPA mainframe?
2. How do you select the Menu Interface?
3. How do you generate an IDEA query using the Menu Interface?
4. How do you select the Keyword Interface?
5. How do you set up a member? Why do you need to?
6. How do you access the GO Names facility?
7. Why does GO Names return information to the Keyword editor?
8. How do you get a report from a GO Names query?
9. How can you switch from one report to another?
10. How do you navigate IDEA reports?
Student Booklet 69
-------
Logging Off
To exit IDEA at any time follow these procedures:
4 Use the END command or PF3 key to back out of the program screen by screen
until you reach the TSO READY prompt, type LOGOFF, and press < Enter >
to exit the IBM Mainframe.
4 Use the RETURN command (PF4 key) to return directly to the OFFICE OF
ENFORCEMENT DATA INTEGRATION PRIMARY MENU. You may 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. Type LOGOFF at the
READY prompt, and press < Enter > to exit the IBM Mainframe.
4 Type =X at the COMMAND line to go directly to the TSO READY prompt.
Type LOGOFF, and press < Enter > to exit the IBM Mainframe.
When an ISPF session is initiated for a user, the system creates two datasets, LOG and
LIST, in which information can be recorded during the ISPF session. This activity
happens without direct user participation. When you attempt to leave the IBM Mainframe,
the screen shown in Figure 73 may appear before you reach the TSO READY prompt.
On this screen, you are asked to specify how you wish to dispose of the LOG/LIST
datasets.
70 IDEA
-------
ซF
+ -K Hv* + -K H-.+ +.-K Hv* + -K )^-.+ + -h i^-.-i- + -h IT.-*- + -K K-
*. -.-. . .. , ,
JSIT %>TซซS r -; , ^ -' ilST 5*TA SET OPf IW9 ', ^ , ' ,
^
~"f ff tf ^ ft'tff ffff-f f ** f f * *" . f f f f f '" f
pt*ซ8 a**^ 0 , , , pj*ซa$9$ ซปl| to move the cursor to the LIST DATA SET PROCESS
OPTION prompt. Type D, and press < Enter >. The READY prompt will appear.
To exit the IBM mainframe, type LOGOFF and press < Enter > at the READY prompt.
Student Booklet 71
-------
------- |