Warning: mysql_fetch_array() expects parameter 1 to be resource, boolean given in /home/newdedyk/domains/bkmanuals.com/public_html/includes/pages/manual_inc.php on line 26
Fujitsu UDS/SQL V2.5 manuale d’uso - BKManuals

Fujitsu UDS/SQL V2.5 manuale d’uso

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
187
188
189
190
191
192
193
194
195
196
197
198
199
200
201
202
203
204
205
206
207
208
209
210
211
212
213
214
215
216
217
218
219
220
221
222
223
224
225
226
227
228
229
230
231
232
233
234
235
236
237
238
239
240
241
242
243
244
245
246
247
248
249
250
251
252
253
254
255
256
257
258
259
260
261
262
263
264
265
266
267
268
269
270
271
272
273
274
275
276
277
278
279
280
281
282
283
284
285
286
287
288
289
290
291
292
293
294
295
296
297
298
299
300
301
302
303
304
305
306
307
308
309
310
311
312
313
314
315
316
317
318
319
320
321
322
323
324

Vai alla pagina of

Un buon manuale d’uso

Le regole impongono al rivenditore l'obbligo di fornire all'acquirente, insieme alle merci, il manuale d’uso Fujitsu UDS/SQL V2.5. La mancanza del manuale d’uso o le informazioni errate fornite al consumatore sono la base di una denuncia in caso di inosservanza del dispositivo con il contratto. Secondo la legge, l’inclusione del manuale d’uso in una forma diversa da quella cartacea è permessa, che viene spesso utilizzato recentemente, includendo una forma grafica o elettronica Fujitsu UDS/SQL V2.5 o video didattici per gli utenti. La condizione è il suo carattere leggibile e comprensibile.

Che cosa è il manuale d’uso?

La parola deriva dal latino "instructio", cioè organizzare. Così, il manuale d’uso Fujitsu UDS/SQL V2.5 descrive le fasi del procedimento. Lo scopo del manuale d’uso è istruire, facilitare lo avviamento, l'uso di attrezzature o l’esecuzione di determinate azioni. Il manuale è una raccolta di informazioni sull'oggetto/servizio, un suggerimento.

Purtroppo, pochi utenti prendono il tempo di leggere il manuale d’uso, e un buono manuale non solo permette di conoscere una serie di funzionalità aggiuntive del dispositivo acquistato, ma anche evitare la maggioranza dei guasti.

Quindi cosa dovrebbe contenere il manuale perfetto?

Innanzitutto, il manuale d’uso Fujitsu UDS/SQL V2.5 dovrebbe contenere:
- informazioni sui dati tecnici del dispositivo Fujitsu UDS/SQL V2.5
- nome del fabbricante e anno di fabbricazione Fujitsu UDS/SQL V2.5
- istruzioni per l'uso, la regolazione e la manutenzione delle attrezzature Fujitsu UDS/SQL V2.5
- segnaletica di sicurezza e certificati che confermano la conformità con le norme pertinenti

Perché non leggiamo i manuali d’uso?

Generalmente questo è dovuto alla mancanza di tempo e certezza per quanto riguarda la funzionalità specifica delle attrezzature acquistate. Purtroppo, la connessione e l’avvio Fujitsu UDS/SQL V2.5 non sono sufficienti. Questo manuale contiene una serie di linee guida per funzionalità specifiche, la sicurezza, metodi di manutenzione (anche i mezzi che dovrebbero essere usati), eventuali difetti Fujitsu UDS/SQL V2.5 e modi per risolvere i problemi più comuni durante l'uso. Infine, il manuale contiene le coordinate del servizio Fujitsu in assenza dell'efficacia delle soluzioni proposte. Attualmente, i manuali d’uso sotto forma di animazioni interessanti e video didattici che sono migliori che la brochure suscitano un interesse considerevole. Questo tipo di manuale permette all'utente di visualizzare tutto il video didattico senza saltare le specifiche e complicate descrizioni tecniche Fujitsu UDS/SQL V2.5, come nel caso della versione cartacea.

Perché leggere il manuale d’uso?

Prima di tutto, contiene la risposta sulla struttura, le possibilità del dispositivo Fujitsu UDS/SQL V2.5, l'uso di vari accessori ed una serie di informazioni per sfruttare totalmente tutte le caratteristiche e servizi.

Dopo l'acquisto di successo di attrezzature/dispositivo, prendere un momento per familiarizzare con tutte le parti del manuale d'uso Fujitsu UDS/SQL V2.5. Attualmente, sono preparati con cura e tradotti per essere comprensibili non solo per gli utenti, ma per svolgere la loro funzione di base di informazioni e di aiuto.

Sommario del manuale d’uso

  • Pagina 1

    Editi on Septemb er 2007 © Sieme ns Nixdor f Informat ionssys teme AG 1995 Pfad: G:vogt fscuds Manual eenuds ent_eu dsent.vor UDS/SQL V2.5 Design and Definition[...]

  • Pagina 2

    Comments … Suggestions … Correctio ns … The Us er Docu mentation Department wo uld li ke t o kno w y our opini on on this ma nual. Y our feedb ack helps us to op timize ou r docu mentatio n to su it y our ind ividu al need s. F eel free to se nd us y our co mment s by e-mail to : manu als@fuj i tsu-si emens .com Certifi ed docume ntatio n acc[...]

  • Pagina 3

    U929-J-Z125-9- 76 Dokus chablonen 19x24 Version 7.3us für FrameMaker V7.x vom 14.02.2 007 © cognit as GmbH 20 01-2007 24. Octob er 2007 Stand 09:57 .43 P fad: G:vogtfs cudsM anualee nudsent _euds ent.ivz Contents 1 Preface . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 9 1.1 Brief product description . [...]

  • Pagina 4

    Contents U929-J-Z125-9-76 3.3 T echnical implementa tion . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 50 3.3.1 Definin g the logi cal struc ture of a UDS/SQL datab ase . . . . . . . . . . . . . . . . . 50 3.3.2 Definin g the physical stru cture of a UDS /SQL data base . . . . . . . . . . . . . . . . 51 3.3.3 Views . . . . . . . . .[...]

  • Pagina 5

    Contents U929-J-Z125-9- 76 Dokus chablonen 19x24 Version 7.3us für FrameMaker V7.x vom 14.02.2 007 © cognit as GmbH 20 01-2007 24. Octob er 2007 Stand 09:57 .43 P fad: G:vogtfs cudsM anualee nudsent _euds ent.ivz 4.11 Assigni ng name and privacy to a schema . . . . . . . . . . . . . . . . . . . . . 111 4.12 Comprehensive example of DDL app[...]

  • Pagina 6

    Contents U929-J-Z125-9-76 6 Definition of the us er interf ace to the dat abase . . . . . . . . . . . . . . . . . . 183 6.1 Subschema DDL . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 183 6.1.1 Introduction . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 183 6.1.2 Assigning name and pr ivacy to a su[...]

  • Pagina 7

    Contents U929-J-Z125-9- 76 Dokus chablonen 19x24 Version 7.3us für FrameMaker V7.x vom 14.02.2 007 © cognit as GmbH 20 01-2007 24. Octob er 2007 Stand 09:57 .43 P fad: G:vogtfs cudsM anualee nudsent _euds ent.ivz 9 Reference sec tion . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 233 9.1 Schema DDL syntax . . . . . .[...]

  • Pagina 8

    Contents U929-J-Z125-9-76[...]

  • Pagina 9

    U929-J-Z125-9- 76 9 Dokus chablonen 19x24 Version 7.3us für FrameMaker V7.x vom 14.02.2 007 © cognit as GmbH 20 01-2007 24. Oktobe r 2007 Stand 08:47 .56 Pfa d: G:vogtfsc udsM anualee nudse nt_euds ent.k01 1 Preface 1.1 Brief pr od uct descri ption The U niv ersal D atabase S ystem UDS/SQL is a high-performanc e databa se system bas ed on [...]

  • Pagina 10

    T arget group Preface 10 U929-J-Z125-9-76 1.2 T arget group This manual i s inten ded to suppor t datab ase d esigner s in designin g the l ogical and ph ysical str ucture of th eir data base and des cribi ng it with D DL and SSL . Fur ther mor e, the manual explains how to make database data available to users in the form they require b y using th[...]

  • Pagina 11

    Preface Su mma ry of conte nts U929-J-Z125-9- 76 11 Dokus chablonen 19x24 Version 7.3us für FrameMaker V7.x vom 14.02.2 007 © cognit as GmbH 20 01-2007 24. Oktobe r 2007 Stand 08:47 .56 Pfa d: G:vogtfsc udsM anualee nudse nt_euds ent.k01 1.3 Summary of contents What does thi s man ual con tain ? The “Gen eral” chapte r contains general[...]

  • Pagina 12

    Summary of contents Preface 12 U929-J-Z125-9-76 Fur ther manuals de scr ibing add itional U DS/SQL p roducts and funct ions are listed o n page 15 . For a basic intr oduction you should r ef er to ch apters 2 and 3 of the “Des ign and D efinition ” manual; the se ch apters d escri be – reas ons for using data bases – th e COD ASYL dat abase[...]

  • Pagina 13

    Preface Su mma ry of conte nts U929-J-Z125-9- 76 13 Dokus chablonen 19x24 Version 7.3us für FrameMaker V7.x vom 14.02.2 007 © cognit as GmbH 20 01-2007 24. Oktobe r 2007 Stand 08:47 .56 Pfa d: G:vogtfsc udsM anualee nudse nt_euds ent.k01 Contents of the fiv e main man uals User task Design and defi niti on COBOL/ CALL DML programm ing SQL [...]

  • Pagina 14

    Summary of contents Preface 14 U929-J-Z125-9-76 Manua l UDS/SQL Crea tion and Restructur ing Pref ace – – – B – B B – Over view – – – B B – – – Databa se cre ation – – – L – – – – Defini ng access rights – – – L – – – – Storing an d unloadi ng data D – – L – D – – Rest ruct ur ing th e dat[...]

  • Pagina 15

    Preface Su mma ry of conte nts U929-J-Z125-9- 76 15 Dokus chablonen 19x24 Version 7.3us für FrameMaker V7.x vo m 14.02.2 007 © cognit as GmbH 20 01-2007 24. Okt ober 2007 Stand 08:47 .56 Pfa d: G:vogtf scudsM anualee nudse nt_euds ent.k01 B → provides basic i nf or mation if you ha ve no e xper ience of UDS /SQL L → helps y[...]

  • Pagina 16

    Readme file Preface 16 U929-J-Z125-9-76 Additional notes on the manu als References to other m anuals app ear in abbre viated form. The following distin ction is mad e: (see “Applicat ion Programmin g” manual, CONNECT) a dvises you to look up C ONNECT i n the “Applic ation Programming ” manual. The comp lete ti tles of th e manuals can b e [...]

  • Pagina 17

    Preface C hanges s ince the l ast versi on U929-J-Z125-9- 76 17 Dokus chablonen 19x24 Version 7.3us für FrameMaker V7.x vo m 14.02.2 007 © cognit as GmbH 20 01-2007 24. Okt ober 2007 Stand 08:47 .56 Pfa d: G:vogtf scudsM anualee nudse nt_euds ent.k01 1.5 Changes since the l ast ver sion The mai n changes i ntroduce d in UDS/SQL V2.5 in c o[...]

  • Pagina 18

    Chang es since the last version Preface 18 U929-J-Z125-9-76 Session job va riable Additional inf or mation DBO 9 Database job v ariable New job v ariab le wit h inf or matio n on the s tatus o f a databa se DBO 9 Renaming data base o bjects New utility ro utine BRENAM E f or renam ing datab ase obje cts CRE 7 New sta temen t RENAME in the BGSIA uti[...]

  • Pagina 19

    Preface C hanges s ince the l ast versi on U929-J-Z125-9- 76 19 Dokus chablonen 19x24 Version 7.3us für FrameMaker V7.x vo m 14.02.2 007 © cognit as GmbH 20 01-2007 24. Okt ober 2007 Stand 08:47 .56 Pfa d: G:vogtf scudsM anualee nudse nt_euds ent.k01 BCHANGE utility r outine Delimita tion fro m renami ng of data base o bjects CRE 6 Inf orm[...]

  • Pagina 20

    Chang es since the last version Preface 20 U929-J-Z125-9-76 BPRECORD utility r outine Inf ormation on U DS/S QL pubse t decl arat ion RIR 7 BPRIV A CY utility routin e Inf ormation on a utoma tic realm e xtension and UDS/SQL pu bset dec lara tion CRE 4 BPSIA utility r outine Inf ormation on U DS/S QL pubse t decl arat ion RIR 4 BPSQLSIA utility r o[...]

  • Pagina 21

    Preface C hanges s ince the l ast versi on U929-J-Z125-9- 76 21 Dokus chablonen 19x24 Version 7.3us für FrameMaker V7.x vo m 14.02.2 007 © cognit as GmbH 20 01-2007 24. Okt ober 2007 Stand 08:47 .56 Pfa d: G:vogtf scudsM anualee nudse nt_euds ent.k01 Messag es Ne w messa ges UDS07 46 - UDS075 5 M SG 2 Modifie d message UDS072 8 MSG 2 Addit[...]

  • Pagina 22

    Notational c on ventions Preface 22 U929-J-Z125-9-76 1.6 Notational con ventions This section provides an explanation of the not ational c onv e ntions us ed to d escri be synta x rul es . 1.6.1 W arnings and notes 1.6.2 Non-SDF notational con ventions P oints out par ticular ly impo r tant inf or mation CA UTION! W ar nings Language el ement Expla[...]

  • Pagina 23

    Preface N otational conventions U929-J-Z125-9- 76 23 Dokus chablonen 19x24 Version 7.3us für FrameMaker V7.x vo m 14.02.2 007 © cognit as GmbH 20 01-2007 24. Okt ober 2007 Stand 08:47 .56 Pfa d: G:vogtf scudsM anualee nudse nt_euds ent.k01 All othe r characters such as ( ) , . ; “ = are not meta characters: they must be spe cified exactl[...]

  • Pagina 24

    Notational c on ventions Preface 24 U929-J-Z125-9-76[...]

  • Pagina 25

    U929-J-Z125-9- 76 25 Dokus chablonen 19x24 Version 7.3us für FrameMaker V7.x vo m 14.02.2 007 © cognit as GmbH 20 01-2007 18. Okt ober 2007 Stand 11:29 .48 Pfa d: G:vogtf scudsM anualee nudse nt_euds ent.k02 2 Gen era l inf ormat ion This chap ter provide s general infor mation on m aintai ning data an d usin g database s. It also ex plain[...]

  • Pagina 26

    Modern data or ganization General i nformati on 26 U929-J-Z125-9-76 How and by whom data is used at the different lev els in an org anizatio n company , is shown in the fi gure 1 in form o f an inform ation pyramid. Figure 1: Flow of data and inf ormation in an organization The ba sis for physical data s torage and l ogical data organ ization withi[...]

  • Pagina 27

    General i nformation Modern data organization U929-J-Z125-9- 76 27 Dokus chablonen 19x24 Version 7.3us für FrameMaker V7.x vo m 14.02.2 007 © cognit as GmbH 20 01-2007 18. Okt ober 2007 Stand 11:29 .48 Pfa d: G:vogtf scudsM anualee nudse nt_euds ent.k02 The us e of a data base sy stem re sults i n a notic eable reduct ion of costs, par tic[...]

  • Pagina 28

    COD ASYL model General i nformati on 28 U929-J-Z125-9-76 2.2 Data models The UDS /SQL datab ase syste m suppor ts both the networ k mode l (CODASYL model) and the rela tional mode l. It encompa sses the pr inciples and capabi lities of bo th the COD ASYL and the relational mo dels in a single system. UDS/S QL can be r egarded as the im plemen - tat[...]

  • Pagina 29

    General i nformation CODASYL model U929-J-Z125-9- 76 29 Dokus chablonen 19x24 Version 7.3us für FrameMaker V7.x vo m 14.02.2 007 © cognit as GmbH 20 01-2007 18. Okt ober 2007 Stand 11:29 .48 Pfa d: G:vogtf scudsM anualee nudse nt_euds ent.k02 The set between the SU PPLIER and ARTICLE record types has the name SUPPLIES. In the SUPPLI ES set[...]

  • Pagina 30

    COD ASYL model General i nformati on 30 U929-J-Z125-9-76 Relationships between r ecord types and r eferential inte grity In figure 2 , the SUP PLIES se t indicate s that a record of the ARTICLE recor d type is n ot an isolated record, but is assigned to a recor d of the SUPPLIE R record t ype. In UDS/SQL , it is possi b le to d eclare in a se t def[...]

  • Pagina 31

    General i nformation Relational model U929-J-Z125-9- 76 31 Dokus chablonen 19x24 Version 7.3us für FrameMaker V7.x vo m 14.02.2 007 © cognit as GmbH 20 01-2007 18. Okt ober 2007 Stand 11:29 .48 Pfa d: G:vogtf scudsM anualee nudse nt_euds ent.k02 2.2.2 Relational model The relati onal mod el is bas ed on the theoretic al work o f E.F . Codd[...]

  • Pagina 32

    Relational model General info rmation 32 U929-J-Z125-9-76 The following list shows the ter ms used in this manual and the co rrespondi ng formal ter ms defined b y Codd: In the r elational model, the data is m anaged an d process ed in the for m of tables. Different types of tables e xist: – bas e tab les – res ult tables –v i e w s Base tabl[...]

  • Pagina 33

    General i nformation Relational model U929-J-Z125-9- 76 33 Dokus chablonen 19x24 Version 7.3us für FrameMaker V7.x vo m 14.02.2 007 © cognit as GmbH 20 01-2007 18. Okt ober 2007 Stand 11:29 .48 Pfa d: G:vogtf scudsM anualee nudse nt_euds ent.k02 Relationships b etween tables In the cas e of relati onal data o rganiza tion, recor d types ar[...]

  • Pagina 34

    Relational model General info rmation 34 U929-J-Z125-9-76 SQL - a uniform language for relational database systems Dev el opment of th e theor y o f relatio nal databa ses by Codd an d others was paralleled by work on the use r inter f a ce for such sy stems. The initial results of this wor k were fir st prese nted in the “Sys tem R” prototype [...]

  • Pagina 35

    General i nformation Relative merit s of the data models U929-J-Z125-9- 76 35 Dokus chablonen 19x24 Version 7.3us für FrameMaker V7.x vo m 14.02.2 007 © cognit as GmbH 20 01-2007 18. Okt ober 2007 Stand 11:29 .48 Pfa d: G:vogtf scudsM anualee nudse nt_euds ent.k02 2.2.3 Relative merits of the da ta models Compar ing the data models with on[...]

  • Pagina 36

    Coexistence General i nformation 36 U929-J-Z125-9-76 2.2.4 Co existence of the COD ASYL and re lational models A deci sion to use UDS /SQL is no t a decisi on in fav o r of the CODASYL model an d against the rel ational m odel. UD S/SQL supp or ts both mod els withi n a sing le databas e system, which i s conseque ntly re f e rred to a s the coexis[...]

  • Pagina 37

    General i nformation Coexisten ce U929-J-Z125-9- 76 37 Dokus chablonen 19x24 Version 7.3us für FrameMaker V7.x vo m 14.02.2 007 © cognit as GmbH 20 01-2007 18. Okt ober 2007 Stand 11:29 .48 Pfa d: G:vogtf scudsM anualee nudse nt_euds ent.k02 This res ults in two diff erent u ser views of a UDS /SQL da tabase, as is s hown in fig ure 4 belo[...]

  • Pagina 38

    Coexistence General i nformation 38 U929-J-Z125-9-76 In summ ar y , UDS/SQ L offers the following options f or combi ning pro gram interf aces a nd data organ izations: Figure 5: Coe xistence of interf aces and data models in UDS/SQL Relational SQL program interface → COD ASYL data organizati on (RC) Via the relatio nal SQL pr ogram interface, ap[...]

  • Pagina 39

    General i nformation Coexisten ce U929-J-Z125-9- 76 39 Dokus chablonen 19x24 Version 7.3us für FrameMaker V7.x vo m 14.02.2 007 © cognit as GmbH 20 01-2007 18. Okt ober 2007 Stand 11:29 .48 Pfa d: G:vogtf scudsM anualee nudse nt_euds ent.k02 Relational SQL pr ogram interface → relational data or ganization (RR) Via the r elationa l SQL p[...]

  • Pagina 40

    Coexistence General i nformation 40 U929-J-Z125-9-76 Interface suitabilit y The COBO L-DML o r CALL-DML interface is typic ally used for – hi gh-end OL TP appli cations and extremely p erforman ce-cr itical applica tions (Online T ransaction Proc essing) a nd – spec ial ap plicatio ns that r un espec ially effi ciently with networ k str uctures[...]

  • Pagina 41

    General i nformation Univers al Database Sy stem UDS/SQ L U929-J-Z125-9- 76 41 Dokus chablonen 19x24 Version 7.3us für FrameMaker V7.x vo m 14.02.2 007 © cognit as GmbH 20 01-2007 18. Okt ober 2007 Stand 11:29 .48 Pfa d: G:vogtf scudsM anualee nudse nt_euds ent.k02 2.3 Universal Database Syste m UDS/SQL The U niversal D ata base S ystem UD[...]

  • Pagina 42

    Universal Database System UDS/ SQL General info rmation 42 U929-J-Z125-9-76 ● Central dat a protection measur es UDS/SQL incor porates eff ective, fle xibly usable protecti v e mechan isms to ensu re that each user grou p can a ccess on ly pre cisely d efined pa r ts an d se ctions of the da tabase. UDS/SQL checks the user’s access ri ghts befo[...]

  • Pagina 43

    U929-J-Z125-9- 76 43 Dokus chablonen 19x24 Version 7.3us für FrameMaker V7.x vo m 14.02.2 007 © cognit as GmbH 20 01-2007 18. Okt ober 2007 Stand 11:29 .49 Pfa d: G:vogtf scudsM anualee nudse nt_euds ent.k03 3 Designing the database In order to desi gn a database wi th product-s pecific language re source s, it is first neces sar y to make[...]

  • Pagina 44

    Data modeling Datab ase desi gn 44 U929-J-Z125-9-76 The an alytical p rocess y ields a mod el which descr ibes t he designated section of the re al worl d in such a wa y that the da ta can be ad minis ter ed w ith a da taba se sys tem . The da ta is comple te, consiste nt and available in nor mali zed f or m. The type of relati onsh ips existing be[...]

  • Pagina 45

    Database d esign Database distribut ion U929-J-Z125-9- 76 45 Dokus chablonen 19x24 Version 7.3us für FrameMaker V7.x vo m 14.02.2 007 © cognit as GmbH 20 01-2007 18. Okt ober 2007 Stand 11:29 .49 Pfa d: G:vogtf scudsM anualee nudse nt_euds ent.k03 3.2 Dis tributing t he da ta The data resour ces may be dist ributed over sev eral databas es[...]

  • Pagina 46

    Database distrib ution Datab ase desi gn 46 U929-J-Z125-9-76 One DBH - m ultiple dat abases This constella tion is also r ef erred t o as multi -DB operat ion. Many ap plication p rograms wor k with two or more data bases simul taneously . An applic ation pro gram (AP) may access se v eral da taba ses w ith in a sin gle t ran sac tion. The D BH c o[...]

  • Pagina 47

    Database d esign Database distribut ion U929-J-Z125-9- 76 47 Dokus chablonen 19x24 Version 7.3us für FrameMaker V7.x vo m 14.02.2 007 © cognit as GmbH 20 01-2007 18. Okt ober 2007 Stand 11:29 .49 Pfa d: G:vogtf scudsM anualee nudse nt_euds ent.k03 Multiple DBHs - m ultiple databases Multi-D B operation is als o possible with databases belo[...]

  • Pagina 48

    Database distrib ution Datab ase desi gn 48 U929-J-Z125-9-76 Reasons f or dist ributing data bases am ong sev eral computer s within a networ k: – Adaptabi lity W ork process es can be optimized for the loca l computer center , and data st orage can be adapte d ev e n better to the organiz ation of th e company . – A vailability When di stri b [...]

  • Pagina 49

    Database d esign Database distribut ion U929-J-Z125-9- 76 49 Dokus chablonen 19x24 Version 7.3us für FrameMaker V7.x vo m 14.02.2 007 © cognit as GmbH 20 01-2007 18. Okt ober 2007 Stand 11:29 .49 Pfa d: G:vogtf scudsM anualee nudse nt_euds ent.k03 Reasons f or having two or mor e config urations on a s ingle ho st: – Improved performan c[...]

  • Pagina 50

    T echnical implementation Datab ase desi gn 50 U929-J-Z125-9-76 3.3 T ech nical implementa tion 3.3.1 Defining th e logi cal stru cture of a UDS/SQL database The lo gical s tructur e of a UDS/ SQL data base, i.e. the UDS/S QL schema , can be de fined on the ba sis of ei ther the COD ASYL con cept or t he relation al conce pt. COD ASYL database desi[...]

  • Pagina 51

    Database d esign Technical imp lementati on U929-J-Z125-9- 76 51 Dokus chablonen 19x24 Version 7.3us für FrameMaker V7.x vo m 14.02.2 007 © cognit as GmbH 20 01-2007 18. Okt ober 2007 Stand 11:29 .49 Pfa d: G:vogtf scudsM anualee nudse nt_euds ent.k03 3.3.2 Defining the ph ysical s tru cture of a UDS/SQL database T o define the physical da[...]

  • Pagina 52

    T echnical implementation Datab ase desi gn 52 U929-J-Z125-9-76[...]

  • Pagina 53

    U929-J-Z125-9- 76 53 Dokus chablonen 19x24 Version 7.3us für FrameMaker V7.x vo m 14.02.2 007 © cognit as GmbH 20 01-2007 24. Okt ober 2007 Stand 09:30 .23 Pfa d: G:vogtf scudsM anualee nudse nt_euds ent.k04 4 Schema DDL 4.1 Intr oduction Before you star t des igning a UDS /SQL sche ma, it is fi rst nece ssar y to thoroughl y analyze the i[...]

  • Pagina 54

    Intr oduction Schema DDL 54 U929-J-Z125-9-76 Realm Na med physical subdivi sion of the dat abase. Manageme nt unit for data privacy and secu rity as well as for handling concurr ent access es. The la nguage el ements of t he DDL wh ich are us ed to defin e the da ta units a re descr ibed on page 55 through page 70 . The no tational c onv e ntion ar[...]

  • Pagina 55

    Schema D DL Defining an item U929-J-Z125-9- 76 55 Dokus chablonen 19x24 Version 7.3us für FrameMaker V7.x vo m 14.02.2 007 © cognit as GmbH 20 01-2007 24. Okt ober 2007 Stand 09:30 .23 Pfa d: G:vogtf scudsM anualee nudse nt_euds ent.k04 4.2 Defining an it em An “ite m” is the s mallest unit of data within a r ecord typ e that can be as[...]

  • Pagina 56

    Defining an item Schema DDL 56 U929-J-Z125-9-76 4.2.1 De fining an unpacked numeric ite m [ level- numbe r ] it em-nam e PIC TURE I S mask-str ing . Unpacked items can contain num eric values only . T he y can be used for ari thmetic opera - tions a nd can be prin ted out. level-number specifies whe ther the i tem is pa r t of a r epeating gr oup: [...]

  • Pagina 57

    Schema D DL Defining an item U929-J-Z125-9- 76 57 Dokus chablonen 19x24 Version 7.3us für FrameMaker V7.x vo m 14.02.2 007 © cognit as GmbH 20 01-2007 24. Okt ober 2007 Stand 09:30 .23 Pfa d: G:vogtf scudsM anualee nudse nt_euds ent.k04 Y ou can define the item to ho ld up to 18 digits. If at leas t one of the f ollowing as ser ti ons appl[...]

  • Pagina 58

    Defining an item Schema DDL 58 U929-J-Z125-9-76 4.2.2 Defining a pac ked numeric item [ level- numbe r ] it em-nam e TYPE IS FI XED REAL DE C IMAL [ inte ger-1 [, integ er-2 ]] . P ack ed items ca n contai n numeri c values only . They are exclusively used as computa tional items by the database programmer and cannot be prin ted wit hout pr ior edi[...]

  • Pagina 59

    Schema D DL Defining an item U929-J-Z125-9- 76 59 Dokus chablonen 19x24 Version 7.3us für FrameMaker V7.x vo m 14.02.2 007 © cognit as GmbH 20 01-2007 24. Okt ober 2007 Stand 09:30 .23 Pfa d: G:vogtf scudsM anualee nudse nt_euds ent.k04 4.2.3 Defining a binary item ⎧ 15 ⎫ [ leve l-num ber ] item-n ame TYPE IS FIXED R EAL BI N ARY[ ⎨ [...]

  • Pagina 60

    Defining an item Schema DDL 60 U929-J-Z125-9-76 4.2.4 D efin ing an al phanume ric item of fixed length ⎧ PIC TURE I S mask- string ⎫ [ level- numbe r ] it em-nam e ⎨ ⎬ . ⎩ TYPE I S CH AR ACTER intege r ⎭ Alphanume ric items c an contai n any type of character. level-number denotes whethe r the item is par t of a rep eating grou p: If t[...]

  • Pagina 61

    Schema D DL Defining an item U929-J-Z125-9- 76 61 Dokus chablonen 19x24 Version 7.3us für FrameMaker V7.x vo m 14.02.2 007 © cognit as GmbH 20 01-2007 24. Okt ober 2007 Stand 09:30 .23 Pfa d: G:vogtf scudsM anualee nudse nt_euds ent.k04 inte ger specifi es the numbe r of storage loc ations th e item con tains, each sto rage location being [...]

  • Pagina 62

    Defining an item Schema DDL 62 U929-J-Z125-9-76 Since the record mus t also cont ain at leas t the record l ength item item-name-2 in add ition to the variable item , the maxi mum length o f the varia b le item is equal to: – 20 10 bytes for a 2048-byte page len gth – 39 58 bytes for a 4000-byte page len gth – 80 54 bytes for a 8096-byte page[...]

  • Pagina 63

    Schema D DL Defining an item U929-J-Z125-9- 76 63 Dokus chablonen 19x24 Version 7.3us für FrameMaker V7.x vo m 14.02.2 007 © cognit as GmbH 20 01-2007 24. Okt ober 2007 Stand 09:30 .23 Pfa d: G:vogtf scudsM anualee nudse nt_euds ent.k04 4.2.6 Defining a na tiona l item ( UTF-1 6) Detailed i nf or matio n is provided in the CO BOL2000 “ L[...]

  • Pagina 64

    Defining an item Schema DDL 64 U929-J-Z125-9-76 4.2.7 Defining a databa se ke y it em ⎧ D ATABASE -KEY . ⎫ [ level- numbe r ] it em-nam e TYPE IS ⎨ ⎬ ⎩ D ATABASE -KEY-L ONG. ⎭ Datab ase ke y items ar e binar y i tems that ar e intende d for stor ing data base key v alues. At the sam e time, they are the onl y items who se conten ts are [...]

  • Pagina 65

    Schema D DL Defining a vector U929-J-Z125-9- 76 65 Dokus chablonen 19x24 Version 7.3us für FrameMaker V7.x vo m 14.02.2 007 © cognit as GmbH 20 01-2007 24. Okt ober 2007 Stand 09:30 .23 Pfa d: G:vogtf scudsM anualee nudse nt_euds ent.k04 4.3 Defining a vector ⎧ PI C TURE ..... ⎫ [ leve l-num ber ] vector -name ⎨ ⎬ OCCURS integer TI[...]

  • Pagina 66

    Defining a r epeating gr oup Schema DDL 66 U929-J-Z125-9-76 4.4 Defining a repeating group [ level- numbe r-1 ] grou p-ite m-na me OCCURS in teger TI MES. ⎧ ⎧ PICTURE ..... ⎫ ⎫ ⎨ level- numbe r-2 reco rd-elem ent- name [ ⎨ ⎬ ][ OCCUR S .....] . ⎬ ... ⎩ ⎩ TYPE ..... ⎭ ⎭ A group i tem is a named group ing of re cord el ements [...]

  • Pagina 67

    Schema D DL Defining a repeating group U929-J-Z125-9- 76 67 Dokus chablonen 19x24 Version 7.3us für FrameMaker V7.x vo m 14.02.2 007 © cognit as GmbH 20 01-2007 24. Okt ober 2007 Stand 09:30 .23 Pfa d: G:vogtf scudsM anualee nudse nt_euds ent.k04 Example 01 ADDR ESSE S OCCUR S 2 TIME S. 02 CUST -ADDRES S PICT URE IS X(20 ) OCCU RS 2 T IMES[...]

  • Pagina 68

    Gr ouping to for m a record type Schema DDL 68 U929-J-Z125-9-76 4.5 Groupi ng recor d elements to f orm a recor d type RECORD NAME IS record -name . . . ⎧ ⎧ PI C TURE ..... ⎫ ⎫ ⎨ [ level- numb er ] re cord-el ement- name [ ⎨ ⎬ ][ OCCU RS .. ...]. ⎬ ... ⎩ ⎩ TY PE .... . ⎭ ⎭ A recor d type is a named c ollection o f record e l[...]

  • Pagina 69

    Schema D DL Grouping to form a record type U929-J-Z125-9- 76 69 Dokus chablonen 19x24 Version 7.3us für FrameMaker V7.x vo m 14.02.2 007 © cognit as GmbH 20 01-2007 24. Okt ober 2007 Stand 09:30 .23 Pfa d: G:vogtf scudsM anualee nudse nt_euds ent.k04 Example RECORD NA ME IS CUS TOMER . . . 01 C-NO PICTURE IS 9(10). 01 C-NA ME PICT URE IS X[...]

  • Pagina 70

    Linking record ty pes Schema DDL 70 U929-J-Z125-9-76 4.6 Linking the recor ds of tw o recor d types to f orm a se t UDS/SQ L depicts the relati onships and interdep endencie s of infor mation existing in a cor porate or ganizat ion and a p lanned dat abase applica tion as rel ationships between record types using the set c oncept. In a rel ational [...]

  • Pagina 71

    Schema D DL Linking record ty pes U929-J-Z125-9- 76 71 Dokus chablonen 19x24 Version 7.3us für FrameMaker V7.x vo m 14.02.2 007 © cognit as GmbH 20 01-2007 24. Okt ober 2007 Stand 09:30 .23 Pfa d: G:vogtf scudsM anualee nudse nt_euds ent.k04 Sets and set oc currenc es are rep resented acco rding to the f oll owing pri nciple: Figure 12: Re[...]

  • Pagina 72

    Linking record ty pes Schema DDL 72 U929-J-Z125-9-76 Example RECORD NAME IS SUPPLI ER . . . RECORD NAME IS ARTICL E . . . SET N AME I S ARTI CLES-AV AILABL E . . . OWNER IS SUPPLI ER. MEMBE R IS ARTICL E..... . . . Figure 13: Set and set occurrences as defined abov e ARTIC LE Cocoa Stout Bitter Lager ARTIC LES ART ICLE S ARTI CLE S AVAILAB LE SUPPL[...]

  • Pagina 73

    Schema D DL Linking record ty pes U929-J-Z125-9- 76 73 Dokus chablonen 19x24 Version 7.3us für FrameMaker V7.x vo m 14.02.2 007 © cognit as GmbH 20 01-2007 24. Okt ober 2007 Stand 09:30 .23 Pfa d: G:vogtf scudsM anualee nudse nt_euds ent.k04 A record type c an be par t of sev e ral sets. This makes the set t he basic unit in ne twork-li ke[...]

  • Pagina 74

    Linking record ty pes Schema DDL 74 U929-J-Z125-9-76 Example of a 1:n r elationsh ip The r elations hip between c ustomer s and thei r orders is a 1:n relation ship. A cus tomer can pl ace sev eral orders, but each order can only be p laced by one cus tomer . Figure 15: 1:n relationship betw een CUSTO MER and ORDERS The logic al relationshi p is cr[...]

  • Pagina 75

    Schema D DL Linking record ty pes U929-J-Z125-9- 76 75 Dokus chablonen 19x24 Version 7.3us für FrameMaker V7.x vo m 14.02.2 007 © cognit as GmbH 20 01-2007 24. Okt ober 2007 Stand 09:30 .23 Pfa d: G:vogtf scudsM anualee nudse nt_euds ent.k04 m:n relat ionship betw een two record types (ma ny-to-many relationship) An m:n relat ionsh ip is a[...]

  • Pagina 76

    Linking record ty pes Schema DDL 76 U929-J-Z125-9-76 Figure 16: m:n relationship between ORDERS and AR TICLE ORDERS ITEM ARTICLE ORDER 1 ORDER 2 ORDER 3 ORDER 4 ORDER- QTY: 100 ORDER- QTY: 2 ORDER- QTY: 5 1 30 1 1 5 10 ARTICLE-NAME: RADIO ARTICLE-NAME: LAMP ARTICLE-NAME: CLOCK ARTICLE-NAME: KETTLE O RDE R: 3 CUST. : ERI C KETT LE RADI O 30 1 O RDE [...]

  • Pagina 77

    Schema D DL Linking record ty pes U929-J-Z125-9- 76 77 Dokus chablonen 19x24 Version 7.3us für FrameMaker V7.x vo m 14.02.2 007 © cognit as GmbH 20 01-2007 24. Okt ober 2007 Stand 09:30 .23 Pfa d: G:vogtf scudsM anualee nudse nt_euds ent.k04 The m:n rel ationship be tween ORDERS and ARTICLE is resol v ed to form two 1:n relation- ship s by[...]

  • Pagina 78

    Linking record ty pes Schema DDL 78 U929-J-Z125-9-76 Figure 17: m:n relationship within the record type P ARTS PARTS ASSEMBLY USED-IN PARTS-LIST QTY. SUBP ART PART-LIST PART BI CYCL E 1 1 2 1 1 2 WHEEL TIRE 1 1 TUBE BI CYCL E FRAME WHEEL RI M SPOKE TI RE CA SI NG 1 2 1 36 1 1 1 1 QTY. SUBPART PART-LIST PART QTY. SUBPAR T PART-LIST PART HANDLE - BAR[...]

  • Pagina 79

    Schema D DL Linking record ty pes U929-J-Z125-9- 76 79 Dokus chablonen 19x24 Version 7.3us für FrameMaker V7.x vo m 14.02.2 007 © cognit as GmbH 20 01-2007 24. Okt ober 2007 Stand 09:30 .23 Pfa d: G:vogtf scudsM anualee nudse nt_euds ent.k04 4.6.2 Defining the type of m embers hip of recor ds in a set ⎧ MAN D ATORY ⎫ ⎧ AUTO MATI C ?[...]

  • Pagina 80

    Linking record ty pes Schema DDL 80 U929-J-Z125-9-76 Example 1 Figure 18: Example of OPTIONAL A UT OMA TIC The li nk between a CUST OMER-OR DER record and a CUSTOMER reco rd is rel atively stable. An order o nly exists if a cus tomer has placed one. T he link to th e owner rec ord is thus au tomatic at the time th e CUST O MER-ORDE R record is sto [...]

  • Pagina 81

    Schema D DL Linking record ty pes U929-J-Z125-9- 76 81 Dokus chablonen 19x24 Version 7.3us für FrameMaker V7.x vo m 14.02.2 007 © cognit as GmbH 20 01-2007 24. Okt ober 2007 Stand 09:30 .23 Pfa d: G:vogtf scudsM anualee nudse nt_euds ent.k04 Example 2 The MANUAL option is u sed if, f or e xample, a re cord type i s a membe r type of two se[...]

  • Pagina 82

    Linking record ty pes Schema DDL 82 U929-J-Z125-9-76 Example 3 The MA NU AL option is used in cyclic data str uctur es, i.e. a number of re cord types are connec ted in su ch a way that each re cord type i s at the sam e time owner of one set an d member in anothe r . Figure 20: T ype of set membership in a cycle If all sets o f a cycle were defi n[...]

  • Pagina 83

    Schema D DL Linking record ty pes U929-J-Z125-9- 76 83 Dokus chablonen 19x24 Version 7.3us für FrameMaker V7.x vo m 14.02.2 007 © cognit as GmbH 20 01-2007 24. Okt ober 2007 Stand 09:30 .23 Pfa d: G:vogtf scudsM anualee nudse nt_euds ent.k04 Example 4 In order to resolve a many-to- many relatio nship, it is necessa r y to define an auxi li[...]

  • Pagina 84

    T ypes of acce ss Schema DDL 84 U929-J-Z125-9-76 4.7 Access paths and record sequences The user can defi ne the following access types using DDL: – dir ect access on recor d type lev el A reco rd is sel ected f rom all rec ords of one recor d type via th e conte nt of an item or a combina tion o f items. – sequ ential access on reco rd type lev[...]

  • Pagina 85

    Schema D DL Types o f access U929-J-Z125-9- 76 85 Dokus chablonen 19x24 Version 7.3us für FrameMaker V7.x vo m 14.02.2 007 © cognit as GmbH 20 01-2007 24. Okt ober 2007 Stand 09:30 .23 Pfa d: G:vogtf scudsM anualee nudse nt_euds ent.k04 4.7.1 Direct a nd se quenti al acces s on recor d type le vel via database ke y va l u e The data base k[...]

  • Pagina 86

    T ypes of acce ss Schema DDL 86 U929-J-Z125-9-76 If LOCA TION MODE IS DIRE CT -LONG is specified, item -name must be d efined as a D A T ABASE-KEY -L ONG item . r ecor d-name speci fies the record type con taining th e databa se key item referred to by item-name . identifier specifie s the n ame of an i tem which is automa tically ge nerated by UDS[...]

  • Pagina 87

    Schema D DL Types o f access U929-J-Z125-9- 76 87 Dokus chablonen 19x24 Version 7.3us für FrameMaker V7.x vo m 14.02.2 007 © cognit as GmbH 20 01-2007 24. Okt ober 2007 Stand 09:30 .23 Pfa d: G:vogtf scudsM anualee nudse nt_euds ent.k04 4.7.2 Generating ad ditional ac cess pat hs f or direct access on re cor d type lev el Defining a primar[...]

  • Pagina 88

    T ypes of acce ss Schema DDL 88 U929-J-Z125-9-76 If you want to de fine a use r-specif ic hash routine, you must obse r v e the f o llowing reg ister conv entions: ● Before and after r unnin g the rout ine, all UDS/S QL regis ters except Regist er 1 must hav e the same content. The ha sh routine is branc hed to by BALR 1 4,15; retu r n to the UDS[...]

  • Pagina 89

    Schema D DL Types o f access U929-J-Z125-9- 76 89 Dokus chablonen 19x24 Version 7.3us für FrameMaker V7.x vo m 14.02.2 007 © cognit as GmbH 20 01-2007 24. Okt ober 2007 Stand 09:30 .23 Pfa d: G:vogtf scudsM anualee nudse nt_euds ent.k04 Example 1 The following e xemplifies th e conv ersion o f a key v a lue in to a physical addres s usin g[...]

  • Pagina 90

    T ypes of acce ss Schema DDL 90 U929-J-Z125-9-76 Example 2 This example s hows how a user can program a user-spe cific h ash routi ne. The program rep laces th e first two opera tions of th e UDS/SQL s tandard h ash routine by a divisi on/remai nder algor ithm. The en tire key v alue is conside red a positive binar y number whi ch is div ided by th[...]

  • Pagina 91

    Schema D DL Types o f access U929-J-Z125-9- 76 91 Dokus chablonen 19x24 Version 7.3us für FrameMaker V7.x vo m 14.02.2 007 © cognit as GmbH 20 01-2007 24. Okt ober 2007 Stand 09:30 .23 Pfa d: G:vogtf scudsM anualee nudse nt_euds ent.k04 Example in Assembler: BYTEHAS H CSEC T READ BYTEHAS H AMOD E ANY BYTEHAS H RMOD E ANY USING *,1 5 STM 4,[...]

  • Pagina 92

    T ypes of acce ss Schema DDL 92 U929-J-Z125-9-76 Definin g seconda ry keys for con version by hash routine SEARCH KEY IS item -name ,... USIN G CALC [ hash-r outine ] DU P LICATES ARE[ NOT] AL LOWE D A key decl ared by SEARCH KE Y IS... is a SE ARCH key or sec ondar y key . I t may consist of more th an one item (compo und ke y). item-name specifie[...]

  • Pagina 93

    Schema D DL Types o f access U929-J-Z125-9- 76 93 Dokus chablonen 19x24 Version 7.3us für FrameMaker V7.x vo m 14.02.2 007 © cognit as GmbH 20 01-2007 24. Okt ober 2007 Stand 09:30 .23 Pfa d: G:vogtf scudsM anualee nudse nt_euds ent.k04 Defining a second ary key f or direc t access via table SEARCH KEY IS item-n ame ,... USING INDEX [NAME [...]

  • Pagina 94

    T ypes of acce ss Schema DDL 94 U929-J-Z125-9-76 4.7.3 Determining th e or der of re cor ds withi n a set oc currence T wo basic con cepts i n deter mining th e logica l order of the mem ber records within a s et occurr ence can be distingu ished: – sor ting with out ke y values, and – sorting acco rding t o prim ary ke y value s They are des c[...]

  • Pagina 95

    Schema D DL Types o f access U929-J-Z125-9- 76 95 Dokus chablonen 19x24 Version 7.3us für FrameMaker V7.x vo m 14.02.2 007 © cognit as GmbH 20 01-2007 24. Okt ober 2007 Stand 09:30 .23 Pfa d: G:vogtf scudsM anualee nudse nt_euds ent.k04 ORDER IS LAST Specifi es that the order o f the membe r reco rds in a set occ urrence c orrespon ds to t[...]

  • Pagina 96

    T ypes of acce ss Schema DDL 96 U929-J-Z125-9-76 ORDER IS FIRST Speci fies the r e v erse order to tha t in which the member records we re chronolog ically ente red. Figure 23: Record sequence for ORDER IS FIRST ORDER IS NEXT/P RIOR If this type of or deri ng is spec ified, the database programmer has the poss ibility of estab- lishing a cer tai n [...]

  • Pagina 97

    Schema D DL Types o f access U929-J-Z125-9- 76 97 Dokus chablonen 19x24 Version 7.3us für FrameMaker V7.x vo m 14.02.2 007 © cognit as GmbH 20 01-2007 24. Okt ober 2007 Stand 09:30 .23 Pfa d: G:vogtf scudsM anualee nudse nt_euds ent.k04 Sets defi ned with O RDER IS NEX T or ORDER IS PRIOR cann ot be acces sed by SQL with INSERT or UPD A TE[...]

  • Pagina 98

    T ypes of acce ss Schema DDL 98 U929-J-Z125-9-76 Sor ting member records acco r ding to p rimary key va lues ⎧ D ATAB ASE-KEY ⎫ ORDER IS SORTED BY ⎨ ⎬ . ⎩ DEFINED KEYS DUP LICATES AR E[ NOT] ALL OWED ⎭ . . ⎧ ASC ENDING ⎫ ⎨ ⎬ KEY IS item -name ,. .. ⎩ DESC ENDING ⎭ ORDER IS SORTED BY DEFINED KEYS DUP LICA TE S ARE[ NO T] ALLO[...]

  • Pagina 99

    Schema D DL Types o f access U929-J-Z125-9- 76 99 Dokus chablonen 19x24 Version 7.3us für FrameMaker V7.x vo m 14.02.2 007 © cognit as GmbH 20 01-2007 24. Okt ober 2007 Stand 09:30 .23 Pfa d: G:vogtf scudsM anualee nudse nt_euds ent.k04 Figure 25: Sor ting a set occurr ence according t o the key AR T -NAME ORDE R IS SOR TED BY D A T ABAS E[...]

  • Pagina 100

    T ypes of acce ss Schema DDL 100 U929-J-Z 125-9-76 4.7.4 Ge nerati ng additi onal paths f or direct a ccess on se t le vel Unlike on rec ord lev el, on set l e v el UDS/S QL suppo r ts di rect acces s only vi a tables. Only SYSTEM se ts (see sectio n “SYSTEM s et” on p age 105 ) allow direct ac cess v ia a has h routin e. T wo ki nds of tables [...]

  • Pagina 101

    Schema D DL Types o f access U929-J-Z125-9- 76 101 Dokus chablonen 19x24 Version 7.3us für FrameMaker V7.x vo m 14.02.2 007 © cognit as GmbH 20 01-2007 24. Okt ober 2007 Stand 09:30 .23 Pfa d: G:vogtf scudsM anualee nudse nt_euds ent.k04 Example RECORD NA ME IS SUP PLIER . . . RECORD NA ME IS ART ICLE . . . 01 ARTI CLE- NAME PI CTUR E IS X[...]

  • Pagina 102

    T ypes of acce ss Schema DDL 102 U929-J-Z 125-9-76 Generating an additional acces s path via secondar y key SEARCH KEY IS item -name ,... USIN G INDEX [NA ME IS name ] DU P LICATE S ARE [ NOT ] ALLOWED A key defined by mean s of SEAR CH-KEY IS... is c alled a SEARCH key or seconda r y key . It may consist of more than one it em. item-name specifies[...]

  • Pagina 103

    Schema D DL Types o f access U929-J-Z125-9- 76 103 Dokus chablonen 19x24 Version 7.3us für FrameMaker V7.x vo m 14.02.2 007 © cognit as GmbH 20 01-2007 24. Okt ober 2007 Stand 09:30 .23 Pfa d: G:vogtf scudsM anualee nudse nt_euds ent.k04 4.7.5 Determining set occurrence sel ection SET OCCU RRENC E SELECT ION IS THRU ⎧ CURR ENT O F SET ?[...]

  • Pagina 104

    T ypes of acce ss Schema DDL 104 U929-J-Z 125-9-76 Simulta neous automatic selection of several o wner recor ds from one recor d type Wit h cer ta in data str uct ures, it may be n ecessar y to s elect se veral set o ccurrenc es (i.e. sev e ral owner records ) at the sam e time when inse r ting a new member record, where all owner recor ds are par [...]

  • Pagina 105

    Schema D DL OWNER clause and SEARCH KEY clause U929-J-Z125-9- 76 105 Dokus chablonen 19x24 Version 7.3us für FrameMaker V7.x vo m 14.02.2 007 © cognit as GmbH 20 01-2007 24. Okt ober 2007 Stand 09:30 .23 Pfa d: G:vogtf scudsM anualee nudse nt_euds ent.k04 4.8 Special sets 4.8.1 SYSTEM set OWNER IS SYSTEM . A reco rd type whic h is not rela[...]

  • Pagina 106

    O WNER clause and SEARC H KEY clause Schema DDL 106 U929-J-Z 125-9-76 hash-r outin e denotes the name of a modul e conv er tin g the sec ondar y key to a 4-byte binar y number . This bin ar y number is subsequ ently co n ver ted into a relative page numb er by UDS/SQ L. The cor responding page cont ains the pointer to the reco rd (see pa ge 213 ). [...]

  • Pagina 107

    Schema D DL SEARCH KEY and ORDER cl ause U929-J-Z125-9- 76 107 Dokus chablonen 19x24 Version 7.3us für FrameMaker V7.x vo m 14.02.2 007 © cognit as GmbH 20 01-2007 24. Okt ober 2007 Stand 09:30 .23 Pfa d: G:vogtf scudsM anualee nudse nt_euds ent.k04 4.9 Assigning names to hash areas and tab les Names must be assigned to hash ar eas and tab[...]

  • Pagina 108

    Real m co ncep t Schema DDL 108 U929-J-Z 125-9-76 4.10 The realm concept In orde r to take the aspe cts of – data priv acy , –d a t a r e c o v e r y , – conc urrent access, an d – th e logica l assoc iation of cer tain data into ac count, it is ofte n advis able to subdivid e the da tabase in to subunits. These s ubdivi - sions ar e called[...]

  • Pagina 109

    Schema D DL Real m co ncept U929-J-Z125-9- 76 109 Dokus chablonen 19x24 Version 7.3us für FrameMaker V7.x vo m 14.02.2 007 © cognit as GmbH 20 01-2007 24. Okt ober 2007 Stand 09:30 .23 Pfa d: G:vogtf scudsM anualee nudse nt_euds ent.k04 Handling concurrent access When a trans action is ope ned, the da tabase programme r states th e realms [...]

  • Pagina 110

    Real m co ncep t Schema DDL 110 U929-J-Z 125-9-76 4.10.2 Defining allocation of recor ds to realms RECORD NAME IS record -name WI THIN real m-name -1 [, realm-na me-2 ,... AREA -ID IS i dentifi er ] The al location of data to r ealms and the pla cement of d ata within realms is performed main ly when d efining th e physical storage stru cture by me[...]

  • Pagina 111

    Schema D DL S CHEMA NAME and PRIVACY LOCK clause U929-J-Z125-9- 76 111 Dokus chablonen 19x24 Version 7.3us für FrameMaker V7.x vo m 14.02.2 007 © cognit as GmbH 20 01-2007 24. Okt ober 2007 Stand 09:30 .23 Pfa d: G:vogtf scudsM anualee nudse nt_euds ent.k04 4.11 Assigning name and priv acy to a sc hema schema -name [P RIVAC Y LOCK FOR C OP[...]

  • Pagina 112

    DDL example Schema DDL 112 U929-J-Z 125-9-76 4.12 Comprehensive ex ample of DDL application This example s hows the schema of a mail order busines s. The schema su ppor ts the follo wing func tions: – Mana gemen t of m ast er da ta re lati ng t o cus tomer s, articles , suppli ers , cus tom er or ders and orde rs placed with supp liers – Stock [...]

  • Pagina 113

    Schema D DL DDL example U929-J-Z125-9- 76 113 Dokus chablonen 19x24 Version 7.3us für FrameMaker V7.x vo m 14.02.2 007 © cognit as GmbH 20 01-2007 24. Okt ober 2007 Stand 09:30 .23 Pfa d: G:vogtf scudsM anualee nudse nt_euds ent.k04 Figure 26: Schema of a mail order b usiness CUST - ORDE R -ITEM SUBSET Realms: PURCH -OR D- ITE M COL ORS M [...]

  • Pagina 114

    DDL example Schema DDL 114 U929-J-Z 125-9-76 A roug h select ion of ar ticles is possi ble b y mean s of the cr iter ia ARTICLE- TYPE and ARTICLE-SELECTION. This selec tion leads to a detai led ar ticle desc ript ion. An ar t icle descrip tion can com prise se ve ral ar ticl es di ff ering in col or , siz e an d price . The sets CONT AINS and C ONT[...]

  • Pagina 115

    Schema D DL DDL example U929-J-Z125-9- 76 115 Dokus chablonen 19x24 Version 7.3us für FrameMaker V7.x vo m 14.02.2 007 © cognit as GmbH 20 01-2007 24. Okt ober 2007 Stand 09:30 .23 Pfa d: G:vogtf scudsM anualee nudse nt_euds ent.k04 37 * 38 * 39 RECORD NAME IS ORD-ITEM 40 WIT HIN CUSTOMER-ORDER-RLM. 41 * 42 01 ORD -NO-ITEM PICTURE IS 99. 4[...]

  • Pagina 116

    DDL example Schema DDL 116 U929-J-Z 125-9-76 85 LOCATION MODE IS CALC USING ARTI CLE-NAME 86 DUPLIC ATES ARE ALLOWED 87 WITHIN CL OTHING, HOUSEHOLD-GOODS , SPORTS-ARTICLES, FOOD, 88 LEISUR E, STATIONERY AREA-ID I S RLM-SELECTION-3. 89 * 90 01 ART-NO PICTURE IS 9(6). 91 01 ARTICLE-N AME TYPE IS CHARACTER 40. 92 01 MATERIAL OCCURS 4 TIMES. 93 02 PERZ[...]

  • Pagina 117

    Schema D DL DDL example U929-J-Z125-9- 76 117 Dokus chablonen 19x24 Version 7.3us für FrameMaker V7.x vo m 14.02.2 007 © cognit as GmbH 20 01-2007 24. Okt ober 2007 Stand 09:30 .23 Pfa d: G:vogtf scudsM anualee nudse nt_euds ent.k04 133 RECORD NAME IS COLORS 134 WI THIN ARTICLE-RLM 135 SE ARCH KEY IS COL-NAME US ING CALC DUPLICATES ARE NOT[...]

  • Pagina 118

    DDL example Schema DDL 118 U929-J-Z 125-9-76 181 01 P-ORD-NO -ITEM PICTURE IS 99. 182 01 P-ORD-QT Y TYPE IS DECIMAL 10. 183 * 184 * 185 * 186 SET NAME IS CST-ORD-PLACED 187 ORDER IS SORTED INDEXED BY DEFI NED KEYS 188 DUPLI CATES ARE NOT ALLOWED 189 OWNER IS CUSTOMER. 190 MEMBER IS CS T-ORDERS OPTIONAL AUTOM ATIC 191 ASCENDIN G KEY IS ORD-NO 192 SE[...]

  • Pagina 119

    Schema D DL DDL example U929-J-Z125-9- 76 119 Dokus chablonen 19x24 Version 7.3us für FrameMaker V7.x vo m 14.02.2 007 © cognit as GmbH 20 01-2007 24. Okt ober 2007 Stand 09:30 .23 Pfa d: G:vogtf scudsM anualee nudse nt_euds ent.k04 229 SET NA ME IS SHORT-LIST 230 OR DER IS SORTED INDEXED B Y DEFINED KEYS 231 DUPLICATES ARE ALLOWED 232 OW [...]

  • Pagina 120

    DDL example Schema DDL 120 U929-J-Z 125-9-76 277 ASCENDIN G KEY IS SUPPL-NAME, SU PPL-NO. 278 * 279 * 280 SET NAME IS ARTICLES-AVAILABLE 281 ORDER IS SORTED INDEXED BY DEFI NED KEYS 282 DUPLI CATES ARE ALLOWED 283 OWNER IS SUPPLIER. 284 MEMBER IS AR TICLE MANDATORY AUTOMAT IC 285 ASCENDIN G KEY IS ARTICLE-NAME 286 SEARCH K EY IS NOT-AVAIL-CODE US I[...]

  • Pagina 121

    Schema D DL DDL example U929-J-Z125-9- 76 121 Dokus chablonen 19x24 Version 7.3us für FrameMaker V7.x vo m 14.02.2 007 © cognit as GmbH 20 01-2007 24. Okt ober 2007 Stand 09:30 .23 Pfa d: G:vogtf scudsM anualee nudse nt_euds ent.k04 325 * 326 * 327 SET NA ME IS RESULT-SET 328 SE T IS DYNAMIC 329 OR DER IS IMMATERIAL 330 OW NER IS SYSTEM. 3[...]

  • Pagina 122

    DDL example Schema DDL 122 U929-J-Z 125-9-76 373 SET NAME IS IQL-DYN8 374 SET IS D YNAMIC 375 ORDER IS IMMATERIAL 376 OWNER IS SYSTEM.[...]

  • Pagina 123

    Schema D DL Reserved words of the DDL compiler U929-J-Z125-9- 76 123 Dokus chablonen 19x24 Version 7.3us für FrameMaker V7.x vo m 14.02.2 007 © cognit as GmbH 20 01-2007 24. Okt ober 2007 Stand 09:30 .23 Pfa d: G:vogtf scudsM anualee nudse nt_euds ent.k04 4.13 Reser ved w or ds of the DDL compiler ACCEPT AC CESS A CTUAL AD ADD ADV ANCIN G [...]

  • Pagina 124

    Rese rved w or ds of the D DL c ompi ler Schema DDL 124 U929-J-Z 125-9-76 COMPU TE CONFI GURA TION CONN ECT CONSOL E CO NTAI NS CONTR OL CONTRO LS COPY CORR CORRE SPON DING COU NT CREA TING CSP CURRENC Y CURR ENT CURRE NT-D ATE CYCLE S CYLINDER- OFLO DATA DATABASE -EXCEP TIO N DATAB ASE -KEY DATAB ASE- KEY-LIS T DAT ABASE- KEY- LONG DATA BASE-KE Y-[...]

  • Pagina 125

    Schema D DL Reserved words of the DDL compiler U929-J-Z125-9- 76 125 Dokus chablonen 19x24 Version 7.3us für FrameMaker V7.x vo m 14.02.2 007 © cognit as GmbH 20 01-2007 24. Okt ober 2007 Stand 09:30 .23 Pfa d: G:vogtf scudsM anualee nudse nt_euds ent.k04 EXCEPT ION EX CL EXCLUSIV E EXHIBI T EXIT EXT END EXTEND ED FD FET CH FILE FILE-C ONT[...]

  • Pagina 126

    Rese rved w or ds of the D DL c ompi ler Schema DDL 126 U929-J-Z 125-9-76 MEMBER S MEMBERSH IP MEM ORY MERGE MESSA GE MINU S MIXED MO DE MODIFY MODUL ES MORE- LABE LS MOVE MULTIP LE MULTIP LY NAME NAMED NATIONAL N ATIV E NEGATI VE NEXT NO NOT NOTE NUM BER NUMER IC OBJEC T-CO MPUTER OC CURRENC E OCCURS OF OFF OH OMIT TED O N ONES ONLY OPE N OPT OPTI[...]

  • Pagina 127

    Schema D DL Reserved words of the DDL compiler U929-J-Z125-9- 76 127 Dokus chablonen 19x24 Version 7.3us für FrameMaker V7.x vo m 14.02.2 007 © cognit as GmbH 20 01-2007 24. Okt ober 2007 Stand 09:30 .23 Pfa d: G:vogtf scudsM anualee nudse nt_euds ent.k04 RD READ REA DER READY RE AL REALM REALM- NAME RE ALMS RECEIV E RECORD RE CORDIN G REC[...]

  • Pagina 128

    Rese rved w or ds of the D DL c ompi ler Schema DDL 128 U929-J-Z 125-9-76 SUPPRE SS SYMBOL IC SYNC SYNCHR ONIZ ED SYSI N SYSIPT SYSLST SYSO PT SYS OPT-2 34 SYSOUT SYSPUN CH SYS RDR SYSTEM TA BLE TALLY TALLYI NG TAPE TAPES TEMP TEMPORAR Y TENAN T TERMIN AL TERMINAT E TEX T THAN THEN THR OUG H THRU TIME TIM ES TO TODA YS-D ATE T OP TRACE TRACK -ARE A[...]

  • Pagina 129

    U929-J-Z125-9- 76 129 Dokus chablonen 19x24 Version 7.3us für FrameMaker V7.x vo m 14.02.2 007 © cognit as GmbH 20 01-2007 24. Okt ober 2007 Stand 08:58 .55 Pfa d: G:vogtf scudsM anualee nudse nt_euds ent.k05 5 SSL 5.1 Intr oduction The schema DDL is used to descr ibe the log ical str ucture of the data; the S torage Str ucture Language S [...]

  • Pagina 130

    Intr oduction SSL 130 U929-J-Z 125-9-76 5.1.1 Methods of physical represent ation of the logi cal data structure The physical re presenta tion of the entirety of Using the SS L, the user deter mine s if and how a pointer arra y , list, chai n, sor t key tab le or SEARCH ke y table i s to be set up. A descr iption of these e lements can be f ound on[...]

  • Pagina 131

    SSL Introduction U929-J-Z125-9- 76 131 Dokus chablonen 19x24 Version 7.3us für FrameMaker V7.x vo m 14.02.2 007 © cognit as GmbH 20 01-2007 24. Okt ober 2007 Stand 08:58 .55 Pfa d: G:vogtf scudsM anualee nudse nt_euds ent.k05 5.1.2 DBTT (Databas e K ey T ranslation T able ) The DBTT establishes th e link betwe en the datab ase key v alue o[...]

  • Pagina 132

    Intr oduction SSL 132 U929-J-Z 125-9-76 Struct ure of a dat abase key value T o find the physical a ddress of r ecord s and assoc iated tables, UDS/S QL can always make use of a n addi tional id entifier, the database ke y value, which n e v er cha nges du ring t he life of a rec ord in the d atabase. A rec ord type co nsists of a number of records[...]

  • Pagina 133

    SSL Introduction U929-J-Z125-9- 76 133 Dokus chablonen 19x24 Version 7.3us für FrameMaker V7.x vo m 14.02.2 007 © cognit as GmbH 20 01-2007 24. Okt ober 2007 Stand 08:58 .55 Pfa d: G:vogtf scudsM anualee nudse nt_euds ent.k05 The following applies to the value range for a recor d sequen ce number (RS Q): –1 ≤ RSQ ≤ 2 24 -1 for databa[...]

  • Pagina 134

    Intr oduction SSL 134 U929-J-Z 125-9-76 Figure 30: Linkage between the database key v alue and the record address via the DBTT 0 5 0 0 0 0 0 3 1 byt e 3 byt es 0 4 0 0 0 0 8 3 0 6 0 0 0 0 1 4 Line 3 Da tabase key value fo r p age le ngth of 20 48 by t es D B TT o f re co rd ty p e 05 REC-REF R S Q Column 0 001 002 00 3 00 4 Re al m 01 060 061 06 2 [...]

  • Pagina 135

    SSL Introduction U929-J-Z125-9- 76 135 Dokus chablonen 19x24 Version 7.3us für FrameMaker V7.x vo m 14.02.2 007 © cognit as GmbH 20 01-2007 24. Okt ober 2007 Stand 08:58 .55 Pfa d: G:vogtf scudsM anualee nudse nt_euds ent.k05 If the place ment of rec ords chang es, updating of the page addre sses can be limit ed to the DBTT . In additi on [...]

  • Pagina 136

    P opulation SSL 136 U929-J-Z 125-9-76 5.2 Declaring the population 5.2.1 Spe cifying the num ber of rec ords in one record type The numbe r of record s included i n one rec ord type is defi ned in the DB TT and in the record POPUL A TION c lause. Using th is number UDS/ SQL com putes: – th e storage space r equiremen t for the DBTT , – th e has[...]

  • Pagina 137

    SSL Population U929-J-Z125-9- 76 137 Dokus chablonen 19x24 Version 7.3us für FrameMaker V7.x vo m 14.02.2 007 © cognit as GmbH 20 01-2007 24. Okt ober 2007 Stand 08:58 .55 Pfa d: G:vogtf scudsM anualee nudse nt_euds ent.k05 Note, howe ver , that UDS/SQL alwa ys crea tes only as many DBTT pages as required for the DBTT and that, dep ending [...]

  • Pagina 138

    P opulation SSL 138 U929-J-Z 125-9-76 Size of a hash area f or th e pri mary ke y POPULA TION IS { in teger WITHIN realm- name },... The ha sh area for the pr ima r y ke y of a rec ord type is distr ibuted over se veral real ms if the records of the re cord type a re allo cated to s e v eral rea lms by means of t he schema DDL (see t he section “[...]

  • Pagina 139

    SSL Population U929-J-Z125-9- 76 139 Dokus chablonen 19x24 Version 7.3us für FrameMaker V7.x vo m 14.02.2 007 © cognit as GmbH 20 01-2007 24. Okt ober 2007 Stand 08:58 .55 Pfa d: G:vogtf scudsM anualee nudse nt_euds ent.k05 Size of the hash area f or a secondary key D ATAB ASE-KE Y-T RANSLATI ON-T ABLE I S in teger inte ger specifi es the [...]

  • Pagina 140

    P opulation SSL 140 U929-J-Z 125-9-76 5.2.2 Spe cifying the si ze of the se t occurrence s of a set POPULA TION IS intege r The s ize of the set occurren ces must be spec ified in the following cas es: – if you want to store ta b les and me mber records in the proximity of the assoc iated owner records , – if you want to facilitate s ubsequen t[...]

  • Pagina 141

    SSL Population U929-J-Z125-9- 76 141 Dokus chablonen 19x24 Version 7.3us für FrameMaker V7.x vo m 14.02.2 007 © cognit as GmbH 20 01-2007 24. Okt ober 2007 Stand 08:58 .55 Pfa d: G:vogtf scudsM anualee nudse nt_euds ent.k05 When sto ring an owner rec ord, UDS/SQ L rese r v es: – the ca lculat ed storage space, if it is smal ler than one [...]

  • Pagina 142

    P opulation SSL 142 U929-J-Z 125-9-76 Size of the hash area for a sec ondary k ey Only in the ca se of SYS TEM s ets can a seco ndar y key be used for conversion by a hash routin e. UDS/SQL calcu lates the m inimum number of pa ges requir ed f or dist ributed sto rage of rec ord addr esses on the basi s of the s et occur rence pop ulatio n entr y ([...]

  • Pagina 143

    SSL Population U929-J-Z125-9- 76 143 Dokus chablonen 19x24 Version 7.3us für FrameMaker V7.x vo m 14.02.2 007 © cognit as GmbH 20 01-2007 24. Okt ober 2007 Stand 08:58 .55 Pfa d: G:vogtf scudsM anualee nudse nt_euds ent.k05 5.2.3 Overview of t he initial sizes f or st orage space reserva tions T ype of data Set type Reserv ed storag e spac[...]

  • Pagina 144

    Linkage methods SSL 144 U929-J-Z 125-9-76 5.3 Determining the linkage of recor ds 5.3.1 Determining t he storage mode f or set occur rences UDS/SQ L offers three different sto rage modes for linking member re cords to form a se t occurr ence. These ar e: – po inter array (POINTER-A RRA Y) – lis t (LIST), and – chai n (CHAIN) The following exa[...]

  • Pagina 145

    SSL Linkage methods U929-J-Z125-9- 76 145 Dokus chablonen 19x24 Version 7.3us für FrameMaker V7.x vo m 14.02.2 007 © cognit as GmbH 20 01-2007 24. Okt ober 2007 Stand 08:58 .55 Pfa d: G:vogtf scudsM anualee nudse nt_euds ent.k05 Stori ng a set oc currence as a po inter array MODE I S POI NTER-A RRAY If MODE IS POINTER-A RRA Y is de fined f[...]

  • Pagina 146

    Linkage methods SSL 146 U929-J-Z 125-9-76 Figure 33: Set occurrence s tored as a pointer arra y If a pointer arra y occupi es more than one page, each page is connecte d b y act-keys twice. If ORDER IS SORTED INDEX ED , the pointe r arra y is pr ovided with addi tional hi gher- ranking table le vels. Each high er-ranking lev e l has the same st ruc[...]

  • Pagina 147

    SSL Linkage methods U929-J-Z125-9- 76 147 Dokus chablonen 19x24 Version 7.3us für FrameMaker V7.x vo m 14.02.2 007 © cognit as GmbH 20 01-2007 24. Okt ober 2007 Stand 08:58 .55 Pfa d: G:vogtf scudsM anualee nudse nt_euds ent.k05 Additional pointer fr om owner to its pointer array MODE I S POI NTER-A RRAY.. ...WI TH PHY SICAL LINK The stan [...]

  • Pagina 148

    Linkage methods SSL 148 U929-J-Z 125-9-76 Storing a set occur rence as a list MODE IS LIST If a set is defined wit h MODE IS LIST , UDS/SQ L stores th e member rec ords of a set oc cur- rence in a table calle d a list. Th e ph ysical sequenc e of the re cords cor responds to the logic al sequen ce define d in the O RDER clau se. Figure 35: Set occu[...]

  • Pagina 149

    SSL Linkage methods U929-J-Z125-9- 76 149 Dokus chablonen 19x24 Version 7.3us für FrameMaker V7.x vo m 14.02.2 007 © cognit as GmbH 20 01-2007 24. Okt ober 2007 Stand 08:58 .55 Pfa d: G:vogtf scudsM anualee nudse nt_euds ent.k05 The physical pl acement o f recor ds can b e defined o nly o nce: – If a re cord type i s a membe r of sev e r[...]

  • Pagina 150

    Linkage methods SSL 150 U929-J-Z 125-9-76 Additional pointer fr om o wner to its list MODE IS LIST.....W ITH PH YSICAL LI NK The UDS /SQL stand ard conn ection be tween an owner re cord and the list of its me mber records is via th e DBTT . The use r can bypass the DB TT and s av e o ne page access by specif ying WITH P HYSICAL LIN K, which ge nera[...]

  • Pagina 151

    SSL Linkage methods U929-J-Z125-9- 76 151 Dokus chablonen 19x24 Version 7.3us für FrameMaker V7.x vo m 14.02.2 007 © cognit as GmbH 20 01-2007 24. Okt ober 2007 Stand 08:58 .55 Pfa d: G:vogtf scudsM anualee nudse nt_euds ent.k05 Storing a set oc currence as a chain MODE I S CHA IN If MODE IS C HAIN is defi ned for a set, each set oc curren[...]

  • Pagina 152

    Linkage methods SSL 152 U929-J-Z 125-9-76 Additional bac kwar d chai ning for c hain MODE IS CHAIN LINKED TO PRIOR In addit ion to stan dard forward chainin g, the rec ords of a c hain can be concatena ted in rev e rse order . If LINKED TO PRIOR is specified , a fur the r pointer is added to each rec ord poin ting to the logi cally pre cedin g reco[...]

  • Pagina 153

    SSL Linkage methods U929-J-Z125-9- 76 153 Dokus chablonen 19x24 Version 7.3us für FrameMaker V7.x vo m 14.02.2 007 © cognit as GmbH 20 01-2007 24. Okt ober 2007 Stand 08:58 .55 Pfa d: G:vogtf scudsM anualee nudse nt_euds ent.k05 5.3.2 Assessing poi nter ar ray , list and c hain The tim e required for the e x ecution of a program dep ends o[...]

  • Pagina 154

    Linkage methods SSL 154 U929-J-Z 125-9-76 List ● Sequenti al acce ss If MODE IS LIS T , t he rec ords are grouped toge ther in a cont iguous storage ar ea. This storage m ode offers f astest se quentia l processin g. The numb er of acces ses when process ing large numb ers of rec ords de pends on t he record length. ● Dire ct ac cess If ORDER I[...]

  • Pagina 155

    SSL Linkage methods U929-J-Z125-9- 76 155 Dokus chablonen 19x24 Version 7.3us für FrameMaker V7.x vo m 14.02.2 007 © cognit as GmbH 20 01-2007 24. Okt ober 2007 Stand 08:58 .55 Pfa d: G:vogtf scudsM anualee nudse nt_euds ent.k05 Chain ● Sequ enti al ac cess When rec ords are processe d in the ir logica l order, a maximum of on e disk acc[...]

  • Pagina 156

    Linkage methods SSL 156 U929-J-Z 125-9-76 ● Deletion UDS/SQL must find th e record to be deleted and also the rec ord preced ing it. T his requires less ti me if backward chaini ng has be en speci fied. In the case of backward chaining, UDS/SQL must also updat e the poi nter in the subsequ ent rec ord. If ORDE R IS SORTED INDEXE D , the entr y ma[...]

  • Pagina 157

    SSL Linkage methods U929-J-Z125-9- 76 157 Dokus chablonen 19x24 Version 7.3us für FrameMaker V7.x vo m 14.02.2 007 © cognit as GmbH 20 01-2007 24. Okt ober 2007 Stand 08:58 .55 Pfa d: G:vogtf scudsM anualee nudse nt_euds ent.k05 5.3.3 Preventing redundancy in SEARCH key tables TYPE I S DAT ABASE- KEY-LI ST In the des cripti on of th e logi[...]

  • Pagina 158

    Linkage methods SSL 158 U929-J-Z 125-9-76 Figure 39: Comparison of standard SEARCH ke y table wit h duplicates tab le The po inters in t he duplic ates table are the RSQs o f the asso ciated rec ords. The poi nters assoc iated with the same ke y value are so r ted in ascendi ng order accordin g to RSQs. Thus a n addition al access to the DBT T is r[...]

  • Pagina 159

    SSL Linkage methods U929-J-Z125-9- 76 159 Dokus chablonen 19x24 Version 7.3us für FrameMaker V7.x vo m 14.02.2 007 © cognit as GmbH 20 01-2007 24. Okt ober 2007 Stand 08:58 .55 Pfa d: G:vogtf scudsM anualee nudse nt_euds ent.k05 5.3.4 Adding a pointer to link a member to its o wner MEMBER IS PHYS ICAL LY LINK ED T O OWNE R This entr y s pe[...]

  • Pagina 160

    Placemen t SSL 160 U929-J-Z 125-9-76 5.4 Defining the placement of member re cor ds, tabl es and hash areas The S SL provides optio ns to defi ne the pla cement of t he follo wing objects: – m embe r re cord s –l i s t s – po inter arrays – sor t ke y tables – SEARCH key tables – DBTTs – ha sh areas. Thes e opt ion s i nclud e , in pa[...]

  • Pagina 161

    SSL Placeme nt U929-J-Z125-9- 76 161 Dokus chablonen 19x24 Version 7.3us für FrameMaker V7.x vo m 14.02.2 007 © cognit as GmbH 20 01-2007 24. Okt ober 2007 Stand 08:58 .55 Pfa d: G:vogtf scudsM anualee nudse nt_euds ent.k05 5.4.1.1 Placeme nt at rea lm level The following clause s are used to a llocate d ata to cer tain re alms wit hout sp[...]

  • Pagina 162

    Placemen t SSL 162 U929-J-Z 125-9-76 If no entr y is made for a se t SEARCH key table or hash ar ea, UDS/SQL s elects t he realm accordi ng to th e f ollowing pr inci ple: Figure 40: Def ault value f or realm-name name specifies the name o f the sor t or SEARCH ke y table to be pla ced. Th is name must hav e been assign ed in the schema DDL (see th[...]

  • Pagina 163

    SSL Placeme nt U929-J-Z125-9- 76 163 Dokus chablonen 19x24 Version 7.3us für FrameMaker V7.x vo m 14.02.2 007 © cognit as GmbH 20 01-2007 24. Okt ober 2007 Stand 08:58 .55 Pfa d: G:vogtf scudsM anualee nudse nt_euds ent.k05 5.4.1.2 Placeme nt within a realm Within a realm, d ata belong ing to one set occu rrence can be s tored co ntiguous [...]

  • Pagina 164

    Placemen t SSL 164 U929-J-Z 125-9-76 Natural optimization If the us er does not influe nce the pl acement o f data within a realm by mea ns of the DDL and SS L, UDS/SQL ph ysicall y store s the data in the ch ronologi cal ord er in whi ch it is entered . Thus, at initia l load time or later on when r unnin g unload or lo ad programs, the user can s[...]

  • Pagina 165

    SSL Placeme nt U929-J-Z125-9- 76 165 Dokus chablonen 19x24 Version 7.3us für FrameMaker V7.x vo m 14.02.2 007 © cognit as GmbH 20 01-2007 24. Okt ober 2007 Stand 08:58 .55 Pfa d: G:vogtf scudsM anualee nudse nt_euds ent.k05 PLA CEMENT OPTIMIZA TION PLACEM ENT OPTIMIZA TION FOR SET set-na me set-nam e sp ecifies the name of the s et to be o[...]

  • Pagina 166

    Placemen t SSL 166 U929-J-Z 125-9-76 MODE c la use ⎧ POINTER-A RRAY ⎫ MODE IS ⎨ ⎬ ATTAC HED TO OWNE R ⎩ LIST ⎭ This ent r y is no t perm itted in S YSTEM se ts. If a set occurren ce pop ulation greater than zero has been spec ified for the se t (see the section “Specif ying the s ize of the set oc currences of a set” on page 1 40 ),[...]

  • Pagina 167

    SSL Placeme nt U929-J-Z125-9- 76 167 Dokus chablonen 19x24 Version 7.3us für FrameMaker V7.x vo m 14.02.2 007 © cognit as GmbH 20 01-2007 24. Okt ober 2007 Stand 08:58 .55 Pfa d: G:vogtf scudsM anualee nudse nt_euds ent.k05 IND EX c lause INDEX NA ME IS name PLACING I S ATTA CHED TO OWN ER This entr y is not per mi tted f or SY STEM sets. [...]

  • Pagina 168

    Placemen t SSL 168 U929-J-Z 125-9-76 5.4.2 Defining the placement of record SEARCH key table, DBTT and record hash areas For this data, th e user can specify only the realm in wh ich it is to be sto red. The following claus es are use d to alloc ate data to specifi c realms : Record SEA RCH ke y table NDEX NAME IS name PLACIN G IS WI THIN realm-na [...]

  • Pagina 169

    SSL Placeme nt U929-J-Z125-9- 76 169 Dokus chablonen 19x24 Version 7.3us für FrameMaker V7.x vo m 14.02.2 007 © cognit as GmbH 20 01-2007 24. Okt ober 2007 Stand 08:58 .55 Pfa d: G:vogtf scudsM anualee nudse nt_euds ent.k05 Example DDL: SET NA ME IS CUSTO MER-ORD ERS-PL ACED . . . OWNER I S CUST OMER. MEMBER IS C USTOMER- ORDER . . . SSL: [...]

  • Pagina 170

    Placemen t SSL 170 U929-J-Z 125-9-76 5.4.3 Overvie w of plac ement statem ents T ype of data WITH IN realm- name,... Member recor ds in set with LOCA- TION MODE IS CALC Placement o f the recor ds O WNER IS SYSTEM PLA CEMENT OPTIMIZA- TION FOR SET MODE IS ... recor ds manda- tor y yes ye s not permitted no LIST A TT ACHED not per mi tted DET A CHED [...]

  • Pagina 171

    SSL Placeme nt U929-J-Z125-9- 76 171 Dokus chablonen 19x24 Version 7.3us für FrameMaker V7.x vo m 14.02.2 007 © cognit as GmbH 20 01-2007 24. Okt ober 2007 Stand 08:58 .55 Pfa d: G:vogtf scudsM anualee nudse nt_euds ent.k05 T ype of data Ty p e of Set MODE, INDEX or DBTT c lause specification s Placement Realm within realm List Po i n t e [...]

  • Pagina 172

    REORGANIZA TION clause SSL 172 U929-J-Z 125-9-76 5.5 Defi ning the extent of table reorganization desired DYNAM IC R EORGANI ZATION SPAN S inte ger PAGES If, when record s are s tored, the storage sp ace req uirement s are for med to exceed thos e initia lly calcu lated on th e basis of the PO PULA TION claus e, UDS/SQL automa tically performs a ta[...]

  • Pagina 173

    SSL REO RGANIZATION cl ause U929-J-Z125-9- 76 173 Dokus chablonen 19x24 Version 7.3us für FrameMaker V7.x vo m 14.02.2 007 © cognit as GmbH 20 01-2007 24. Okt ober 2007 Stand 08:58 .55 Pfa d: G:vogtf scudsM anualee nudse nt_euds ent.k05 In case 1), the occupa ncy lev e l is depend ent on the inte ger spec ified. It must no t fall below the[...]

  • Pagina 174

    REORGANIZA TION clause SSL 174 U929-J-Z 125-9-76 In orde r to inser t reco rd 650 (s ee below), UDS /SQL must s et up a new page, si nce page 2 is co mpletely occupied. T he new page ac cepts as ma ny entri es from pag e 2 as is neces sar y to en sure ev e n distr ibution of rec ords over the two pages. Figure 44: Inse r ting a record with ta ble e[...]

  • Pagina 175

    SSL REO RGANIZATION cl ause U929-J-Z125-9- 76 175 Dokus chablonen 19x24 Version 7.3us für FrameMaker V7.x vo m 14.02.2 007 © cognit as GmbH 20 01-2007 24. Okt ober 2007 Stand 08:58 .55 Pfa d: G:vogtf scudsM anualee nudse nt_euds ent.k05 D YNAMIC REORGANIZA TION SP ANS 3 P A GES Base d on figure 4 3 , the following situa tion r esults f rom[...]

  • Pagina 176

    COMPRESSION clause SSL 176 U929-J-Z 125-9-76 5.6 Storing the records of a recor d type in compressed f orm COMPRE SSIO N FOR ALL ITEM S A recor d type co ntaining an item of vari able length may not be c ompresse d. Under CA LL DML, r ecords ca n be comp ressed by stor ing onl y par t o f the it ems belo nging to the r ecord type (see the " Ap[...]

  • Pagina 177

    SSL Calculation formulas U929-J-Z125-9- 76 177 Dokus chablonen 19x24 Version 7.3us für FrameMaker V7.x vo m 14.02.2 007 © cognit as GmbH 20 01-2007 24. Okt ober 2007 Stand 08:58 .55 Pfa d: G:vogtf scudsM anualee nudse nt_euds ent.k05 5.7 Formulas f or calculating the storage space requirements f or recor ds and tab les The storage sp ace r[...]

  • Pagina 178

    Calculation form ulas SSL 178 U929-J-Z 125-9-76 Calcula tion formulas for a database w ith a 4000 or 8096-byte pag e length Number of rec ords in the data page page le ngth-20     r ecord length 1 +12 1 The record length is the length of a record according to the schema DDL plus the length of it[...]

  • Pagina 179

    SSL SSL example U929-J-Z125-9- 76 179 Dokus chablonen 19x24 Version 7.3us für FrameMaker V7.x vo m 14.02.2 007 © cognit as GmbH 20 01-2007 24. Okt ober 2007 Stand 08:58 .55 Pfa d: G:vogtf scudsM anualee nudse nt_euds ent.k05 5.8 Comprehensive exam ple of SSL application STORAGE STRUCTURE OF SCHEMA MAIL-OR DERS. * * RECORD NAME IS CUSTOMER [...]

  • Pagina 180

    SSL example SSL 180 U929-J-Z 125-9-76 250 WITHIN STATIONERY INDEX NAME IS SEARCH-TAB- ARTICLE-1 PLACING IS WITHIN ARTICLE -RLM INDEX NAME IS SEARCH-TAB- ARTICLE-2 PLACING IS WITHIN ARTICLE -RLM. * RECORD NAME IS MATERIALS INDEX NAME IS SEARCH-TAB- MATERIAL-1 DYNAMIC REORGANIZATION SP ANS 5 PAGES INDEX NAME IS SEARCH-TAB- MATERIAL-2 DYNAMIC REORGANI[...]

  • Pagina 181

    SSL SSL example U929-J-Z125-9- 76 181 Dokus chablonen 19x24 Version 7.3us für FrameMaker V7.x vo m 14.02.2 007 © cognit as GmbH 20 01-2007 24. Okt ober 2007 Stand 08:58 .55 Pfa d: G:vogtf scudsM anualee nudse nt_euds ent.k05 SET NAME IS CONTAINING POPULATION IS 10 MEMBER IS PHYSICALLY LINKED TO OWNER. * SET NAME IS CONTAINED-IN MODE IS CHA[...]

  • Pagina 182

    Rese rved w or ds of the S SL c ompi ler SSL 182 U929-J-Z 125-9-76 5.9 Reser ved w ords of the SSL compiler ALL ARE A ASSIGN ED ATT ACHED CHAIN C OMPR ESSION DATAB ASE- KEY-LIS T DATABA SE-KEY -TRAN SLATIO N-TABLE DBKEY -TRA NSLATIO N-TABL E DBTT DCB-NA ME DET ACHED DYNAMI C FOR INCREA SE IND EX INDICA TOR I S ITEMS L INK LINKED L IST MEMBER M ODE [...]

  • Pagina 183

    U929-J-Z125-9- 76 183 Dokus chablonen 19x24 Version 7.3us für FrameMaker V7.x vo m 14.02.2 007 © cognit as GmbH 20 01-2007 18. Okt ober 2007 Stand 11:29 .49 Pfa d: G:vogtf scudsM anualee nudse nt_euds ent.k06 6 Definition of the user in terface to th e databa se 6.1 Subschema DDL 6.1.1 Introduction All data the databas e requi res to pe rf[...]

  • Pagina 184

    Subschema DDL User in terface 184 U929-J-Z 125-9-76 6.1.2 As signing nam e and privacy to a su bschema SUB-SC HEMA NAME IS sub schema- name O F SC HEMA NAME sche ma- name [PRIVA CY LOCK FOR COMP ILE IS lite ral-1 [ OR li tera l-2 ]] subsc hema- name specifies the name o f the subs chema an d is ass igned by the user. Within one D B configu ration, [...]

  • Pagina 185

    User in terface Su bsch ema DDL U929-J-Z125-9- 76 185 Dokus chablonen 19x24 Version 7.3us für FrameMaker V7.x vo m 14.02.2 007 © cognit as GmbH 20 01-2007 18. Okt ober 2007 Stand 11:29 .49 Pfa d: G:vogtf scudsM anualee nudse nt_euds ent.k06 6.1.4 Copying e ntire recor d types fr om the sc hema into the subs che ma Format 1: COPY ALL RECO R[...]

  • Pagina 186

    Subschema DDL User in terface 186 U929-J-Z 125-9-76 Copying a numeric item, an alphanumer ic item of fixed length or a national item level- numb er it em-n ame PIC TU RE I S ma sk-s tri ng ⎧ DI SPLAY ⎫  CO MPUTATI ONAL -3  [USAGE IS ⎨ ⎬ ].  CO MPUTATI ONAL  ⎩ NA TIONAL ⎭ In level-num ber , the u ser speci fies if a n item is[...]

  • Pagina 187

    User in terface Su bsch ema DDL U929-J-Z125-9- 76 187 Dokus chablonen 19x24 Version 7.3us für FrameMaker V7.x vo m 14.02.2 007 © cognit as GmbH 20 01-2007 18. Okt ober 2007 Stand 11:29 .49 Pfa d: G:vogtf scudsM anualee nudse nt_euds ent.k06 The item definiti on with PIC TURE a nd USAGE clauses can be d eri v ed from the following table 12 [...]

  • Pagina 188

    Subschema DDL User in terface 188 U929-J-Z 125-9-76 Copying a database ke y item ⎧ D ATAB ASE-KE Y ⎫ level- numb er item -nam e USAGE IS ⎨ ⎬ . ⎩ D ATAB ASE-KEY- LONG ⎭ In level-num ber , the u ser speci fies if a n item is to belong to a group it em. If the item is not to be long to a group item, t he lev el number specif ied must be th[...]

  • Pagina 189

    User in terface Su bsch ema DDL U929-J-Z125-9- 76 189 Dokus chablonen 19x24 Version 7.3us für FrameMaker V7.x vo m 14.02.2 007 © cognit as GmbH 20 01-2007 18. Okt ober 2007 Stand 11:29 .49 Pfa d: G:vogtf scudsM anualee nudse nt_euds ent.k06 Copying a vector and reduc ing it if required level-n umber ve ctor-nam e PIC TURE IS mask-str ing ?[...]

  • Pagina 190

    Subschema DDL User in terface 190 U929-J-Z 125-9-76 Copying a repeating gr oup and reducing it if required level- numb er-1 group- item- name [ G ROUP-US AGE IS NATI ONAL ] [ OCCURS inte ger TIMES] . { level-nu mber- 2 record-e lemen t-name PIC TURE ..... USAGE ..... OCCURS .. ...} .... A repe ating group is a group ite m with repeti tion factor . [...]

  • Pagina 191

    User in terface Su bsch ema DDL U929-J-Z125-9- 76 191 Dokus chablonen 19x24 Version 7.3us für FrameMaker V7.x vo m 14.02.2 007 © cognit as GmbH 20 01-2007 18. Okt ober 2007 Stand 11:29 .49 Pfa d: G:vogtf scudsM anualee nudse nt_euds ent.k06 Gr ouping record el ements into a group ite m leve l-num ber- 1 group- item-nam e [ GROU P-US AGE IS[...]

  • Pagina 192

    Subschema DDL User in terface 192 U929-J-Z 125-9-76 Defining a condition Detaile d inf or mation is provided i n the COB OL2000 “ Language Reference Manual ”. 88 condition -nam e ⎧ VA LUE IS ⎫ ⎨ ⎬ { lite ral- 1 [ THR OUGH lit eral- 2 ]},. .. . ⎩ VA LUES ARE ⎭ The da tabase pr ogrammer can m ake the e x ecution of program state ments[...]

  • Pagina 193

    User in terface Su bsch ema DDL U929-J-Z125-9- 76 193 Dokus chablonen 19x24 Version 7.3us für FrameMaker V7.x vo m 14.02.2 007 © cognit as GmbH 20 01-2007 18. Okt ober 2007 Stand 11:29 .49 Pfa d: G:vogtf scudsM anualee nudse nt_euds ent.k06 6.1.6 Copyi ng sets from the schema in to the subschem a Format 1: COPY ALL SETS . Format 2: COPY s [...]

  • Pagina 194

    Subschema DDL User in terface 194 U929-J-Z 125-9-76 6.1.7 Co pying realms from the schema into the subs chema Format 1: COPY ALL AREAS. Format 2: COPY realm-name ,... . Format 1 i s used i f all the re alms in t he schem a are to b e copied into the s ubschema . Format 2 i s used i f only some of the rea lms in t he schema ar e to be c opied into t[...]

  • Pagina 195

    User in terface Sub sch ema D DL (ex am ple) U929-J-Z125-9- 76 195 Dokus chablonen 19x24 Version 7.3us für FrameMaker V7.x vo m 14.02.2 007 © cognit as GmbH 20 01-2007 18. Okt ober 2007 Stand 11:29 .49 Pfa d: G:vogtf scudsM anualee nudse nt_euds ent.k06 6.1.8 Comprehensi ve e xampl e of su bsche ma DDL IDENTIFICATION DIVISION. SUB-SCHEMA N[...]

  • Pagina 196

    Relational sch ema User in terface 196 U929-J-Z 125-9-76 6.2 Relational sc hema The sch ema DDL can be used t o create a schema co mplying with relati onal r ules or wi th CODASYL rule s. A sche ma defined accord ing to re lational rule s co ntains no set rela tion- ships, and the pri mar y and foreign keys are defined by the user . If a schema was[...]

  • Pagina 197

    U929-J-Z125-9- 76 197 Dokus chablonen 19x24 Version 7.3us für FrameMaker V7.x vo m 14.02.2 007 © cognit as GmbH 20 01-2007 18. Okt ober 2007 Stand 11:29 .50 Pfa d: G:vogtf scudsM anualee nudse nt_euds ent.k07 7 Structure of pages When cr eating a d atabase u sing DDL an d SSL, the user do es not us ually requ ire infor- mation on the str u[...]

  • Pagina 198

    Structure of pa ges 198 U929-J-Z 125-9-76 The following secti ons des cribe the page c ontainer and the vario us types o f pages i n detail. These descr iptions of the i ndividu al page types are restr icted to the page s thems elves, i.e. the heade r and trailer for pages with a le ngth of 4000 or 8096 bytes are not shown. Displa cement values for[...]

  • Pagina 199

    St ruct ure o f pa ges Page cont ainer U929-J-Z125-9- 76 199 Dokus chablonen 19x24 Version 7.3us für FrameMaker V7.x vo m 14.02.2 007 © cognit as GmbH 20 01-2007 18. Okt ober 2007 Stand 11:29 .50 Pfa d: G:vogtf scudsM anualee nudse nt_euds ent.k07 7.1 Pa ge container Figure 46: Structure of the page container f or pages with a length of 40[...]

  • Pagina 200

    Act-ke y-0 page / act-ke y-N page Structu re of page s 200 U929-J-Z 125-9-76 7.2 Act-key-0 and a ct-key- N page Figure 47: Structure of the act-key-0 and act-ke y-N page Page heade r Beginnin g of FPA base Numb er of pa ges Beginning Number of lines Length of lines Realm na me Config uration us er ID Conf igur atio n name FPA exten t table 1 21 25 [...]

  • Pagina 201

    St ruct ure o f pa ges Act-key-0 p age / act-ke y-N page U929-J-Z125-9- 76 201 Dokus chablonen 19x24 Version 7.3us für FrameMaker V7.x vo m 14.02.2 007 © cognit as GmbH 20 01-2007 18. Okt ober 2007 Stand 11:29 .50 Pfa d: G:vogtf scudsM anualee nudse nt_euds ent.k07 Mean ing of th e b yt es Byte Meaning 1-4 The act -k ey specifi es the add [...]

  • Pagina 202

    FP A page Structu re of page s 202 U929-J-Z 125-9-76 7.3 FP A page FP A pages cons titute one lev el of the three-level UDS/SQL F r ee Place Admini stration and are us ed to admi nister fre e place o n the realm l e v el. Th ere is als o a free p lace admini s- tration facility on the page a nd table lev e ls. Note that if a dat abase page c ontain[...]

  • Pagina 203

    St ruct ure o f pa ges FPA page U929-J-Z125-9- 76 203 Dokus chablonen 19x24 Version 7.3us für FrameMaker V7.x vo m 14.02.2 007 © cognit as GmbH 20 01-2007 18. Okt ober 2007 Stand 11:29 .50 Pfa d: G:vogtf scudsM anualee nudse nt_euds ent.k07 Structure of an B ASE FP A page with a length of 2048 b ytes Figure 48: Stru cture of a FP A base pa[...]

  • Pagina 204

    FP A page Structu re of page s 204 U929-J-Z 125-9-76 Struct ure of an FP A exte nt page with a le ngth of 2048 bytes or of an FP A page with a length o f 4000 or 8096 bytes Figure 49: St ructure of an FP A extent page with a length of 2048 by tes or of an FP A page with a length of 4000 or 8096 bytes Meaning of the bytes Byte Meaning 1-20 P age con[...]

  • Pagina 205

    St ruct ure o f pa ges DBTT pages U929-J-Z125-9- 76 205 Dokus chablonen 19x24 Version 7.3us für FrameMaker V7.x vo m 14.02.2 007 © cognit as GmbH 20 01-2007 18. Okt ober 2007 Stand 11:29 .50 Pfa d: G:vogtf scudsM anualee nudse nt_euds ent.k07 7.4 DBTT pages F or each r ecord type, UDS /SQL requires a table - known as the DBTT (Dat abase K [...]

  • Pagina 206

    DBTT pages Stru cture of pages 206 U929-J-Z 125-9-76 Figure 50: Layout of a DBTT anchor pa ge Page heade r Beginnin g of DBTT base 1 21 29 33 20 4 2 1 Own ac t key X‘04‘ (Iden tifier Page length 4 1 5 6 19 for DBTT ancho r page) 35 Number of D BTT li nes 4 of DBTT bas e tota l number o f 45 41 4 4 total num ber of DB TT lines of DBTT DBTT exten[...]

  • Pagina 207

    St ruct ure o f pa ges DBTT pages U929-J-Z125-9- 76 207 Dokus chablonen 19x24 Version 7.3us für FrameMaker V7.x vo m 14.02.2 007 © cognit as GmbH 20 01-2007 18. Okt ober 2007 Stand 11:29 .50 Pfa d: G:vogtf scudsM anualee nudse nt_euds ent.k07 7.4.2 DBTT page This sec tion des cribes the lay out of a DBTT page and the s truc ture of the DB [...]

  • Pagina 208

    DBTT pages Stru cture of pages 208 U929-J-Z 125-9-76 Structure of a DBTT page with a length of 2048 b ytes Figure 51: Structure of a DBTT page with a length of 2048 bytes 5 4 4 4 4 4 4 Colum n 0 For reco rd ty pes w hich a re not own er In o w ne r r e co rd typ es Colum n 0 Colum n 1 Colum n n Own ac t k ey DBTT line DBTT line Free Rec. act k ey S[...]

  • Pagina 209

    St ruct ure o f pa ges DBTT pages U929-J-Z125-9- 76 209 Dokus chablonen 19x24 Version 7.3us für FrameMaker V7.x vo m 14.02.2 007 © cognit as GmbH 20 01-2007 18. Okt ober 2007 Stand 11:29 .50 Pfa d: G:vogtf scudsM anualee nudse nt_euds ent.k07 Structur e of a D BTT page wi th a leng th of 4000 or 8096 bytes Figure 52: Stru cture of a DBTT p[...]

  • Pagina 210

    Direct CALC page Structu re of page s 210 U929-J-Z 125-9-76 7.5 Direct CALC page Dependin g on wh ich page length was de fined for the datab ase, the lengt h of a dir ect CALC page may be 2048 bytes, 4000 bytes or 8096 bytes. Direct CA LC pages with a leng th of 2 048 bytes differ from tho se consisti ng of 400 0 or 809 6 bytes with res pect to the[...]

  • Pagina 211

    St ruct ure o f pa ges Direct CALC page U929-J-Z125-9- 76 211 Dokus chablonen 19x24 Version 7.3us für FrameMaker V7.x vo m 14.02.2 007 © cognit as GmbH 20 01-2007 18. Okt ober 2007 Stand 11:29 .50 Pfa d: G:vogtf scudsM anualee nudse nt_euds ent.k07 Figure 53: Stru cture of a direct CA LC page Page head er Page ind ex entry Record 1 21 20 8[...]

  • Pagina 212

    Direct CALC page Structu re of page s 212 U929-J-Z 125-9-76 Meaning s of bytes 1-28 or 1-32 The “ch aining” items ar e used to link the overflowing pages to their overflow pages. Based on the recor d length and the len gth of th e ke y item, UDS /SQL calc ulates t he maximum numbe r of records that c an be stored in a pag e. Then UDS /SQL sets [...]

  • Pagina 213

    St ruct ure o f pa ges Indirect CALC pa ge U929-J-Z125-9- 76 213 Dokus chablonen 19x24 Version 7.3us für FrameMaker V7.x vo m 14.02.2 007 © cognit as GmbH 20 01-2007 18. Okt ober 2007 Stand 11:29 .50 Pfa d: G:vogtf scudsM anualee nudse nt_euds ent.k07 7.6 Indirect C ALC page Indi rect CALC pages are cr eate d f or a record type stor ed wit[...]

  • Pagina 214

    Indirect CALC page St ructure of pages 214 U929-J-Z 125-9-76 Figure 54: Structure of an indirect CALC page Page heade r 1 21 20 10 2 1 Own act key Free begi nni ng 4 8 5 13 15 Numb er of reserv ed lin es Numb er of oc cupied l ines 2 2 3 forward backw ard 3 Chai ning length 2 Free spac e Number of page inde x entri es = 0 2 2 Beginni ng of CALC ta [...]

  • Pagina 215

    St ruct ure o f pa ges Data page U929-J-Z125-9- 76 215 Dokus chablonen 19x24 Version 7.3us für FrameMaker V7.x vo m 14.02.2 007 © cognit as GmbH 20 01-2007 18. Okt ober 2007 Stand 11:29 .50 Pfa d: G:vogtf scudsM anualee nudse nt_euds ent.k07 7.7 Data page Depending on which page lengt h was defin ed f or the da tabase, the le ngth of a dat[...]

  • Pagina 216

    Data page Stru cture of pages 216 U929-J-Z 125-9-76 Figure 55: Structure of a data page 1 Database key value DBTT column Status Beginning of record or table Page index entry Page index entry Free space Record or table Record or table Page header Own act key Free Free space length beginning Nu mber of pa ge index en t ries Page length 21 25/29 26/30[...]

  • Pagina 217

    St ruct ure o f pa ges Data page U929-J-Z125-9- 76 217 Dokus chablonen 19x24 Version 7.3us für FrameMaker V7.x vo m 14.02.2 007 © cognit as GmbH 20 01-2007 18. Okt ober 2007 Stand 11:29 .50 Pfa d: G:vogtf scudsM anualee nudse nt_euds ent.k07 Mean ing s of b ytes 1-28 or 1- 32 There is a page index entr y for each r ecord an d each table in[...]

  • Pagina 218

    Data page Stru cture of pages 218 U929-J-Z 125-9-76[...]

  • Pagina 219

    U929-J-Z125-9- 76 219 Dokus chablonen 19x24 Version 7.3us für FrameMaker V7.x vo m 14.02.2 007 © cognit as GmbH 20 01-2007 24. Okt ober 2007 Stand 12:03 .14 Pfa d: G:vogtf scudsM anualee nudse nt_euds ent.k08 8 Structure of recor ds and tables In general, the user re quires no informatio n on the struc ture of rec ords and tables when defi[...]

  • Pagina 220

    Record structur e Structure of records and table s 220 U929-J-Z 125-9-76 If a variable item or com pression h as not bee n defined f or a rec ord type, its rec ords are stored in the for mat below: Figure 56: Standard f orm at of a user-defined record The following format i s used to store th e records of a record ty pe if a varia ble item or compr[...]

  • Pagina 221

    Structu re of records and tabl es Record s tructure U929-J-Z125-9- 76 221 Dokus chablonen 19x24 Version 7.3us für FrameMaker V7.x vo m 14.02.2 007 © cognit as GmbH 20 01-2007 24. Okt ober 2007 Stand 12:03 .14 Pfa d: G:vogtf scudsM anualee nudse nt_euds ent.k08 Anchor r ecor d In additio n to the r ecords defi ned in the schema DDL, UDS/SQL[...]

  • Pagina 222

    Record structur e Structure of records and table s 222 U929-J-Z 125-9-76 Set connectio n data When a r ecord is stored, UDS/SQL automaticall y adds s et conne ction data (SCD) if th e record has to be con nected wit h other r ecords or ta bles . table 20 shows what the SCD con sists o f in ea ch ca se. The le ngth of the SCD may v ar y , d epending[...]

  • Pagina 223

    Structu re of records and tabl es Record s tructure U929-J-Z125-9- 76 223 Dokus chablonen 19x24 Version 7.3us für FrameMaker V7.x vo m 14.02.2 007 © cognit as GmbH 20 01-2007 24. Okt ober 2007 Stand 12:03 .14 Pfa d: G:vogtf scudsM anualee nudse nt_euds ent.k08 1 Databa se key va lue + PPP of th e first mem ber reco rd ... 8/1 2 bytes 2 Dat[...]

  • Pagina 224

    T abl e struc ture Structure of records and table s 224 U929-J-Z 125-9-76 8.2 Structure of tables Figure 58: Structure of tables 1 Key RSQ PPP or act key Page index entry Free space Occupied space Page header 3/6 4 20 8/12 8/ 12 Table head er Table line Occupied space RSQ PPP or act key 3/ 6 4 Record No. of reserv. lines No. of occupied lines Chain[...]

  • Pagina 225

    Structu re of records and tabl es Table structure U929-J-Z125-9- 76 225 Dokus chablonen 19x24 Version 7.3us für FrameMaker V7.x vo m 14.02.2 007 © cognit as GmbH 20 01-2007 24. Okt ober 2007 Stand 12:03 .14 Pfa d: G:vogtf scudsM anualee nudse nt_euds ent.k08 Explana tion of figure 58 : The len gth of the en trie s f or the r ecord seq uenc[...]

  • Pagina 226

    T abl e struc ture Structure of records and table s 226 U929-J-Z 125-9-76 The following overview shows whic h of the t hree av a ilable table lines co rresponds to which table type: DDL/SSL c lauses T able type Content o f a table line: Name of the table lowes t level higher le vel MODE IS POINTER-ARRA Y ORDER IS LAST/ FIRST/NEXT/PRIOR single-l e v[...]

  • Pagina 227

    Structu re of records and tabl es Table structure U929-J-Z125-9- 76 227 Dokus chablonen 19x24 Version 7.3us für FrameMaker V7.x vo m 14.02.2 007 © cognit as GmbH 20 01-2007 24. Okt ober 2007 Stand 12:03 .14 Pfa d: G:vogtf scudsM anualee nudse nt_euds ent.k08 The table lines of a highe r table lev el contai n act-keys pointing to the associ[...]

  • Pagina 228

    T abl e struc ture Structure of records and table s 228 U929-J-Z 125-9-76 Figure 59: Hierarchic structure of a multi-le vel table Page head er Page index Free space Table hea der 30125 60073 81010 Page head er Pa ge index Table hea der 350 523 30125 Page h eader Pa ge index Table hea der 30289 30450 60073 Page head er Pa ge index Table hea der 6028[...]

  • Pagina 229

    Structu re of records and tabl es Table structure U929-J-Z125-9- 76 229 Dokus chablonen 19x24 Version 7.3us für FrameMaker V7.x vo m 14.02.2 007 © cognit as GmbH 20 01-2007 24. Okt ober 2007 Stand 12:03 .14 Pfa d: G:vogtf scudsM anualee nudse nt_euds ent.k08 Dupl ic ates tab le Figure 60: Stru cture of a duplicates table 1 Next overflow pa[...]

  • Pagina 230

    T abl e struc ture Structure of records and table s 230 U929-J-Z 125-9-76 The l engths o f the entr ies for the d atabase ke y value, the record s equence number ( RSQ), and for the page index entri es depend on the pag e length th at was defined f or the database: – In tables of a databas e with a 20 48-byte page leng th, the e ntry for the data[...]

  • Pagina 231

    Structu re of records and tabl es Table structure U929-J-Z125-9- 76 231 Dokus chablonen 19x24 Version 7.3us für FrameMaker V7.x vo m 14.02.2 007 © cognit as GmbH 20 01-2007 24. Okt ober 2007 Stand 12:03 .14 Pfa d: G:vogtf scudsM anualee nudse nt_euds ent.k08 Ove rflo w page of a duplic ates tab le Figure 61: Overflow page f or a duplicates[...]

  • Pagina 232

    T abl e struc ture Structure of records and table s 232 U929-J-Z 125-9-76[...]

  • Pagina 233

    U929-J-Z125-9- 76 233 Dokus chablonen 19x24 Version 7.3us für FrameMaker V7.x vo m 14.02.2 007 © cognit as GmbH 20 01-2007 18. Okt ober 2007 Stand 11:29 .52 Pfa d: G:vogtf scudsM anualee nudse nt_euds ent.k09 9 Reference se ction The previous chapt ers cover the functi ons and a pplication s of the schema DDL, schema SSL and s ubsche ma DD[...]

  • Pagina 234

    General syntax rules Referenc e section 234 U929-J-Z 125-9-76 General syn tax rules variable must be rep laced by a curre nt value when app lying the f o r mat. Four catego ries o f v ar iables can be disting uishe d: Comment is indi cated by * in column 7. The text in column s 8 thro ugh 72 is then rec ognized as a com ment by UDS/SQL. Semico lon [...]

  • Pagina 235

    Referenc e section Res erved w ords U929-J-Z125-9- 76 235 Dokus chablonen 19x24 Version 7.3us für FrameMaker V7.x vo m 14.02.2 007 © cognit as GmbH 20 01-2007 18. Okt ober 2007 Stand 11:29 .52 Pfa d: G:vogtf scudsM anualee nudse nt_euds ent.k09 P age feed is ind icated by / in colu mn 7. Continuation line Entr ies exceeding col umn 72 can [...]

  • Pagina 236

    Schema D DL Referenc e section 236 U929-J-Z 125-9-76 9.1 Schema DDL synta x ⎧ SCHE MA NAME clause Schema entr y ⎨ ⎩ [PRI VACY LO CK claus e]. ⎧ AREA NAME claus e Realm entry ⎨ ⎩ [TEM PORAR Y clause ]. ⎧ RECO RD NAME clause   [LOC ATION MODE clause]   WITH IN clau se   [SEARC H KEY cl ause]. Record entr y ⎨  reco[...]

  • Pagina 237

    Referenc e section Sc hem a DD L U929-J-Z125-9- 76 237 Dokus chablonen 19x24 Version 7.3us für FrameMaker V7.x vo m 14.02.2 007 © cognit as GmbH 20 01-2007 18. Okt ober 2007 Stand 11:29 .52 Pfa d: G:vogtf scudsM anualee nudse nt_euds ent.k09 9.1. 1 Sche ma entr y SCHEMA NAME IS sc hema-n ame [ PRIVA CY LOCK FO R COPY IS literal- 1 [ OR lit[...]

  • Pagina 238

    Schema D DL Referenc e section 238 U929-J-Z 125-9-76 9.1.3 Recor d entry RECORD NAME IS record -name ⎧ ⎧ ⎧ IN ⎫ ⎫⎫ ⎧ DIR ECT ⎫  item-nam e-1 ⎨ ⎬ record-n ame  ⎨ ⎬ ⎨ ⎩ OF ⎭ ⎬ ⎩ DIR ECT-LO NG ⎭   [L OC ATION MODE IS ⎨ ⎩ iden tifier -1 ⎭⎬ ]    CALC[ hash -routi ne ] USI[...]

  • Pagina 239

    Referenc e section Sc hem a DD L U929-J-Z125-9- 76 239 Dokus chablonen 19x24 Version 7.3us für FrameMaker V7.x vo m 14.02.2 007 © cognit as GmbH 20 01-2007 18. Okt ober 2007 Stand 11:29 .52 Pfa d: G:vogtf scudsM anualee nudse nt_euds ent.k09 A ma ximum o f 253 recor d types m ay be defined in a databa se with a p age le ngth of 2048 bytes,[...]

  • Pagina 240

    Schema D DL Referenc e section 240 U929-J-Z 125-9-76 WITHIN realm-n ame-1 [, rea lm-name -2 ,. .. AREA -ID IS id entif ier ] r ealm-name- 1,-2,... must not be temporar y realms. The rec ords of t he record type are all ocated to cer t ain realms. ⎧ CALC [ hash-r outine ] ⎫ [SEARC H KEY IS item -name ,... USING ⎨ ⎬ [ NAME IS name ] ⎩ INDEX[...]

  • Pagina 241

    Referenc e section Sc hem a DD L U929-J-Z125-9- 76 241 Dokus chablonen 19x24 Version 7.3us für FrameMaker V7.x vo m 14.02.2 007 © cognit as GmbH 20 01-2007 18. Okt ober 2007 Stand 11:29 .52 Pfa d: G:vogtf scudsM anualee nudse nt_euds ent.k09 ⎧ mask -str ing ⎫ PIC TURE IS ⎨ ⎬ ⎩ LX ( integer-1 ) DEPEND ING ON item -name ⎭ mask-st[...]

  • Pagina 242

    Schema D DL Referenc e section 242 U929-J-Z 125-9-76 ⎧ ⎧ ⎧ 15 ⎫ ⎫⎫   BIN ARY[ ⎨ ⎬ ]   FIXED REA L ⎨ ⎩ 31 ⎭ ⎬     ⎩ DEC IMAL[ integer- 1 [, integer- 2 ]] ⎭ TYPE IS ⎨ ⎬  CHAR ACTE R[ integer-3 [ DEPE NDING ON it em-nam e ]]     D ATABASE-KE Y    ⎩ D ATAB ASE[...]

  • Pagina 243

    Referenc e section Sc hem a DD L U929-J-Z125-9- 76 243 Dokus chablonen 19x24 Version 7.3us für FrameMaker V7.x vo m 14.02.2 007 © cognit as GmbH 20 01-2007 18. Okt ober 2007 Stand 11:29 .52 Pfa d: G:vogtf scudsM anualee nudse nt_euds ent.k09 9.1.4 Set entry SET NAME I S se t-name [SET IS DY NAMIC ] ⎧ LA ST ⎫    FI RST   [...]

  • Pagina 244

    Schema D DL Referenc e section 244 U929-J-Z 125-9-76 This clause is used to a ssign a name to a s et and to – de clare the s et a dyna mic set if r equired, – de fine the s equence o f the membe r records wi thin the s et occurr ences for sequent ial process ing, – de fine addi tional ac cess pa ths via prim ar y and s econdar y ke ys, – de[...]

  • Pagina 245

    Referenc e section Sc hem a DD L U929-J-Z125-9- 76 245 Dokus chablonen 19x24 Version 7.3us für FrameMaker V7.x vo m 14.02.2 007 © cognit as GmbH 20 01-2007 18. Okt ober 2007 Stand 11:29 .52 Pfa d: G:vogtf scudsM anualee nudse nt_euds ent.k09 ⎧ LAST ⎫    FIRS T     NEXT     PRIOR  ORDER IS ⎨ ⎬ [...]

  • Pagina 246

    Schema D DL Referenc e section 246 U929-J-Z 125-9-76 ⎧ ASC ENDING ⎫ [ ⎨ ⎬ KE Y IS item-n ame, .. .] ⎩ DESC ENDIN G ⎭ item-name ,... denotes a n item of fi x ed length that belon gs to the r ecord typ e. This clause is used to define an item o r a comb ination o f items of the me mber re cord ty pe as sor t ke y . The member rec ords wit[...]

  • Pagina 247

    Referenc e section Sc hem a DD L U929-J-Z125-9- 76 247 Dokus chablonen 19x24 Version 7.3us für FrameMaker V7.x vo m 14.02.2 007 © cognit as GmbH 20 01-2007 18. Okt ober 2007 Stand 11:29 .52 Pfa d: G:vogtf scudsM anualee nudse nt_euds ent.k09 [SET OCCURRE NCE SE LECTION IS ⎧ CURREN T OF SE T ⎫    ⎧ item-n ame ⎫ THR U ⎨[...]

  • Pagina 248

    SSL Refer ence secti on 248 U929-J-Z 125-9-76 9.2 SSL syntax Schema entr y STORAGE cl ause. ⎧ [REC ORD N AME cl ause   [DAT ABASE -KEY-T RANSLAT ION-TA BLE cl ause]   [rec ord P OPULAT ION cla use] Record entr y ⎨  [PLA CEMEN T-OPTI MIZATIO N clause ]   [IND EX clau se]  ⎩ [COM PRESS ION clau se]]. ⎧ [SET NAME claus [...]

  • Pagina 249

    Referenc e section SSL U929-J-Z125-9- 76 249 Dokus chablonen 19x24 Version 7.3us für FrameMaker V7.x vo m 14.02.2 007 © cognit as GmbH 20 01-2007 18. Okt ober 2007 Stand 11:29 .52 Pfa d: G:vogtf scudsM anualee nudse nt_euds ent.k09 9.2.2 Recor d entry RECORD NA ME IS re cord -name [D ATABAS E-KEY- TRANSLA TION - TABL E[ IS intege r-1 ][ WI[...]

  • Pagina 250

    SSL Refer ence secti on 250 U929-J-Z 125-9-76 [DATAB ASE-KE Y-T RANSLA TION-T ABLE[ IS inte ger ][ WITH IN real m-name ]] inte ger must be greate r than 0. If this entr y i s omitted, UDS /SQL re ser ves one page eac h f or the DBTT and th e hash area of a record SEARCH key . r eal m-name must not deno te a tem porar y realm . If this e ntr y is om[...]

  • Pagina 251

    Referenc e section SSL U929-J-Z125-9- 76 251 Dokus chablonen 19x24 Version 7.3us für FrameMaker V7.x vo m 14.02.2 007 © cognit as GmbH 20 01-2007 18. Okt ober 2007 Stand 11:29 .52 Pfa d: G:vogtf scudsM anualee nudse nt_euds ent.k09 [PLACE MENT OPTI MIZATI ON FO R SET set- name ] set-nam e must not de note a SYS TEM set. This claus e is use[...]

  • Pagina 252

    SSL Refer ence secti on 252 U929-J-Z 125-9-76 [INDEX NAME IS name [P LACI NG IS WITH IN real m-name ] ⎧ DATA BASE-K EY-LI ST ⎫   [T YPE IS ⎨ REPEAT ED-KEY ⎬ ]]...   ⎩ [D YNAMIC REOR GANIZA TION SP ANS intege r PAGES] ⎭ name must hav e been de fined in the s chema DDL for a record SEARCH key table or a hash ar ea of this re c[...]

  • Pagina 253

    Referenc e section SSL U929-J-Z125-9- 76 253 Dokus chablonen 19x24 Version 7.3us für FrameMaker V7.x vo m 14.02.2 007 © cognit as GmbH 20 01-2007 18. Okt ober 2007 Stand 11:29 .52 Pfa d: G:vogtf scudsM anualee nudse nt_euds ent.k09 [COMPR ESSIO N FOR ALL IT EMS] This claus e causes UDS /SQL to sto re the rec ords in co mpressed form , prov[...]

  • Pagina 254

    SSL Refer ence secti on 254 U929-J-Z 125-9-76 9.2.3 S et entr y SET NAME IS set-name [POPULA TION IS in teger-1 [ INCR EASE IS in tege r-2 ]] ⎧ CHAI N [ LINKED TO PRIOR ] ⎫   ⎧ POIN TER-A RRAY ⎫ ⎧ ATTACH ED TO OWNE R ⎫ [MODE IS ⎨   ⎬ ] ⎨ ⎬ ⎨ DETACH ED [ WITHIN r ealm-na me-1 ] ⎬    ?[...]

  • Pagina 255

    Referenc e section SSL U929-J-Z125-9- 76 255 Dokus chablonen 19x24 Version 7.3us für FrameMaker V7.x vo m 14.02.2 007 © cognit as GmbH 20 01-2007 18. Okt ober 2007 Stand 11:29 .52 Pfa d: G:vogtf scudsM anualee nudse nt_euds ent.k09 SET NAME IS set- name This claus e is used to specify th e name of th e set to whi ch the s et entr y appli e[...]

  • Pagina 256

    SSL Refer ence secti on 256 U929-J-Z 125-9-76 LIST ma y be speci fied o nly if th e f ollowing c ondition s are s atisfied : – The m embersh ip of the me mber re cord type i n the set was defined as MAND A T OR Y A UT OMA TIC. – Mem ber records (includi ng pointers, se e page 219 , SCD) are no longe r than – 993 bytes for databases with a pa [...]

  • Pagina 257

    Referenc e section SSL U929-J-Z125-9- 76 257 Dokus chablonen 19x24 Version 7.3us für FrameMaker V7.x vo m 14.02.2 007 © cognit as GmbH 20 01-2007 18. Okt ober 2007 Stand 11:29 .52 Pfa d: G:vogtf scudsM anualee nudse nt_euds ent.k09 [INDEX NAME IS na me ⎧ ATTA CHED TO OWNER ⎫ [ PLACI NG IS ⎨ ⎬ ] ⎩ DETA CHED [ WITH IN realm- name ][...]

  • Pagina 258

    Subschema DDL Referenc e section 258 U929-J-Z 125-9-76 9.3 Subschema DDL syntax IDE NTIFICA TION DIVIS ION. SUB -SCHEMA NAM E clau se [PR IVACY L OCK clause ] [PRIVA CY KEY cl ause ]. DAT A DIVIS ION. ARE A SECTI ON. COP Y claus e. RECORD SECTIO N. [CO PY clau se. ] ⎧ [ recor d name clause .   rec ord elem ent nam e clause   [GR OUP-U[...]

  • Pagina 259

    Referenc e section Subs chem a DDL U929-J-Z125-9- 76 259 Dokus chablonen 19x24 Version 7.3us für FrameMaker V7.x vo m 14.02.2 007 © cognit as GmbH 20 01-2007 18. Okt ober 2007 Stand 11:29 .52 Pfa d: G:vogtf scudsM anualee nudse nt_euds ent.k09 9.3 .1 I DENT IFIC A TIO N DIV ISI ON IDENTI FICAT ION DIVI SION. SU B-SCH EMA NAME IS subsche ma[...]

  • Pagina 260

    Subschema DDL Referenc e section 260 U929-J-Z 125-9-76 9.3.3 RECORD SECTION RECORD SE CTIO N. ⎧ COPY ALL RECO RDS. ⎫ [ ⎨ ⎬ ] ⎩ {COPY record -nam e-1 ,...}. ... ⎭ [01 record -nam e-2 . { level-num ber recor d-elem ent- name [ PICTURE IS mask- string ] [ GROU P-USAGE IS NATIONA L ] ⎧ DISPLAY ⎫    COMP UTA TIONAL-3   [...]

  • Pagina 261

    Referenc e section Subs chem a DDL U929-J-Z125-9- 76 261 Dokus chablonen 19x24 Version 7.3us für FrameMaker V7.x vo m 14.02.2 007 © cognit as GmbH 20 01-2007 18. Okt ober 2007 Stand 11:29 .52 Pfa d: G:vogtf scudsM anualee nudse nt_euds ent.k09 USAG E If this e ntr y is omitted , DISPLA Y is assume d by def ault. Excep tion: if the PIC TURE[...]

  • Pagina 262

    Subschema DDL Referenc e section 262 U929-J-Z 125-9-76[...]

  • Pagina 263

    U929-J-Z125-9- 76 263 Dokus chablonen 19x24 Version 7.3us für FrameMaker V7.x vo m 14.02.2 007 © cognit as GmbH 20 01-2007 18. Oktobe r 2007 Sta nd 11:29.52 Pfad : G:vogtf scuds Manualeen udsen t_eud sent.mi x Glossary This Gl ossar y co ntains th e definiti ons of so me of the i mpor tant ter ms and concep ts used i n the UDS/S QL manuals[...]

  • Pagina 264

    A Glossary 264 U929-J-Z 125-9-76 act- ke y (ac tual ke y) Actu al add ress o f a pa ge , consisting of realm nu mber and page numb er . act- ke y-0 pag e Fir st page of a re a l m ; contains general infor mation on the re alm such as – when t he realm was created , – when t he realm was last upda ted, – internal versi on num ber of the r ealm[...]

  • Pagina 265

    Glossary A U929-J-Z125-9- 76 265 Dokus chablonen 19x24 Version 7.3us für FrameMaker V7.x vo m 14.02.2 007 © cognit as GmbH 20 01-2007 18. Oktobe r 2007 Sta nd 11:29.52 Pfad : G:vogtf scuds Manualeen udsen t_eud sent.mi x ALOG sequenc e number See sequence number . anchor re cord Recor d automat ically cr eated by UDS/SQ L as owner r ecor d[...]

  • Pagina 266

    B Glossary 266 U929-J-Z 125-9-76 B back up database See shadow data base . base int erface block (BIB) (Base Inter f ace Block) St andard in terface between UDS/S QL and ea ch individ ual user ; it c ontains, amo ng other t hings, the RECORD AREA (use r records a s defined in the su bschema ). befo re-image Copy of a page taken before its conten ts[...]

  • Pagina 267

    Glossary C U929-J-Z125-9- 76 267 Dokus chablonen 19x24 Version 7.3us für FrameMaker V7.x vo m 14.02.2 007 © cognit as GmbH 20 01-2007 18. Oktobe r 2007 Sta nd 11:29.52 Pfad : G:vogtf scuds Manualeen udsen t_eud sent.mi x CALC table T abl e in the dire ct/ind irect CALC page whose entr ies point to the s tored recor ds. Each li ne contai ns[...]

  • Pagina 268

    C Glossary 268 U929-J-Z 125-9-76 clone pair , clone pubset, c lone session, clone unit A clone u nit is th e copy of an (or iginal) unit (logical disk in BS2000/OS D) at a par tic ular tim e (“P oi nt-in-Ti me co p y ”). The Ti meFind er/Clone c omponent creates this copy optional ly as a complete copy or as a “sn apshot” . After they have [...]

  • Pagina 269

    Glossary C U929-J-Z125-9- 76 269 Dokus chablonen 19x24 Version 7.3us für FrameMaker V7.x vo m 14.02.2 007 © cognit as GmbH 20 01-2007 18. Oktobe r 2007 Sta nd 11:29.52 Pfad : G:vogtf scuds Manualeen udsen t_eud sent.mi x compiler d atabase The re a l m s and files of t he databas e which are required by the UDS /SQL compil er . They ar e ?[...]

  • Pagina 270

    C Glossary 270 U929-J-Z 125-9-76 consistency , logical State of the databas e in whic h the sto red data h as no inte r nal conflict s and reflects th e real-wor ld situati on. co nsi sten cy , physic al State of the databas e in whic h the sto red data is consis tent with r egard to corre ct ph ysical stor age , access pa ths and desc ript ion inf[...]

  • Pagina 271

    Glossary D U929-J-Z125-9- 76 271 Dokus chablonen 19x24 Version 7.3us für FrameMaker V7.x vo m 14.02.2 007 © cognit as GmbH 20 01-2007 18. Oktobe r 2007 Sta nd 11:29.52 Pfad : G:vogtf scuds Manualeen udsen t_eud sent.mi x CRR (Current Recor d of Record) Recor d whic h is mark ed in the curr ency table as the current record of a pa r ticular[...]

  • Pagina 272

    D Glossary 272 U929-J-Z 125-9-76 data pr otection (priv a cy) Protection against u nauthor ized acces s to data. I mplemented in UDS/SQ L by means of the schema /subsch ema conc ept and access a uthor ization. Access rights are granted by means of the BPRIV A CY utility routine. da taba se (DB ) Related data resourc es that ar e e valuated, proce s[...]

  • Pagina 273

    Glossary D U929-J-Z125-9- 76 273 Dokus chablonen 19x24 Version 7.3us für FrameMaker V7.x vo m 14.02.2 007 © cognit as GmbH 20 01-2007 18. Oktobe r 2007 Sta nd 11:29.52 Pfad : G:vogtf scuds Manualeen udsen t_eud sent.mi x database ke y item Item of ty pe DA T A BASE-KE Y or DA T ABASE-K EY -LONG that is us ed to ac com- modate databa se ke [...]

  • Pagina 274

    D Glossary 274 U929-J-Z 125-9-76 DBDIR See database dir ectory . DBH Database Ha ndler : program (or group of programs ) which contr ols acce ss to the database(s) of a sessi on and assume s all th e attendant a dminist rative functions. DBH end End of the DBH program ru n. DBH end can be either a sessi on en d or a s essi on abor t . DBH, independ[...]

  • Pagina 275

    Glossary D U929-J-Z125-9- 76 275 Dokus chablonen 19x24 Version 7.3us für FrameMaker V7.x vo m 14.02.2 007 © cognit as GmbH 20 01-2007 18. Oktobe r 2007 Sta nd 11:29.52 Pfad : G:vogtf scuds Manualeen udsen t_eud sent.mi x DBTT exte nt see DBTT DBTT page P age con taini ng t he DBTT or pa rt of the DBTT f o r a par ticular recor d type . DCA[...]

  • Pagina 276

    D Glossary 276 U929-J-Z 125-9-76 distrib uted transaction T rans action that addresses at least one r emote configuration . A tr ansact ion ca n be distr ibuted ov er : –U D S - D , – openUT M-D , – UDS-D an d openU TM-D . distribution pool Area in the independent DBH used for communication between UDSCT , server tasks , user tasks and the ma[...]

  • Pagina 277

    Glossary E U929-J-Z125-9- 76 277 Dokus chablonen 19x24 Version 7.3us für FrameMaker V7.x vo m 14.02.2 007 © cognit as GmbH 20 01-2007 18. Oktobe r 2007 Sta nd 11:29.52 Pfad : G:vogtf scuds Manualeen udsen t_eud sent.mi x duplicates table Specia l SEARCH-KEY table in which a key value which occur s more tha n once is stored only onc e. F or[...]

  • Pagina 278

    G Glossary 278 U929-J-Z 125-9-76 FP A base See free place administration . FP A extent See free place administration . FP A page F r ee place administr ation pa ge . free place administration (FP A) F re e space is managed b oth at real m lev e l ( FP A pages ) and at page and table lev e l. F ree pl ace admin istration of the pages is ca rried ou [...]

  • Pagina 279

    Glossary I U929-J-Z125-9- 76 279 Dokus chablonen 19x24 Version 7.3us für FrameMaker V7.x vo m 14.02.2 007 © cognit as GmbH 20 01-2007 18. Oktobe r 2007 Sta nd 11:29.52 Pfad : G:vogtf scuds Manualeen udsen t_eud sent.mi x HASHLIB Module l ibrar y f or the storage of hash r outin es for one databa se . I identifie r Name all ocated by the da[...]

  • Pagina 280

    K Glossary 280 U929-J-Z 125-9-76 integrity State of the databas e in whic h the data containe d in it is complet e and free of erro rs. – e ntit y int egrity – r efer ential inte grity – u ser integ rity interc onfiguration Concer ning at l east one remo te conf igur ation . interc onfiguration consistency A dist ributed transac tion that has[...]

  • Pagina 281

    Glossary L U929-J-Z125-9- 76 281 Dokus chablonen 19x24 Version 7.3us für FrameMaker V7.x vo m 14.02.2 007 © cognit as GmbH 20 01-2007 18. Oktobe r 2007 Sta nd 11:29.52 Pfad : G:vogtf scuds Manualeen udsen t_eud sent.mi x key Item used by the database pr ogrammer f or dir ect access to reco rds; an optimized access path is provided for the [...]

  • Pagina 282

    M Glossary 282 U929-J-Z 125-9-76 loca l co nfi gur ation The config uration assigned t o an applica tion pr ogram before it is call ed using /SET -FILE -LINK LINK- NAME=DA T ABASE,FILE -NAME=conf- name. The appl ication pr ogram communicates wi th the loc al confi guration via the communica tion pool . The lo cal co nfigurati on is in the same host[...]

  • Pagina 283

    Glossary M U929-J-Z125-9- 76 283 Dokus chablonen 19x24 Version 7.3us für FrameMaker V7.x vo m 14.02.2 007 © cognit as GmbH 20 01-2007 18. Oktobe r 2007 Sta nd 11:29.52 Pfad : G:vogtf scuds Manualeen udsen t_eud sent.mi x member See member recor d or member r ecord typ e . member , A UT OMA TIC Recor d is in ser ted at storage t ime. member[...]

  • Pagina 284

    N Glossary 284 U929-J-Z 125-9-76 multithreading A mechani sm that e nables the DBH to fully exploit the CP U . Multithr eading mea ns that the DBH proc esses sev eral jobs co ncurrentl y by using so -called threads. Each th read h as informatio n on the c urrent sta tus of a par tic ular job st ored in i t. When a j ob needs to wait f or the c ompl[...]

  • Pagina 285

    Glossary P U929-J-Z125-9- 76 285 Dokus chablonen 19x24 Version 7.3us für FrameMaker V7.x vo m 14.02.2 007 © cognit as GmbH 20 01-2007 18. Oktobe r 2007 Sta nd 11:29.52 Pfad : G:vogtf scuds Manualeen udsen t_eud sent.mi x openUTM (universal transa ction mon itor) F acilitates the creati on and operation of tran s- action-or ient ed applic a[...]

  • Pagina 286

    P Glossary 286 U929-J-Z 125-9-76 page container P ages with a length o f 4000 or 8 096 bytes are em bedded in a so-ca lled page container, which consists of a 64- b yte hea der that pr ecedes the page a nd a 32-byte trailer at the end of the page. page header (page inf o) The first 20 bytes of a datab ase pag e (except f o r the FP A and DBTT pages[...]

  • Pagina 287

    Glossary P U929-J-Z125-9- 76 287 Dokus chablonen 19x24 Version 7.3us für FrameMaker V7.x vo m 14.02.2 007 © cognit as GmbH 20 01-2007 18. Oktobe r 2007 Sta nd 11:29.52 Pfad : G:vogtf scuds Manualeen udsen t_eud sent.mi x PET A Prelimin ar y end of tran saction : UDS-D or openU TM-D sta tement that c auses a prelim inar y tran saction end. [...]

  • Pagina 288

    P Glossary 288 U929-J-Z 125-9-76 primary subtransaction Subt ransact ion tha t run s in the loca l conf iguration . The pri mar y su btransaction is opene d by the first READ Y statem ent in a t rans - action on a lo cal database . If the first RE AD Y statement address es a remote database , UDS-D gene rates a dumm y subt ransact ion as the pr ima[...]

  • Pagina 289

    Glossary R U929-J-Z125-9- 76 289 Dokus chablonen 19x24 Version 7.3us für FrameMaker V7.x vo m 14.02.2 007 © cognit as GmbH 20 01-2007 18. Oktobe r 2007 Sta nd 11:29.52 Pfad : G:vogtf scuds Manualeen udsen t_eud sent.mi x R READ Y Star t o f a transactio n or a pr ocessing c hain in COBOL DML prog rams . READ YC Star t o f a transactio n or[...]

  • Pagina 290

    R Glossary 290 U929-J-Z 125-9-76 RECORD AREA Area in the USER WO RK AREA ( UW A ) which can be referenced by the us er . The record a rea cont ains the r ecor d types and the implicitly defined items (IMPLICITL Y -DEFINED-D A T A-NA MES) of the database such as the AREA-ID items of th e WITHIN c lauses of the schem a. The l ength of the record ar e[...]

  • Pagina 291

    Glossary R U929-J-Z125-9- 76 291 Dokus chablonen 19x24 Version 7.3us für FrameMaker V7.x vo m 14.02.2 007 © cognit as GmbH 20 01-2007 18. Oktobe r 2007 Sta nd 11:29.52 Pfad : G:vogtf scuds Manualeen udsen t_eud sent.mi x remote conf iguration DB- configura tions that are not assi gned to the app lica tion program via /SET -FILE- LINK LI NK[...]

  • Pagina 292

    S Glossary 292 U929-J-Z 125-9-76 rollback Cancelin g of all updates effected within a tr ansacti on . RSQ See r ecor d sequence n umber . RUNUNIT -ID See transaction identification . S sch ema F or malized de scrip tion of all data st ructu res per mi tted in the data base . A UDS/SQL sc hema is defi ned by means o f the Sche ma D DL . Schema DDL F[...]

  • Pagina 293

    Glossary S U929-J-Z125-9- 76 293 Dokus chablonen 19x24 Version 7.3us für FrameMaker V7.x vo m 14.02.2 007 © cognit as GmbH 20 01-2007 18. Oktobe r 2007 Sta nd 11:29.52 Pfad : G:vogtf scuds Manualeen udsen t_eud sent.mi x sequentia l access Access ing a rec o rd on the basi s of its position within a predefi ned rec ord sequenc e. server ta[...]

  • Pagina 294

    S Glossary 294 U929-J-Z 125-9-76 sessi on re start St ar ti ng of th e DBH , under the sa me conf igur ation name and confi gur ation user ID , after a session abort . With the aid of the SLF , the DBH load parameters and the curren t file ide ntifiers whi ch existed when the sess ion abor ted a re re-est ab- lished, a nd the databases of the previ[...]

  • Pagina 295

    Glossary S U929-J-Z125-9- 76 295 Dokus chablonen 19x24 Version 7.3us für FrameMaker V7.x vo m 14.02.2 007 © cognit as GmbH 20 01-2007 18. Oktobe r 2007 Sta nd 11:29.52 Pfad : G:vogtf scuds Manualeen udsen t_eud sent.mi x set SEARCH KEY table SEARCH K EY ta ble f or sele cting a member r ecor d fr om a set occurr ence . SF pubset See single[...]

  • Pagina 296

    S Glossary 296 U929-J-Z 125-9-76 snap pair , snap pubse t, snap session, snap unit A snap un it is the copy of an (or iginal) unit (l ogical d isk in BS 2000/OSD) a t a par tic ular tim e (“P oi nt-in-Ti me co p y ”). The Ti meFind er/Snap c omponent creates this c op y as a “snap shot” i n acco rdance with the “Copy-On-Firs t-Wr ite st r[...]

  • Pagina 297

    Glossary S U929-J-Z125-9- 76 297 Dokus chablonen 19x24 Version 7.3us für FrameMaker V7.x vo m 14.02.2 007 © cognit as GmbH 20 01-2007 18. Oktobe r 2007 Sta nd 11:29.52 Pfad : G:vogtf scuds Manualeen udsen t_eud sent.mi x SQL Interface Bloc k (SIB) Interface between UDS /SQL and SQL app lication program(s); co ntains the SQL st atement, any[...]

  • Pagina 298

    S Glossary 298 U929-J-Z 125-9-76 sub sch ema Section o f a schema requi red f or a particul ar application ; it ca n be res truc tured, within limi ts, f or the intended application ; a subsche ma is define d b y means of the Subschema DDL . Subschema DDL F or malized langu age for defining a subsc hema . Subschema Inf o rmation Area (SSIA) The SSI[...]

  • Pagina 299

    Glossary T U929-J-Z125-9- 76 299 Dokus chablonen 19x24 Version 7.3us für FrameMaker V7.x vo m 14.02.2 007 © cognit as GmbH 20 01-2007 18. Oktobe r 2007 Sta nd 11:29.52 Pfad : G:vogtf scuds Manualeen udsen t_eud sent.mi x system buffer pools Input/outpu t buff er for database pag es (see page ). The buff er is par t of the common po ol ( in[...]

  • Pagina 300

    T Glossary 300 U929-J-Z 125-9-76 T ANGRAM (T as k and Gro up Affinit y Manageme nt) Subsyste m of BS200 0/OSD that p lans the alloc ation of proc essors for task gro ups whic h access large qu antities of shared d ata in multi- task ap plicati ons. task attrib ute TP There are 4 task at tributes in B S2000/O SD: SYS, TP , DIA LOG and BA TCH. Specia[...]

  • Pagina 301

    Glossary U U929-J-Z125-9- 76 301 Dokus chablonen 19x24 Version 7.3us für FrameMaker V7.x vo m 14.02.2 007 © cognit as GmbH 20 01-2007 18. Oktobe r 2007 Sta nd 11:29.52 Pfad : G:vogtf scuds Manualeen udsen t_eud sent.mi x transaction, rolling bac k a T erminatin g a transaction with FINISH W ITH CANCEL, i.e. all updates performed o n the da[...]

  • Pagina 302

    U Glossary 302 U929-J-Z 125-9-76 UDS-D task UDSCT T a sk star ted for each configur ation b y UDS/SQL so that it c an par ti cipate in distr ibuted process ing with UDS- D . UDS/SQL / openUTM-D consistency A transaction that has updated b oth open UTM data and UDS/SQL databases is ter minated in suc h a wa y that th e openUTM data and the UDS/SQ L [...]

  • Pagina 303

    Glossary V U929-J-Z125-9- 76 303 Dokus chablonen 19x24 Version 7.3us für FrameMaker V7.x vo m 14.02.2 007 © cognit as GmbH 20 01-2007 18. Oktobe r 2007 Sta nd 11:29.52 Pfad : G:vogtf scuds Manualeen udsen t_eud sent.mi x V vector Item with repeti tion factor . The repetition f actor must b e greater than 1 . It specif ies how many duplic a[...]

  • Pagina 304

    W Glossary 304 U929-J-Z 125-9-76[...]

  • Pagina 305

    U929-J-Z125-9- 76 305 Dokus chablonen 19x24 Version 7.3us für FrameMaker V7.x vo m 14.02.2 007 © cognit as GmbH 20 01-2007 18. Okt ober 2007 Stand 11:29 .52 Pfa d: G:vogtf scudsM anualee nudse nt_euds ent.ab k Abbre viations A CS Alias Cata log Ser vic e Act-K ey Actual K e y AFIM After-I mage AP Appli cation Pr ogram ASC Ascend ing BIB Ba[...]

  • Pagina 306

    Abbrev iations 306 U929-J-Z 125-9-76 FC Fun ction Code FP A Free Place A dministration GS Gl obal Stor e HSMS Hierarchic St orage Managem ent Syst em ID Identifi cation IQL Interactive Quer y La nguage IQS Int eractiv e Quer y System KDBS K ompatible Datenb ank-Schni ttstelle (= compati ble database inte rf ace) KDCS K o mpatible Datenkommunika tio[...]

  • Pagina 307

    Abbreviations U929-J-Z125-9- 76 307 Dokus chablonen 19x24 Version 7.3us für FrameMaker V7.x vo m 14.02.2 007 © cognit as GmbH 20 01-2007 18. Okt ober 2007 Stand 11:29 .52 Pfa d: G:vogtf scudsM anualee nudse nt_euds ent.ab k SLF Ses sion L og Fil e SQL Stru ctured Que r y Langua ge SSD Solid St ate D isk SSI A SubS chem a In f or mati on Ar[...]

  • Pagina 308

    Abbrev iations 308 U929-J-Z 125-9-76[...]

  • Pagina 309

    U929-J-Z125-9- 76 309 Dokus chablonen 19x24 Version 7.3us für FrameMaker V7.x vo m 14.02.2 007 © cognit as GmbH 20 01-2007 24. Oktobe r 2007 Sta nd 09:07.3 3 Pfad : G:vogtfsc udsM anualee nudsen t_eudse nt.lit Related pub lications The manual s are av ailable as online ma nuals, see http://ma nuals.fujitsu-siemens .com , or in pri nted f o[...]

  • Pagina 310

    Related publications 310 U929-J-Z 125-9-76 UDS-KDBS ( BS 2000/OS D) Compatible Da tabase Interf ace User Guide SQL for UDS/SQL Language Reference Manual BS2000/OSD-BC Commands, V olumes 1 - 5 User Guide BS2000/OSD-BC Commands, V o lume 6, Outp ut in S V ar iables and SDF-P-BASYS User Guide BS2000/OSD-BC System Messages, V olumes 1 - 3 User Guide BS[...]

  • Pagina 311

    Related publications U929-J-Z125-9- 76 311 Dokus chablonen 19x24 Version 7.3us für FrameMaker V7.x vo m 14.02.2 007 © cognit as GmbH 20 01-2007 24. Oktobe r 2007 Sta nd 09:07.3 3 Pfad : G:vogtfsc udsM anualee nudsen t_eudse nt.lit LMS (BS2000) SDF For mat User Guid e DSSM /SSCM Subsystem Management in BS2000/OSD User Guide ARCHIVE (BS200 0[...]

  • Pagina 312

    Related publications 312 U929-J-Z 125-9-76 OMNIS/OMNIS-MENU (TRANS D A T A, BS2000) Administration and Pr ogramming User Guide openUTM Concepts and Functions User Guide openUTM (BS2000/O SD , UNIX, Windows) Programming Applications with KDCS for COBOL, C and C++ User Guide openUTM (BS2000/O SD , UNIX, Windows) Generating Applications User Guide ope[...]

  • Pagina 313

    Related publications U929-J-Z125-9- 76 313 Dokus chablonen 19x24 Version 7.3us für FrameMaker V7.x vo m 14.02.2 007 © cognit as GmbH 20 01-2007 24. Oktobe r 2007 Sta nd 09:07.3 3 Pfad : G:vogtfsc udsM anualee nudsen t_eudse nt.lit DRIVE/WINDO WS (BS2000 ) Programming S ystem User Guid e DRIVE/WINDO WS (BS2000 ) Programming La nguage Ref er[...]

  • Pagina 314

    Related publications 314 U929-J-Z 125-9-76[...]

  • Pagina 315

    U929-J-Z125-9- 76 315 Dokus chablonen 19x24 Version 7.3us für FrameMaker V7.x vo m 14.02.2 007 © cognit as GmbH 20 01-2007 18. Oct ober 2007 Stand 11:29 .53 Pfad: G:vogt fscuds Manuale enudse nt_eu dsent.s ix Inde x 4GL 40 A access concurr ent 54 , 109 contendi ng 263 direct 62 , 84 , 93 , 100 , 153 , 238 , 245 , 246 , 263 sequenti al 84 ,[...]

  • Pagina 316

    Index 316 U929-J-Z 125-9-76 CALC SEARCH key 266 CALC table 210 , 267 CALC table header 210 calcul ation formul as, storage sp ace requ ire men t 177 CALL DML 47 , 26 7 catalog ide ntifier 267 CC 39 CHAIN 130 , 136 , 144 , 15 6 , 223 chain 130 , 144 , 151 , 155 , 26 7 Character Se parated V alue s (CSV) 267 chec k record s 267 checkpoint 267 CHECK-T[...]

  • Pagina 317

    Index U929-J-Z125-9- 76 317 Dokus chablonen 19x24 Version 7.3us für FrameMaker V7.x vo m 14.02.2 007 © cognit as GmbH 20 01-2007 18. Oct ober 2007 Stand 11:29 .53 Pfad: G:vogt fscuds Manuale enudse nt_eu dsent.s ix Data Mani pulation Language ( DML) 27 6 data mo del ing 43 data mo del s 28 data organ ization 38 data page 197 , 215 data pr [...]

  • Pagina 318

    Index 318 U929-J-Z 125-9-76 domain 32 DRIVE 40 DR V 42 dummy subtran saction 276 duplica te table 157 DUPLICA TES clause 87 duplica tes he ader 276 duplica tes table 22 9 , 277 main le v el 277 D YNAMIC claus e 106 , 244 dynamic set 106 , 277 E ESTIMA TE-REPOR T 277 eve n t na me 277 ex clusive buff er pool 277 F F A STP AM ac cess me thod 42 flexi[...]

  • Pagina 319

    Index U929-J-Z125-9- 76 319 Dokus chablonen 19x24 Version 7.3us für FrameMaker V7.x vo m 14.02.2 007 © cognit as GmbH 20 01-2007 18. Oct ober 2007 Stand 11:29 .53 Pfad: G:vogt fscuds Manuale enudse nt_eu dsent.s ix ke y reference number 281 keyw or d 22 L le v e l 189 link age of reco rds 129 , 144 linked-in c ontrol system 28 1 linked-in [...]

  • Pagina 320

    Index 320 U929-J-Z 125-9-76 own er 29 , 36 , 285 O WNER clau se 105 , 245 owner re co rd 70 , 103 , 110 , 140 , 147 , 150 , 159 , 161 , 163 , 16 5 , 251 , 285 owner re co rd typ e 70 , 244 , 285 P P1 ev e nting 288 page 131 , 197 , 198 , 28 5 overf low 138 str uctu re 200 page addr ess 131 , 285 page con tainer 197 , 199 , 286 page feed 235 page fo[...]

  • Pagina 321

    Index U929-J-Z125-9- 76 321 Dokus chablonen 19x24 Version 7.3us für FrameMaker V7.x vo m 14.02.2 007 © cognit as GmbH 20 01-2007 18. Oct ober 2007 Stand 11:29 .53 Pfad: G:vogt fscuds Manuale enudse nt_eu dsent.s ix rea lm re ferenc e 131 realm ref erence numb er 28 9 REALM-RE F (Realm Re f e rence) 131 recon figuration 289 record 32 , 68 ,[...]

  • Pagina 322

    Index 322 U929-J-Z 125-9-76 SEARCH ke y tabl e 93 , 10 2 , 130 , 136 , 140 , 154 , 157 , 172 , 17 7 , 225 , 254 , 257 fo r m 157 naming 240 , 246 pl acem ent 160 , 167 , 172 storage sp ace requ irement 177 seco ndar y key 92 , 100 , 102 , 10 7 , 136 , 139 , 142 , 161 , 168 , 17 2 , 238 , 240 , 244 , 246 , 292 seco ndar y su btransaction 292 secu ri[...]

  • Pagina 323

    Index U929-J-Z125-9- 76 323 Dokus chablonen 19x24 Version 7.3us für FrameMaker V7.x vo m 14.02.2 007 © cognit as GmbH 20 01-2007 18. Oct ober 2007 Stand 11:29 .53 Pfad: G:vogt fscuds Manuale enudse nt_eu dsent.s ix storage m ode 99 , 144 storage spa ce reser vation 143 storage st ru cture 12 9 Storage S tructur e Langua ge (SSL) 51 , 297 s[...]

  • Pagina 324

    Index 324 U929-J-Z 125-9-76 va l u e r an g e 32 of conditi on 192 of item 55 va r i a b l e 22 ve c t o r 53 , 65 , 183 , 189 , 242 , 30 3 v ersion num ber inter nal 30 3 vie w 32 relation al 51 W war m sta r t 30 3 WITHIN clause 10 9 , 16 1 , 168 , 240[...]