‘00

#

SIB

ID

Enhancement Summary

Item

votes

Item

rank

01

97A01

Ability to limit max number/percent of rows/columns returned in response to an ODBC request (SQL/Server "TOP dd [%]"):

10

14

02

98A05

Ability to limit max number/percent of rows/columns returned by SELECT; using a set option or optional parameter on SELECT:

60

1

03

97A02

Throttling control for ODBCLINK Server Process (limit # of con current ODBC connections (Workload Manager for priority) ):

2

37

04

97A09

Enhance ODBCLink/SE Server process to optionally be able to run under INETD (must change NetIPC to standard sockets):

5

27

05

97A18

Enhance ODBCLink/SE to use a thread safe model (cannot do multiple connections under NT, so useless from web page):

21

3

06

98A12

Implement TurboIMAGE DBCLOSE ability from ODBC / SQL:

3

31

07

97I51

Allow Image/SQL to be an ODBC CLIENT as well as server:

12

10

08

97I52

Improve DBA functions for managing authorization IDs in a DBE:

14

7

09

97I53

Enable / Disable end-user SQL access without Attach / Detach:

9

19

10

97I54

Allow DBA user to ATTACH IMAGE database without password:

11

12

11

97I55

Don’t require exclusive DBE access for all IMAGESQL functions:

12

10

12

97I56

IMAGESQL ATTACH NOAUTOS option: Skip Auto Masters:

21

3

13

00I57

IMAGESQL ATTACH NOAUTOSPLIT option: Do not split compound items; instead map as a single column:

10

14

14

00I58

IMAGESQL ATTACH NOVIEWS option: Do not auto-create views in the DBE; allow user to declare their own views later:

9

19

15

97I59

ATTACH register Master/Detail referential integrity constraints:

18

5

16

97I60

Allow wild-card ADD USER in IMAGESQL:

15

6

17

99I61

Do not require IMAGE Maintenance Word in IMAGESQL if none is specified in the IMAGE database:

10

14

18

99I62

Let split IMAGE keys be accessed as a full key at run time:

10

14

19

00I63

Provide an "UNSPLIT" command in IMAGESQL:

6

24

20

97I64

Bundled ability to retain/reuse IMAGESQL ATTACH parameters if DETACH (3rd-Party Freeware that does this available now):

1

38

21

00I65

Ability to rename IMAGE dataset in a DBE with IMAGESQL (does NOT change dataset name in IMAGE database):

3

31

22

97A04

ALLBASE and Image/SQL multi-Column INDEXED retrievals:

13

9

23

97A05

Additional string manipulation and math functions for ALLBASE and Image/SQL:

10

14

24

97A06

Provide ANSI/SQL CASE statement or equivalent in ALLBASE and Image/SQL. Also Oracle DCODE & Microsoft IIF functions:

14

7

25

97A10

Allow creation of temporary DBE tables that are specific to a connection. Drop on terminate (MS SQL/Server can do now):

6

24

26

97A12

Enhance DBE stored procedures to allow a variable to be used as the owner part of a table name:

3

31

27

97A13

Minimize number & duration of locks on DBE SYSTEM.TABLE during SELECT statement (poor performance in some cases):

6

24

28

97A15

SQL Enabling Extensions for the PERL scripting language:

0

43

29

98A01

Increase number of DBE tables / views allowed in SELECT. Current max is 31. Advanced queries like UNIONS need more:

4

29

30

98A03

User Exits for ALLBASE and Image/SQL (custom functions):

1

38

31

98A04

Enhance SQL Optimizer to support TID scans on Image/SQL tables if predicate contains more than one TID joined by OR’s:

0

43

32

98A06

Allow ALLBASE functions to be used as arguments in procedure statements, not just SELECTs (would allow direct assignment of a host variable without using SELECT):

1

38

33

98A10

Provide an AUTOINCREMENT Datatype in ALLBASE:

11

12

34

98A11

Improved ALLBASE error messages for constraint violations (message should indicate WHICH constraint or key it refers to):

3

31

35

97I66

Support SQL SAVEPOINT in Image/SQL (be able to roll back to checkpoint with SQL ROLLBACK WORK statement):

0

43

36

98I68

Bundle all of ALLBASE with Image/SQL (need 9^th module):

27

2

37

00I69

Support SQL Two-Phase COMMIT in Image/SQL:

3

31

38

97I70

Support SQL NULL item functionality in Image/SQL:

7

22

39

97A07

Option to drop tables without also dropping dependent views, rules, and procedures when restructuring an ALLBASE table:

1

38

40

97A08

Enhance utilities like SQLGEN to recognize Image/SQL tables; and NOT uselessly generate schemas for IMAGE data sets:

5

27

41

97A16

Improved distribution mechanism for ALLBASE documentation (out of date and poorly organized). Look at CD-ROM, HTML:

4

29

42

97A17

Improved user interface for the ALLBASE DBA utilities. Need integrated, consistent GUI front end combining ISQL, SQLUTIL, SQLGEN, and IMAGESQL (possible 3^rd party solution now):

8

21

43

98A07

Provide a mechanism to HINT the SQL query optimizer regarding the best or most efficient data access path:

3

31

44

98A09

Allow DBA to Enable/Disable DDL from ISQL (Allbase ONLY):

1

38

45

99A01

Provide a convenient mechanism to perform a PARTIAL restore of one or more tables in an ALLBASE DBE:

7

22

‘00

#

SIB

ID

Enhancement Summary

Item

votes

Item

rank

02

98A05

Ability to limit max number/percent of rows/columns returned by SELECT; using a set option or optional parameter on SELECT:

60

1

36

98I68

Bundle all of ALLBASE with Image/SQL (need 9^th module):

27

2

05

97A18

Enhance ODBCLink/SE to use a thread safe model (cannot do multiple connections under NT, so useless from web page):

21

3

12

97I56

IMAGESQL ATTACH NOAUTOS option: Skip Auto Masters:

21

3

15

97I59

ATTACH register Master/Detail referential integrity constraints:

18

5

16

97I60

Allow wild-card ADD USER in IMAGESQL:

15

6

08

97I52

Improve DBA functions for managing authorization IDs in a DBE:

14

7

24

97A06

Provide ANSI/SQL CASE statement or equivalent in ALLBASE and Image/SQL. Also Oracle DCODE & Microsoft IIF functions:

14

7

22

97A04

ALLBASE and Image/SQL multi-Column INDEXED retrievals:

13

9

07

97I51

Allow Image/SQL to be an ODBC CLIENT as well as server:

12

10

11

97I55

Don’t require exclusive DBE access for all IMAGESQL functions:

12

10

10

97I54

Allow DBA user to ATTACH IMAGE database without password:

11

12

33

98A10

Provide an AUTOINCREMENT Datatype in ALLBASE:

11

12

01

97A01

Ability to limit max number/percent of rows/columns returned in response to an ODBC request (SQL/Server "TOP dd [%]"):

10

14

13

00I57

IMAGESQL ATTACH NOAUTOSPLIT option: Do not split compound items; instead map as a single column:

10

14

17

99I61

Do not require IMAGE Maintenance Word in IMAGESQL if none is specified in the IMAGE database:

10

14

18

99I62

Let split IMAGE keys be accessed as a full key at run time:

10

14

23

97A05

Additional string manipulation and math functions for ALLBASE and Image/SQL:

10

14

09

97I53

Enable / Disable end-user SQL access without Attach / Detach:

9

19

14

00I58

IMAGESQL ATTACH NOVIEWS option: Do not auto-create views in the DBE; allow user to declare their own views later:

9

19

42

97A17

Improved user interface for the ALLBASE DBA utilities. Need integrated, consistent GUI front end combining ISQL, SQLUTIL, SQLGEN, and IMAGESQL (possible 3^rd party solution now):

8

21

38

97I70

Support SQL NULL item functionality in Image/SQL:

7

22

45

99A01

Provide a convenient mechanism to perform a PARTIAL restore of one or more tables in an ALLBASE DBE:

7

22

19

00I63

Provide an "UNSPLIT" command in IMAGESQL:

6

24

25

97A10

Allow creation of temporary DBE tables that are specific to a connection. Drop on terminate (MS SQL/Server can do now):

6

24

27

97A13

Minimize number & duration of locks on DBE SYSTEM.TABLE during SELECT statement (poor performance in some cases):

6

24

04

97A09

Enhance ODBCLink/SE Server process to optionally be able to run under INETD (must change NetIPC to standard sockets):

5

27

40

97A08

Enhance utilities like SQLGEN to recognize Image/SQL tables; and NOT uselessly generate schemas for IMAGE data sets:

5

27

29

98A01

Increase number of DBE tables / views allowed in SELECT. Current max is 31. Advanced queries like UNIONS need more:

4

29

41

97A16

Improved distribution mechanism for ALLBASE documentation (out of date and poorly organized). Look at CD-ROM, HTML:

4

29

06

98A12

Implement TurboIMAGE DBCLOSE ability from ODBC / SQL:

3

31

21

00I65

Ability to rename IMAGE dataset in a DBE with IMAGESQL (does NOT change dataset name in IMAGE database):

3

31

26

97A12

Enhance DBE stored procedures to allow a variable to be used as the owner part of a table name:

3

31

34

98A11

Improved ALLBASE error messages for constraint violations (message should indicate WHICH constraint or key it refers to):

3

31

37

00I69

Support SQL Two-Phase COMMIT in Image/SQL:

3

31

43

98A07

Provide a mechanism to HINT the SQL query optimizer regarding the best or most efficient data access path:

3

31

03

97A02

Throttling control for ODBCLINK Server Process (limit # of concurrent ODBC connections (Workload Manager for priority) ):

2

37

20

97I64

Bundled ability to retain/reuse IMAGESQL ATTACH parameters if DETACH (3rd-Party Freeware that does this available now):

1

38

30

98A03

User Exits for ALLBASE and Image/SQL (custom functions):

1

38

32

98A06

Allow ALLBASE functions to be used as arguments in procedure statements, not just SELECTs (would allow direct assignment of a host variable without using SELECT):

1

38

39

97A07

Option to drop tables without also dropping dependent views, rules, and procedures when restructuring an ALLBASE table:

1

38

44

98A09

Allow DBA to Enable/Disable DDL from ISQL (Allbase ONLY):

1

38

28

97A15

SQL Enabling Extensions for the PERL scripting language:

0

43

31

98A04

Enhance SQL Optimizer to support TID scans on Image/SQL tables if predicate contains more than one TID joined by OR’s:

0

43

35

97I66

Support SQL SAVEPOINT in Image/SQL (be able to roll back to checkpoint with SQL ROLLBACK WORK statement):

0

43