’00

#

SIB

ID

Enhancement Summary

Item

votes

Item

rank

01

97I01

IMAGE multi-record / multi-set DBGET, DBPUT, & DBUDPATE (process entire blocks of data instead of just individual records):

22

16

02

97I02

New IMAGE GETUPDATE intrinsic, to retrieve/update record(s) in one call without prior DBGET (saves overhead, plus simplifies coding if just want to change data regardless of current value):

29

11

03

97I03

Concurrent IMAGE read-only DBLOCK mode (repeatable read). Allow multiple reads, but force all DBLOCKs for WRITE access to be treated serially while READ lock was in effect:

40

5

04

97I04

DBUTIL: Non-destructive creator access across groups:

35

8

05

97I05

DBUTIL ignore file equations (can’t use / does not apply anyway):

30

10

06

97I06

Make DBSCHEMA fully SQL-aware:

18

21

07

97I07

DBSCHEMA ability to specify all DBUTIL flags/settings (has not "kept up" with many recent changes to DBUTIL):

24

13

08

98I08

DBSCHEMA: Allow Masters to be declared after Details:

8

32

09

98I09

DBSCHEMA option: Allow symbolic expressions for capacity:

9

30

10

98I10

DBSCHEMA option: Optionally auto calculate PATH count:

12

26

11

99I11

DBSCHEMA: Flag ALLBASE reserved words with WARNing (no restrictions now). Would catch conflicts up-front, instead of only later if IMAGE database is ATTACHed to a DBE:

17

22

12

97I12

IMAGE DCE compatibility (Security, directory services, etc.):

6

37

13

97I13

Better DBUPDATE performance for IMAGE Sort Fields with CIUPDATE (compare new value to old, then search for new position in the "right" direction, instead of start at end of chain):

39

6

14

97I14

Global file FOPEN (system-wide "handle" for a file), to improve performance and avoid single-process max # of open files limit (several sites are already hitting this limit). IMAGE & other PM processes could then access the file via file system intrinsics:

48

2

15

97I15

Option to set max IMAGE chain lengths, with unique key option:

52

1

16

97I16

Measurement Interface (MI) for IMAGE performance data. Analogous to the MPE MI and GLANCE. Note at least one "non-MI" 3^rd-party performance tool is available now:

39

6

17

98I17

Allow >16 paths in a DETAIL dataset ( >16 in Master "Soon"):

15

23

18

99I18

Ability to pass DBOPEN to son process, if IMAGE database is in a stable state (avoid unnecessary duplicate DBOPENs):

24

13

19

00I19

IMAGE Linear Fast MASTER Dataset Expansion / "Inflation":

12

26

20

00I20

Drop need for IMAGE BlockLength to be a multiple of 256B (save space):

20

18

21

00I21

Allow IMAGE databases under HFS directories (but retain six- character limit on database name):

20

18

22

00I22

Provide external documentation for DBQUIESCE intrinsic used by TURBOSTORE, including appropriate end-user cautions:

21

17

23

00I23

Make IMAGE thread aware / thread safe.

44

3

24

97I24

Provide a MULTIFIND update / delete function in IMAGE QUERY (currently read-only for multiple records):

11

28

25

97I25

Ability to access DBCONTROL and DBINFO in QUERY (to get info on and control new features like TPI, DDX, and B-Trees):

8

32

26

97I26

Data integrity: Support IMAGE dynamic transactions in QUERY (DBBEGIN / DBEND and DBXBEGIN / DBXEND):

9

30

27

98I27

QUERY FIND, MULTIFIND, & SUBSET display running count of records retrieved and / or percent complete, without <CTRL-Y>:

19

20

28

99I28

UNconditional QUERY IMAGE lock option (just conditional lock now). Would avoid "do you wish to wait" question, and queue QUERY locks with compatible locks by other apps:

7

34

29

00I29

Add features from old "Advanced QUERY" (AQ) to QUERY:

10

29

30

97I30

Allow default values for FIELDs not specified at DBPUT time, with equivalent to SQL/Server "AUTOINCREMENT" feature:

24

13

31

97I31

Allow tracking files to be associated with an IMAGE database (all associated files; such as schemas, 3rd-party indexes, etc.):

41

4

32

97I32

Tool "memory area" associated with a database (allow logging of tool-specific IMAGE data on structural problems, etc.):

14

24

33

97I33

Provide Date / Time and other new datatypes or "attributes" in IMAGE:

27

12

34

97I34

IMAGE Support for Binary Large Objects (BLOBS) / BLOB Pointers (store large BLOBs externally; small BLOBs ??):

31

9

35

98I35

Allow positive data in PACKED / ZONED decimal Items to be defined in IMAGE as UNSIGNED (P/Z) or SIGNED (P+/Z+):

5

38

36

99I36

Tag to associate COBOL picture info with an IMAGE data item:

3

40

37

99I37

Tag(s) to record internal IMAGE errors, to reduce repair time:

7

34

38

99I38

LOCL tag, to allow DBAs to add local IMAGE ENCHILADA info:

7

34

39

99I39

Tags for one or more aliases / views for IMAGE items, fields, & sets; without needing to use an Allbase DBE for that capability:

5

38

40

99I40

Tag for IMAGE "Linked Procedures", (might allow approximation of Stored Procedures, if DBUTIL was enhanced to ENABLE):

14

24

’00

#

SIB

ID

Enhancement Summary

Item

votes

Item

rank

15

97I15

Option to set max IMAGE chain lengths, with unique key option:

52

1

14

97I14

Global file FOPEN (system-wide "handle" for a file), to improve performance and avoid single-process max # of open files limit (several sites are already hitting this limit). IMAGE & other PM processes could then access the file via file system intrinsics:

48

2

23

00I23

Make IMAGE thread aware / thread safe.

44

3

31

97I31

Allow tracking files to be associated with an IMAGE database (all associated files; such as schemas, 3rd-party indexes, etc.):

41

4

03

97I03

Concurrent IMAGE read-only DBLOCK mode (repeatable read). Allow multiple reads, but force all DBLOCKs for WRITE access to be treated serially while READ lock was in effect:

40

5

13

97I13

Better DBUPDATE performance for IMAGE Sort Fields with CIUPDATE (compare new value to old, then search for new position in the "right" direction, instead of start at end of chain):

39

6

16

97I16

Measurement Interface (MI) for IMAGE performance data. Analogous to the MPE MI and GLANCE. Note at least one "non-MI" 3^rd-party performance tool is available now:

39

6

04

97I04

DBUTIL: Non-destructive creator access across groups:

35

8

34

97I34

IMAGE Support for Binary Large Objects (BLOBS) / BLOB Pointers (store large BLOBs externally; small BLOBs ??):

31

9

05

97I05

DBUTIL ignore file equations (can’t use / do not apply anyway):

30

10

02

97I02

New IMAGE GETUPDATE intrinsic, to retrieve/update record(s) in one call without prior DBGET (saves overhead, plus simplifies coding if just want to change data regardless of current value):

29

11

33

97I33

Provide Date / Time and other new datatypes or "attributes" in IMAGE:

27

12

07

97I07

DBSCHEMA ability to specify all DBUTIL flags/settings (has not "kept up" with many recent changes to DBUTIL):

24

13

18

99I18

Ability to pass DBOPEN to son process, if IMAGE database is in a stable state (avoid unnecessary duplicate DBOPENs):

24

13

30

97I30

Allow default values for FIELDs not specified at DBPUT time, with equivalent to SQL/Server "AUTOINCREMENT" feature:

24

13

01

97I01

IMAGE multi-record / multi-set DBGET, DBPUT, & DBUDPATE (process entire blocks of data instead of just individual records):

22

16

22

00I22

Provide external documentation for DBQUIESCE intrinsic used by TURBOSTORE, including appropriate end-user cautions:

21

17

20

00I20

Drop need for IMAGE BlockLength to be a multiple of 256B (save space):

20

18

21

00I21

Allow IMAGE databases under HFS directories (but retain six- character limit on database name):

20

18

27

98I27

QUERY FIND, MULTIFIND, & SUBSET display running count of records retrieved and / or percent complete, without <CTRL-Y>:

19

20

06

97I06

Make DBSCHEMA fully SQL-aware:

18

21

11

99I11

DBSCHEMA: Flag ALLBASE reserved words with WARNing (no restrictions now). Would catch conflicts up-front, instead of only later if IMAGE database is ATTACHed to a DBE:

17

22

17

98I17

Allow >16 paths in a DETAIL dataset ( >16 in Master "Soon"):

15

23

32

97I32

Tool "memory area" associated with a database (allow logging of tool-specific IMAGE data on structural problems, etc.):

14

24

40

99I40

Tag for IMAGE "Linked Procedures", (might allow approximation of Stored Procedures, if DBUTIL was enhanced to ENABLE):

14

24

10

98I10

DBSCHEMA option: Optionally auto calculate PATH count:

12

26

19

00I19

IMAGE Linear Fast MASTER Dataset Expansion / "Inflation":

12

26

24

97I24

Provide a MULTIFIND update / delete function in IMAGE QUERY (currently read-only for multiple records):

11

28

29

00I29

Add features from old "Advanced QUERY" (AQ) to QUERY:

10

29

09

98I09

DBSCHEMA option: Allow symbolic expressions for capacity:

9

30

26

97I26

Data integrity: Support IMAGE dynamic transactions in QUERY (DBBEGIN / DBEND and DBXBEGIN / DBXEND):

9

30

08

98I08

DBSCHEMA: Allow Masters to be declared after Details:

8

32

25

97I25

Ability to access DBCONTROL and DBINFO in QUERY (to get info on and control new features like TPI, DDX, and B-Trees):

8

32

28

99I28

UNconditional QUERY IMAGE lock option (just conditional lock now). Would avoid "do you wish to wait" question, and queue QUERY locks with compatible locks by other apps:

7

34

37

99I37

Tag(s) to record internal IMAGE errors, to reduce repair time:

7

34

38

99I38

LOCL tag, to allow DBAs to add local IMAGE ENCHILADA info:

7

34

12

97I12

IMAGE DCE compatibility (Security, directory services, etc.):

6

37

35

98I35

Allow positive data in PACKED / ZONED decimal Items to be defined in IMAGE as UNSIGNED (P/Z) or SIGNED (P+/Z+):

5

38

39

99I39

Tags for one or more aliases / views for IMAGE items, fields, & sets; without needing to use an Allbase DBE for that capability:

5

38

36

99I36

Tag to associate COBOL picture info with an IMAGE data item:

3

40