 |
Create a List of Manufacturers for a Chemical?
TOPIC: An important task for a business is to find manufacturers for its products. For chemical companies Chapman and Hall Chemical Database (File 303), The Merck Index OnlineSM (File 304) and Registry of Toxic Effects of Chemical Substances (File 336) are key files in searching chemical substances. They contain chemical names, properties, identification, details and more. Each record describes a single chemical entity and contains CAS® Registry Numbers, synonyms and other substance information. These files provide excellent ways to capture chemical names and synonyms to execute in Directory of Chemical Producers—Products (File 363).
Then from the chemical products found in File 363, we can use the Directory of Chemical Producers—Companies (File 364) to create lists of specific chemical producers and their locations throughout the world. The two databases (Files 363 and 364) connect chemical products with their international manufacturers, thus, giving us the advantage of full multi-region searchability. The Dialog collection consists of nine regional directories covering approximately 13,000 companies worldwide that operate almost 18,000 plants. Coverage includes more than 90 countries in the following regional designations: Canada, China, East Asia, Europe, India, Mexico, Middle East and Africa, South and Central America and the United States.
In this example we'll:
1. Identify the synonyms for a chemical and the chemical's CAS® Registry Number (RN=) using Files 303, 304 and 336. The MAP command will create a temporary SearchSave that can then be executed in files which may either use the CAS Registry Number or free-text searching, or both.
2. Search the Directory of Chemical Producers—Products (File 363) and create a SearchSave containing company names corresponding to the names indexed in the Directory of Chemical Producers—Companies (File 364).
3. Find companies that produce a chemical (File 364) and create a list that identifies the companies and their locations.
COMMAND SUMMARY
BEGIN 303,304,336
EXPAND NA=CUMENE
SELECT "E" REFERENCE NUMBER
MAP SYRN T
RECALL TDNNN
BEGIN 363
EXS TDNNN
SELECT UNITED(W)STATES/CN
SELECT S1 AND S2
MAP CO T
RECALL TDNNN
BEGIN 364
EXS TCNNN
HELP SET
SET H 132 V 0
HELP REPORT 364
REPORT SN/CO,CY,ST,ZP/1-17
HOW TO...
|
1. BEGIN Files 303,304,336 to search a chemical substance.
|
?b303,304,336
SYSTEM:OS - DIALOG OneSearch
File 303:Chapman & Hall Chemical Database 1997/Apr
(c) 1997 Chapman & Hall
File 304:The Merck Index Online 2012S1
A subsid. of Merck&Co,Inc.,USA
File 336:RTECS 2012/Q3
Portions (c) Copyright 2012, U.S. Government. Rights Res
Set Items Description
--- ----- ----------- |
|
2. EXPAND the chemical name on the Chemical Name (NA=) field.
|
? e na=cumene
Ref Items Index-term
E1 1 NA=CUMEENHYDROPEROXYDE
E2 3 NA=CUMELON
E3 5 *NA=CUMENE
E4 1 NA=CUMENE ALDEHYDE
E5 2 NA=CUMENE HYDROPEROXIDE
E6 1 NA=CUMENE HYDROPEROXIDE MIXED WITH BETA-NAPHTHYLA
E7 2 NA=CUMENE PEROXIDE
...
Enter P or PAGE for more |
|
3. SELECT the appropriate “E” Reference number(s) that are associated with the chemical cumene.
|
? s e3
S1 5 NA='CUMENE' |
|
4. Use the MAP command to create a temporary SearchSave, which contains the synonyms and CAS Registry Number.
This example shows the creation of temporary SearchSave #TD498.
|
? map syrn t
Temp SearchSave "TD498" stored
3 Select Statements, 19 Search Term(s)
SearchSave TD498
1 SearchSave(s), 19 Search Term(s) |
|
5. RECALL the temporary SearchSave number to view the terms saved and determine if you need to add any terms. Note that cumene is included as a search term.
|
? recall td498
Name: TD498
Modified: 27sep12
Line Commands:
----- ---------
1. S 1()METHYLETHYL()BENZENE + BENZENE()1()METHYLETHYL +
BENZENE()ISOPROPYL + CUMEEN + CUMENE + CUMOL + ISOPROPILBENZENE +
ISOPROPYL()BENZENE + ISOPROPYL()BENZOL + ISOPROPYLBENZEEN +
ISOPROPYLBENZENE + ISOPROPYLBENZOL + PROPANE()2()PHENYL 2. S
RCRA()WASTE()NUMBER()U055 + 1()METHYLETHYLBENZENE + 2()FENILPROPANO
+ 2()FENYL()PROPAAN + 2()PHENYLPROPANE + RN=98-82-8
3. S S1:S2 |
|
6. BEGIN Directory Of Chemical Producers—Products to find the chemical producers of your compound.
|
? b363
27sep12 09:56:01 User356433 Session
File 363:DCP-Products 2012/Q2
(c) Access Intelligence LLC/SRI Consulting
Set Items Description
--- ----- ----------- |
|
7. EXECUTE The Temporary SearchSave TD498 In File 363. Dialog remembers the last saved search and executes it as long as you have not logged off.
Dialog created two search sets and ORed them together in S3.
|
? exs
Executing TD498
13717 1
172 METHYLETHYL
4369 BENZENE
25 1(W)METHYLETHYL(W)BENZENE
4369 BENZENE
13717 1
172 METHYLETHYL
0 BENZENE(W)1(W)METHYLETHYL
4369 BENZENE
598 ISOPROPYL
0 BENZENE(W)ISOPROPYL
0 CUMEEN
91 CUMENE
2 CUMOL
...
17576 2
5053 PHENYL
4 PROPANE(W)2(W)PHENYL
S1 152 1()METHYLETHYL()BENZENE + BENZENE()1()METHYLETHYL +
BENZENE()ISOPROPYL + CUMEEN + CUMENE + CUMOL + ISOPROPILBENZENE +
ISOPROPYL()BENZENE + ISOPROPYL()BENZOL + ISOPROPYLBENZEEN + ISOPROPYLBENZENE
+ ISOPROPYLBENZOL +PROPANE()2()PHENYL
>>>Prefix "RN" is undefined
0 RCRA
0 WASTE
5 NUMBER
0 U055
0 RCRA(W)WASTE(W)NUMBER(W)U055
13717 1
0 METHYLETHYLBENZENE
0 1(W)METHYLETHYLBENZENE
17576 2
0 FENILPROPANO
0 2(W)FENILPROPANO
17576 2
0 FENYL
0 PROPAAN
0 2(W)FENYL(W)PROPAAN
17576 2
48 PHENYLPROPANE
7 2(W)PHENYLPROPANE
0 RN=98-82-8
S2 7 RCRA()WASTE()NUMBER()U055 + 1()METHYLETHYLBENZENE +
2()FENILPROPANO + 2()FENYL()PROPAAN + 2()PHENYLPROPANE + RN=98-82-8
S3 155 S1:S2 |
|
8. SELECT the United States as A Country Name (/CN). The (W) connector specifies that the two words appear next to each other in exact order.
|
? united(w)states/cn
S4 12435 UNITED(W)STATES/CN |
|
9. Combine Set 3 (S3) and Set 4 (S4).
|
? s3 and s4
S5 23 S3 AND S4 |
|
10. Use the MAP command to create a temporary SearchSave of Company Names (CO=) for execution in File 364 (Directory of Chemical Producers—Companies).
|
? map co t
Temp SearchSave "TD499" stored
4 Select Statements, 20 Search Term(s)
SearchSave TD499
1 SearchSave(s), 20 Search Term(s) |
|
11. RECALL the temporary SearchSave (TD499) to examine the TD499 (and edit if necessary).
|
? recall td499
Name: TD499
Modified: 27sep12
Line Commands:
----- ---------
1. S CO="AKZO NOBEL INC." + CO="ARKEMA INC." + CO="BLUE ISLAND PHENOL LLC" +
CO="CITGO PETROLEUM CORPORATION" + CO="FLINT HILLS RESOURCES LP" + CO="GEORGIA
GULF CORPORATION" + CO="INEOS AMERICAS, LLC"
2. S CO=LYONDELLBASELL FLAVORS & FRAGRANCES LLC + CO="MARATHON PETROLEUM
COMPANY LLC" + CO=MILLENNIUM SPECIALTY CHEMICALS, INC. + CO="NEASE CORPORATION"
+ CO="PCI SYNTHESIS INC." + CO="PENTA MANUFACTURING COMPANY" + CO="RENESSENZ LLC"
3. S CO="SHELL CHEMICAL LP" + CO=SIGMA CHEMICAL COMPANY + CO="SIGMA-ALDRICH
CORPORATION" + CO="STEPAN COMPANY" + CO="SUNOCO, INC." + CO="UNITED
INITIATORS, INC."
4. S S1:S3 |
|
12. BEGIN Directory of Chemical Producers—Companies. This file contains the addresses of companies that produce a chemical.
|
? b364
File 364:DCP-Companies 2012/Q2
(c) Access Intelligence LLC/SRI Consulting
Set Items Description
--- ----- ----------- |
|
13. EXECUTE all steps (EXS) of the new temporary SearchSave (TD449) in File 364. Notice that the SearchSave created 4 sets and ORed them together in Set 5.
|
? exs
Executing TD499
1 CO=AKZO NOBEL INC.
1 CO=ARKEMA INC.
1 CO=BLUE ISLAND PHENOL LLC
1 CO=CITGO PETROLEUM CORPORATION
1 CO=FLINT HILLS RESOURCES LP
1 CO=GEORGIA GULF CORPORATION
1 CO=INEOS AMERICAS, LLC
S1 7 CO="AKZO NOBEL INC." + CO="ARKEMA INC." + CO="BLUE ISLAND
PHENOL LLC" + CO="CITGO PETROLEUM CORPORATION" + CO="FLINT
HILLS RESOURCES LP" + CO="GEORGIA GULF CORPORATION" +
CO="INEOS AMERICAS, LLC"
1 CO=LYONDELLBASELL FLAVORS & FRAGRANCES LLC
1 CO=MARATHON PETROLEUM COMPANY LLC
1 CO=MILLENNIUM SPECIALTY CHEMICALS, INC.
1 CO=NEASE CORPORATION
1 CO=PCI SYNTHESIS INC.
1 CO=PENTA MANUFACTURING COMPANY
1 CO=RENESSENZ LLC
S2 5 CO=LYONDELLBASELL FLAVORS & FRAGRANCES LLC + CO="MARATHON
PETROLEUM COMPANY LLC" + CO=MILLENNIUM SPECIALTY CHEMICALS,
INC. + CO="NEASE CORPORATION" + CO="PCI SYNTHESIS INC." +
CO="PENTA MANUFACTURING COMPANY" + CO="RENESSENZ LLC"
1 CO=SHELL CHEMICAL LP
1 CO=SIGMA CHEMICAL COMPANY
1 CO=SIGMA-ALDRICH CORPORATION
1 CO=STEPAN COMPANY
1 CO=SUNOCO, INC.
1 CO=UNITED INITIATORS, INC.
S3 5 CO="SHELL CHEMICAL LP" + CO=SIGMA CHEMICAL COMPANY +
CO="SIGMA-ALDRICH CORPORATION" + CO="STEPAN COMPANY" +
CO="SUNOCO, INC." + CO="UNITED INITIATORS, INC."
S4 17 S1:S3 |
|
14. Before creating a REPORT and sending output to the screen, it is important to adjust the number of characters in a line to one that allows the desired fields to appear.
Use the HELP SET command to explain how to set the screen. The SET commands that show the screen width and height are shown.
|
?HELP SET
HELP SET
--- SET Command ---
The SET command has a variety of uses, most of which alter the
form of output that DIALOG sends to your terminal. Any time the
SET command is used, a parameter is set that remains in effect
until LOGOFF, or until you issue another SET command that
modifies the parameter. Use the SHOW command to display the
parameters that are currently set.
You can enter a SET command at any point in your search.
You can also store SET commands in your PROFILE; for details on
use of the PROFILE feature, refer to HELP EDIT, HELP SAVE, OR
HELP PROFILE online.
A list of available SET commands is provided below:
SET ADDRESS Axxxx Specifies an alternate....
(...)
SET H nn Sets line length to nn characters.
(...)
SET V nn Sets number of lines per screen to nn.
(....) |
|
15. SET Horizontal (H) characters per line to 132 and vertical (V) to 0 lines so that the report will run as one unit.
|
?ET H 132 V 0
Characters per line set to 132.
Lines per Page set to 0. |
|
p>16. Enter HELP Report 364 to see a list of available fields in this file to create a tabular report.
|
? help report 364
RPT364 : DIRECTORY OF CHEMICAL PRODUCERS - COMPANIES
REPORT
CODE LENGTH DESCRIPTION
CN (20) Country Name
CN (20) Country Name
CO (25) Company Name or Former Company Name
CO (25) Company Name or Former Company Name
CY (15) City
ST (15) State, Province, County
ZP (12) Zip or Postal Code |
|
17. Produce a REPORT containing the Company, City, State and Zip Code for the records retrieved.
|
? report s4/co,cy,st,zp/1-17
DIALOG(R)File 364 :DCP-Companies
(c) Access Intelligence LLC/SRI Consulting All rts. reserv.
COMPANY CITY STATE ZIP CODE
----------------------- ------------ ------------- ----------
United Initiators, Inc. Elyria Ohio 44035
Sunoco, Inc. Philadelphia Pennsylvania 19103
Stepan Company Northfield Illinois 60093
Sigma-Aldrich Corporati St. Louis Missouri 63103
Shell Chemical LP Houston Texas 77252-2463
Renessenz LLC Jacksonville Florida 32208-4476
Penta Manufacturing Com Livingston New Jersey 07039-1604
PCI Synthesis Inc. Newburyport Massachusetts 01950
Nease Corporation Blue Ash Ohio 45242
Marathon Petroleum Comp Findlay Ohio 45839
INEOS Americas, LLC Lisle Illinois 60532
Georgia Gulf Corporatio Atlanta Georgia 30346
Flint Hills Resources L Wichita Kansas 67220
CITGO Petroleum Corpora Houston Texas 77077
Blue Island Phenol LLC Blue Island Illinois 60406
Arkema Inc. Philadelphia Pennsylvania 19103-3231
Akzo Nobel Inc. Chicago Illinois 60607-3823 |
RELATED HOW DO I...? SOLUTIONS
NEED HELP?
Contact the Dialog Knowledge Center
Within North America +1 800 3 DIALOG (334 2564)
Outside North America 00 800 33 DIALOG (33 34 2564)
Web Form www.dialog.com/contacts/webform
|
|
