No More No Less Part 2

1
No More - No LessPart 2

• Mountain East User Group
• February 27, 2004

David Del Rio DataBaseDetectiv_at_Mindspring.com 949-
644-0399 - office 949-293-9157 -
mobile
2
To The Rescue CMADA - Direct Call
3
1-N syntax in Format Buffer Built into the
ADABAS Nucleus
4
Format Buffer Can use 1-N notationBoth for a
PE groupor for a Multiple Field
5
CMADA - and the 1-N Format
Buffer NotationA great way to processexactly
what is there for PERIODIC GROUP data(and
Multiple Fields)
6
(No Transcript)
7
(No Transcript)
8
(No Transcript)
9
(No Transcript)
10
(No Transcript)
11
(No Transcript)
12
(No Transcript)
13
(No Transcript)
14
(No Transcript)
15
(No Transcript)
16
(No Transcript)
17
(No Transcript)
18
(No Transcript)
19
(No Transcript)
20
(No Transcript)
21
(No Transcript)
22
Now comes STRUCTURED mode
23
(No Transcript)
24
(No Transcript)
25
(No Transcript)
26
(No Transcript)
27
(No Transcript)
28
(No Transcript)
29
(No Transcript)
30
(No Transcript)
31
Now comes REPORT mode
32
(No Transcript)
33
(No Transcript)
34
(No Transcript)
35
(No Transcript)
36
(No Transcript)
37
(No Transcript)
38
(No Transcript)
39

• Reduce PERIODIC overhead via 1-N
• Consulting available from DBD
• DataBaseDetectiv_at_mindspring.com
• 949-644-0399

BUT THERE IS MORE !
40
1-N Syntax is great for reading all occurrences
with the least amount of CPU/space.However,
why are you reading ALL occurrences ?!BECAUSE
the last occurrence is usually themost CURRENT
data !
41
To add NEW data as FIRST occurrence Requires
the END AROUND shiftFor example if 4
occurrences then 4th -gt 5th3rd -gt 4th2nd -gt
3rd1st -gt 2ndnew -gt 1st
42
But this shifting requires indexed code (or
redefined areas)and - if there are any
Descriptors in thePERIODIC group OVERHEAD for
changing EVERY oneof those values( occurrence
number is part of index entry ) and Super
Descriptors are worse !
43
SO - What Can We DO ?!
44
Are You Sitting Down ?

• AS AL JOLSON WOULD SAY
• You Aint Seen Nothing Yet !

45
(No Transcript)
46
(No Transcript)
47
(No Transcript)
48
(No Transcript)
49
(No Transcript)
50
(No Transcript)
51
(No Transcript)
52
(No Transcript)
53
(No Transcript)
54
Now for Multiple Field
55
(No Transcript)
56
(No Transcript)
57
(No Transcript)
58
(No Transcript)
59
(No Transcript)
60
(No Transcript)
61
(No Transcript)
62
Now MU within PE
63
(No Transcript)
64
(No Transcript)
65
(No Transcript)
66
(No Transcript)
67
(No Transcript)
68
(No Transcript)
69
(No Transcript)
70
Do You Want To See

• Nth of the Nth
• (7th son of the 7th son ?!)

71
(No Transcript)
72
(No Transcript)
73
(No Transcript)
74
(No Transcript)
75
(No Transcript)
76
(No Transcript)
77
(No Transcript)
78
(No Transcript)
79
THANK YOU !

• David Del Rio 949-644-0399
• DataBaseDetectiv_at_mindspring.com