Fujitsu UDS/SQL V2.5 manuale d’uso

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 .com Certifi ed docume ntatio n acc[...]

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 . [...]

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 . . . . . . . . .[...]

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[...]

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[...]

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 . . . . . .[...]

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 .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 [...]

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[...]

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[...]

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[...]

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 [...]

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[...]

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[...]

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 [...]

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[...]

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[...]

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[...]

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[...]

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[...]

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[...]

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[...]

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. It also ex plain[...]

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[...]

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[...]

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[...]

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[...]

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[...]

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[...]

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[...]

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[...]

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 [...]

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[...]

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[...]

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[...]

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[...]

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[...]

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[...]

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[...]

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[...]

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[...]

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[...]

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[...]

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[...]

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[...]

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 [...]

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[...]

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[...]

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[...]

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 .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[...]

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[...]

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[...]

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: [...]

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[...]

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[...]

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[ ⎨ [...]

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[...]

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 [...]

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[...]

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[...]

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 [...]

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[...]

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 [...]

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[...]

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[...]

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[...]

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 [...]

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[...]

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[...]

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[...]

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[...]

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[...]

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 [...]

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[...]

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[...]

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 ?[...]

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 [...]

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[...]

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[...]

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[...]

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[...]

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[...]

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[...]

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[...]

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[...]

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[...]

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[...]

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,[...]

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[...]

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 [...]

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[...]

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[...]

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 [...]

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[...]

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[...]

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[...]

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 [...]

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[...]

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[...]

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 ?[...]

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 [...]

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[...]

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 ). [...]

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[...]

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[...]

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 [...]

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[...]

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[...]

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 [...]

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 [...]

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[...]

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[...]

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[...]

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[...]

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[...]

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 [...]

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[...]

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[...]

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.k04 4.13 Reser ved w or ds of the DDL compiler ACCEPT AC CESS A CTUAL AD ADD ADV ANCIN G [...]

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-[...]

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[...]

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[...]

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[...]

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[...]

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 [...]

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[...]

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[...]

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[...]

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[...]

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 [...]

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 [...]

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[...]

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 [...]

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 “[...]

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 [...]

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[...]

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 [...]

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 ([...]

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[...]

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[...]

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[...]

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[...]

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 [...]

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[...]

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[...]

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[...]

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[...]

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[...]

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[...]

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[...]

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[...]

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[...]

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[...]

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[...]

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[...]

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[...]

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[...]

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[...]

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 [...]

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[...]

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[...]

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 ),[...]

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. 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 [...]

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: [...]

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 [...]

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 [...]

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[...]

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[...]

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[...]

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[...]

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[...]

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[...]

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[...]

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 [...]

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[...]

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[...]

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 [...]

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[...]

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, [...]

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[...]

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[...]

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 [...]

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[...]

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 ?[...]

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 . [...]

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[...]

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[...]

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 [...]

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[...]

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[...]

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[...]

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[...]

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[...]

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[...]

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 [...]

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 [...]

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[...]

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[...]

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[...]

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 [...]

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[...]

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 [...]

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[...]

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[...]

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[...]

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[...]

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 [...]

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[...]

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 [...]

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[...]

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[...]

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[...]

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 .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[...]

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[...]

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[...]

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[...]

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[...]

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[...]

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[...]

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[...]

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[...]

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[...]

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[...]

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[...]

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[...]

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 .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[...]

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 [...]

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 [...]

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[...]

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[...]

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[...]

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,[...]

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[...]

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[...]

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[...]

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   [...]

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[...]

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 ⎨ ⎬ [...]

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[...]

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 ⎨[...]

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 [...]

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[...]

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[...]

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[...]

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[...]

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[...]

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 ] ⎬    ?[...]

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[...]

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 [...]

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 ][...]

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[...]

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[...]

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   [...]

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[...]

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.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[...]

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[...]

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[...]

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[...]

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[...]

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 [...]

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 ?[...]

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[...]

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[...]

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[...]

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 [...]

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[...]

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[...]

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[...]

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[...]

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 [...]

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[...]

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[...]

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 [...]

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[...]

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[...]

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[...]

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[...]

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[...]

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 . 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[...]

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[...]

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[...]

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[...]

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[...]

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[...]

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[...]

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[...]

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[...]

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[...]

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[...]

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[...]

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[...]

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[...]

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 [...]

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[...]

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 .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[...]

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[...]

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[...]

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.fujitsu-siemens .com , or in pri nted f o[...]

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[...]

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[...]

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[...]

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[...]

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 .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 ,[...]

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[...]

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 [...]

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[...]

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 [...]

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[...]

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 ,[...]

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[...]

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[...]

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[...]