150

Document Sample
150 Powered By Docstoc
					Index
                               AND NOT operator 74
                               AND operator 74
#                              Apostrophes (')
# (pound sign) 57                in character strings 48
                               Arithmetic expressions 63, 65
                               Arithmetic operators 63
$                              AS clause 189
                               ASCEND qualifier 154
$LIKE 162
                               Asterisk (*)
$RANK function 148
                                 See Arithmetic operators
$Rank qualifiers
                                 See Wildcard characters
  REFERENCE_WEIGHT 159
                               Asterisk, double (**)
  TERM_WEIGHT 159
                                 See Arithmetic operators
$WEIGHT 162
                               AVG function 102

?                              B
? (question mark)
                               Base syntax 10
   See Wildcard characters
                               Basic searches 23
                               Boolean operators 74, 140
A                              Break characters
                                 in character strings 49
Addition symbol 63             Built-in system functions
ADJ operator 73                  See System functions
Advanced searches 89
Aggregate functions
  See Statistical functions    C
Aggregations
                               Calculating statistics
  See Calculating statistics
                                 multiple groups of records 179
ALL modifier 193
                                 single group of records 175
Alternate syntax formats
                               Cartesian product 129
  character strings 223
                               Case-sensitive searching 49
  fields 216
                               Character patterns
  HAS operator 221
                                 as search values 53
  join operators 223
                                 lists 59
  overview 215
                                 See also Phrase patterns
  proximity clauses 222
                               Character strings
  retrieval tests 217
                                 alternate syntax formats 223
  SORT BY clause 224
                                 as search values 48
  test operators 219
                                 lists 59
  views 216
                                 ranges 52



                                                                  Index  225
CHECKOUT status 199                                  overview 17
Child views 124                                      specific fields 20
Combination-views                                  DISTINCT modifier 178, 193
  more than two views 126                          Division symbol 63
  overview 110                                     DJOIN operator 223
COMBINE option 209                                   See also :=>> Directed-join operator
Command parameters                                 DM_LEAD_WORDS stopword list 157
  overview 195                                     Does not equal
  See also specific parameter types                  See Not equal (^=)
Command procedures                                 Double asterisk (**)
  See Procs                                          See Arithmetic operators
Composite views 126
Compound fields
  COUNT function 104                               E
  nested WHERE clauses 94                          ELIMINATE qualifier
  overview 25                                        example 157
  sorting by 146, 151                              ELIMINATE qualifier 154
  WITH operator 77                                 END delimiter 197
Connector operators                                Equals (=) 32
  combining result sets 140                        equi-join operator (:=) 111
  combining search criteria 74                     Equi-join operator (:=) 111, 124
  multiple 85                                        See also JOIN operator
Constant components 10                             ERR parameter 198
Context units 164                                  EVERY modifier 146, 151
Context units 69, 70, 72                           Exclamation point (!)
COUNT function                                       in character strings 48
  DISTINCT modifier 178                            EXPLODE_SUB function 152
  in commands that create simple result sets 102   Exploding sorts 151
  in commands that create tables 178               Exponential symbol 63
                                                   Exponentiation 63
D                                                  Extending a command 11

Data types
  overview 30                                      F
  precisions and scales 191                        Field lists 26
  symbols for table formatting 191                 Fields
DATE function 62                                      as lists of search values 59
Dates                                                 as search values 58
  as search values 49                                 compatible test operators 32
  in lists 59                                         compound 25, 94, 104
  in ranges 52                                        data types 28, 32
Demonstration database 11                             displaying information about 28
DESCEND qualifier                                     field lists 26
  example 156                                         fully qualified names 91, 113, 216
DESCEND qualifier 154                                 lists of fields 26
Directed-join operator (:=>>) 124                     searching numeric and short text 32
  See also DJOIN operator                             searching part of 27
DISCARD/SETS command 143                              searching short and long text 35
Displaying records                                    simple 25
  all fields 20                                       specifying 24



226  Index
  substrings of fields 27              Joining views
FROM QUEUE qualifier                      adding a retrieval test 119
  NT 133                                  composite views 126
  UNIX, VMS 132                           details of process 129
Functions                                 more than two views 124
  See System functions                    overview 109
                                          self-joins 121
                                          theta joins 129
G
General components 10
Greater than (>) 32
                                       K
Greater than or equal to (>=) 32       Keywords 35
GROUP BY clause 179
                                       L
H                                      LANGUAGE parameter
HAS operator 221                          See also THESAURUS parameter
HAVING clause                          LANGUAGE parameter 204
  overview 184                         Less than (<) 32
  See also GROUP BY clause             Less than or equal to (<=) 32
HHMMSS function 62                     LEVEL parameter
Hits                                      See also THESAURUS parameter
  See REFERENCES parameter             LEVEL parameter 204
                                       Limit qualifier
                                          for expanded searches 165
I                                      Lists
IN ORDER clause                           of fields 26
   See SORT BY clause                     of search values 59
INC operator 35, 38, 67                Locks 198
Includes operator 35, 67
Inclusive operators
   alternate syntax formats 219
                                       M
   overview 35                         Mathematical operators
Inequality sign                          See Arithmetic operators
   See Not equal (^=)                  MAX function 102
INTENT parameter 198                   MAX1 function 101
INTERMEDIATE parameter 201             MIN function 102
Intermediate result set 84             Minus sign (-)
Intermediate result set 201              See Arithmetic operators
                                       Morphological indexing 42
                                       Morphological searching
J                                        effect on searches with inclusive operators 42
Join expressions                       Multiplication symbol 63
   child view 124
   overview 112
   parent view 124
                                       N
JOIN operator 223                      Nested WHERE clauses
   See also Equi-join operator (:=)      confirming a single member temporary result set
Join operators                              101
   See also Alternate syntax formats     overview 90



                                                                                Index  227
  special syntax formats 95         lists 59
NOELIMINATE qualifier               See also Character patterns
  example 158                       See also Phrase operators
NOELIMINATE qualifier 154        Phrases
Not equal (^=) 32                   as search values 57
NOTIFY option 209                   lists 59
NULL                                See also Phrase operators
  as search value 61             Plus sign (+)
Numbers                             See Arithmetic operators
  as search values 48               See Extending a command
  lists 59                       Pound sign (#) 57
  ranges 52                      Precision, defined 42
                                 Precisions
                                    See Data types
O                                Preferred term switching 209
Optional components 10           Procs
OR operator 74                      deadlock situation 206
ORDER BY clause                     FIND command fails 198
  See also SORT BY clause           locked records 214
ORDER BY clause 224                 setting record-level locks 198
Order of precedence              Programs
  arithmetic operators 64, 66       deadlock situation 206
  connector operators 85            FIND command fails 198
                                    locked records 214
                                    setting record-level locks 198
P                                Projections, simple
                                    See Tables (value result sets), creating
Parameters
                                 Protections
  ERR 198
                                    See Record protections
  INTENT 198
                                 Proximity clauses
  INTERMEDIATE 201
                                    alternate syntax formats 222
  LANGUAGE 204
                                    overview 69, 70, 73, 74
  LEVEL 204
                                 Proximity operators 69, 70, 72, 73, 74
  REFERENCES 205
                                 Proximity searching 69, 70, 73, 74
  RESULT_MESSAGE 206
  ROLLBACK 206
  THESAURUS 208                  Q
  TIMEOUT 213
  WAIT 214                       QACTION function 135
Parent views 124                 QDATE function 135
PH ANY operator 35, 38           QSTATUS function 135
PH IS operator 35, 38            QTIME function 135
PH LIKE operator                 Question mark (?)
  See also Phrase patterns         in character strings 48
PH LIKE operator 36, 38            See Wildcard characters
PH WORDS operator 35, 38         Queue
Phrase operators                   defined 133
  alternate syntax formats 219   Queue area
  overview 35                      defined 133
Phrase patterns                    placing records in 199
  as search values 57              searching on UNIX, VMS 132




228  Index
  searching on Windows 133                       sorting 145
Queue functions 134, 169                       RESULT_MESSAGE parameter 206
Queue Status Record 133                        Retrieval tests
QUID function 135                                alternate basic syntax 217
                                                 arithmetic operators 63
                                                 basic 19, 25
R                                                combining 75
RAISE qualifier                                  nested WHERE clauses 90
   example 156                                   proximity clauses 69
RAISE qualifier 154                              proximity operators 73
Ranges                                           statistical functions 103
   lists 59                                      theta joins 130
   of search values 52                         Retrieving records
RANK function 145                                overview 17
READACCESS function 62                         ROLLBACK parameter 206
Recall, defined 42
Record protections 198
Record-level locks 198
                                               S
Reference descriptors                          SAME operator 73
   See Nested WHERE clauses (special syntax    Scales
       formats)                                  See Data types
REFERENCE_WEIGHT 162                           Search values
REFERENCES parameter                             ambiguous terms 209
   See also RESULT_MESSAGE parameter             character strings 48
REFERENCES parameter 205                         compatible test operators 46
Relational operators                             dates 49
   alternate syntax formats 219                  fields 58
   overview 32                                   lists 59
relevancy ranking 162                            NULL 61
Relevancy ranking 159                            numbers 48
Result set                                       overview 45
   absolute set number 143                       patterns 53
   relative set number 143                       phrase patterns 57
Result sets                                      phrases 57
   combining 139                                 preferred terms 209
   compatible 142                                ranges 52
   counting and highlighting references 205      security functions 61
   creating 18                                   time service functions 61
   discarding 143                              SEARCH_OPTION parameter 207
   displaying 18                               SEC operator 73
   displaying a listing of previous sets 142   Security functions 61
   expanding 162                               Selection qualifier
   identifying by number 143                     for expanded searches 165
   intermediate sets 201                       Self-joins 121
   manipulating 137                            SET/DEFAULTS command 206
   message 205, 206                            SET/THESAURUS_OPTION command 204
   restricting 137                             SHOW/DDB command
   searching 137                                 FULL parameter 49
   See also Tables (value result sets)           overview 29
   simple 18                                   SHOW/SETS command 142




                                                                              Index  229
Simple fields 25
Simple projections
                                                    T
   See Tables (value result sets), creating         Tables (value result sets)
Simple result sets 18                                  calculating statistics 175, 179
Singularization 54                                     counting the number of records 178
Slash (/)                                              default column headings 173, 176, 181, 189
   See Arithmetic operators                            eliminating duplicate rows 193
SORT BY clause                                         formatting a column 190
   overview 145                                        overview 172
   qualifiers 155                                      renaming column headings 189
   See also ORDER BY clause                            using joined views 186
Sort criterion                                      term weighting 162
   overview 145                                     Term weighting 159
   qualifiers 154                                   TERM_WEIGHT 162
Sort size 146                                       Test operators
Sorting result sets                                    alternate syntax formats 219
   by compound fields 146, 151                         compatible search values 46
   existing sets 153                                   compatible types of fields 32
   overview 145                                        inclusive 35
   using qualifiers 155                                overview 30
START/TRAN command 199                                 relational 32
Statistical function expressions                    Thesaurus
   in commands that create simple result sets 103      enabling 208
   in commands that create tables 175                  hierarchical levels 204
Statistical functions                                  languages 204
   overview 102                                        options 208
   sorting by 149                                   THESAURUS parameter
   with tables 175                                     See also LANGUAGE parameter
Stopwords 166                                       THESAURUS parameter 208
   overview 35                                      Theta joins 129
   standard BASIS lists 155                         TIME function 62
Subfields 25                                        Time service functions 61
Substring of fields 27                              TIMEOUT parameter 213
Subtraction symbol 63                               TOUR database 11
SUM function 102                                    Transactions 198
SWITCH option 209                                   TYPE command
Syntax conventions                                     basic 20
   extending a command 11                              EXPLODE_SUB function (for sorted sets) 152
   overview 10
Syntax diagrams
   parts of 10                                      U
System functions                                    UID function 62
   MAX1 101
   queue area 134, 169
   RANK 145                                         V
   statistical 102
   time and security 62                             Value result sets
                                                      See Tables
                                                    View-level locks 199
                                                    Views
                                                      child 124



230  Index
  fully qualified names 91, 216                      Wildcard characters 53
  parent 124                                         WITH operator 74
  searching multiple 109                             WITH_S operator 74
  searching views from different databases 91, 114   WITH_S operator, examples 78
  specifying 18                                      WITHIN clause
                                                       WITHIN 1 SECTION 69
                                                       WITHIN n CONTEXT 69
W                                                      WITHIN n SUBFIELDS 69
WAIT parameter 214                                     WITHIN n WORDS 69
WEEKDAY function 62                                  WRITEACCESS function 62
WHERE clauses
  nested 90
  overview 19
                                                     Y
Wildcard characters                                  YYYYMMDD function 62
  See also # (pound sign)




                                                                                    Index  231
232  Index

				
DOCUMENT INFO
Shared By:
Categories:
Stats:
views:4
posted:10/12/2010
language:English
pages:8