Benutzeranleitung / Produktwartung UDS/SQL V2.5 des Produzenten Fujitsu
Zur Seite of 324
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.
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 .
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 . . . . . . . . . . . . . .
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 .
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 .
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 . . . . . . . . . . . .
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 . . . . . . . .
Contents U929-J-Z125-9-76.
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 .
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 .
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.
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 .
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.
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 .
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.
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.
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.
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 dat.
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.
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 real.
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.
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 .
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 ( ) , .
Notational c on ventions Preface 24 U929-J-Z125-9-76.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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 inter.
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.
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-c.
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.
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.
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 .
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.
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.
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.
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.
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 .
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.
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.
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.
T echnical implementation Datab ase desi gn 52 U929-J-Z125-9-76.
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 .
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 .
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.
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.
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.
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 ]] .
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.
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.
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.
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.
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.
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.
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 .
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 .
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.
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 .
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 .
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.
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.
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 .
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.
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 .
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.
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.
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.
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.
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.
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.
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.
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 .
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.
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.
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.
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 .
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.
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.
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.
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.
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.
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 .
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 ,.
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 w.
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.
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.
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.
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 ,.
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.
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.
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 .
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 .
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.
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.
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.
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.
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.
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.
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.
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 ,.
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.
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: .
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.
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 .
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.
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).
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.
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.
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.
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.
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.
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..
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.
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 CURREN.
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.
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 NAM.
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.
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.
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 .
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.
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 .
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.
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 .
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 D.
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 .
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.
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 .
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 i.
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 .
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.
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 .
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.
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 .
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.
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 .
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.
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.
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.
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 .
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 .
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 .
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 .
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 .
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.
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 .
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.
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 .
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.
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 .
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.
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 .
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.
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 .
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 .
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 .
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.
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.
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.
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 .
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 .
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 .
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 .
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.
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.
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.
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.
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.
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 .
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.
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.
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.
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 S.
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.
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.
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.
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 ⎨ ⎬ ].
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.
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.
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.
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 .
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.
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 ]},. .
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 .
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 .
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.
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 .
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 .
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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 spac.
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.
Data page Stru cture of pages 218 U929-J-Z 125-9-76.
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 .
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: Fi.
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.
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.
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.
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.
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.
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.
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.
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 Pag.
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.
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 e.
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.
T abl e struc ture Structure of records and table s 232 U929-J-Z 125-9-76.
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 .
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.
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.
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].
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.
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 ⎨ .
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.
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 ,.
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.
Schema D DL Referenc e section 242 U929-J-Z 125-9-76 ⎧ ⎧ ⎧ 15 ⎫ ⎫⎫ BIN ARY[ ⎨ ⎬ ] FIXED REA L ⎨ ⎩ 31 ⎭ ⎬ ⎩ DEC IMAL[ integer- 1 [, in.
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.
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.
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.
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 .
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.
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]].
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.
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 .
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.
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 ⎬ ]].
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.
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.
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.
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.
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.
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.
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 .
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 ,.
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.
Subschema DDL Referenc e section 262 U929-J-Z 125-9-76.
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.
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 i.
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 .
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 ).
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.
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” .
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 .
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.
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.
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.
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.
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.
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 .
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 .
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.
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.
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 .
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 .
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.
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 .
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 .
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.
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.
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.
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.
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 .
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 .
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.
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.
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 .
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.
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 .
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 .
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 ”).
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.
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 .
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 ).
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.
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.
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 .
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 .
W Glossary 304 U929-J-Z 125-9-76.
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 .
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 nguag.
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 .
Abbrev iations 308 U929-J-Z 125-9-76.
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.
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 Gui.
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.
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, Wi.
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.
Related publications 314 U929-J-Z 125-9-76.
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 .
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 CH.
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 .
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 YNAM.
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 .
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 .
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 .
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 iremen.
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 .
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 wa.
Ein wichtiger Punkt beim Kauf des Geräts Fujitsu UDS/SQL V2.5 (oder sogar vor seinem Kauf) ist das durchlesen seiner Bedienungsanleitung. Dies sollten wir wegen ein paar einfacher Gründe machen:
Wenn Sie Fujitsu UDS/SQL V2.5 noch nicht gekauft haben, ist jetzt ein guter Moment, um sich mit den grundliegenden Daten des Produkts bekannt zu machen. Schauen Sie zuerst die ersten Seiten der Anleitung durch, die Sie oben finden. Dort finden Sie die wichtigsten technischen Daten für Fujitsu UDS/SQL V2.5 - auf diese Weise prüfen Sie, ob das Gerät Ihren Wünschen entspricht. Wenn Sie tiefer in die Benutzeranleitung von Fujitsu UDS/SQL V2.5 reinschauen, lernen Sie alle zugänglichen Produktfunktionen kennen, sowie erhalten Informationen über die Nutzung. Die Informationen, die Sie über Fujitsu UDS/SQL V2.5 erhalten, werden Ihnen bestimmt bei der Kaufentscheidung helfen.
Wenn Sie aber schon Fujitsu UDS/SQL V2.5 besitzen, und noch keine Gelegenheit dazu hatten, die Bedienungsanleitung zu lesen, sollten Sie es aufgrund der oben beschriebenen Gründe machen. Sie erfahren dann, ob Sie die zugänglichen Funktionen richtig genutzt haben, aber auch, ob Sie keine Fehler begangen haben, die den Nutzungszeitraum von Fujitsu UDS/SQL V2.5 verkürzen könnten.
Jedoch ist die eine der wichtigsten Rollen, die eine Bedienungsanleitung für den Nutzer spielt, die Hilfe bei der Lösung von Problemen mit Fujitsu UDS/SQL V2.5. Sie finden dort fast immer Troubleshooting, also die am häufigsten auftauchenden Störungen und Mängel bei Fujitsu UDS/SQL V2.5 gemeinsam mit Hinweisen bezüglich der Arten ihrer Lösung. Sogar wenn es Ihnen nicht gelingen sollte das Problem alleine zu bewältigen, die Anleitung zeigt Ihnen die weitere Vorgehensweise – den Kontakt zur Kundenberatung oder dem naheliegenden Service.
