Hello all Image/SQL and Allbase/SQL users:

FIRST:  Please note this is NOT the 2001 SIGImage/SQL
HPSQL Ballot:  THIS IS STILL PRELIMINARY.  Please do
NOT try and vote using this ballot.   Actual balloting for
HPSQL items expected to start "soon" on the web.     :-)

This is current draft HPSQL "A" list;  that will be voted on
to get priority ranking info that will be included with HPSQL
items that are sent forward to the 2001 Interex SIB process.
Note attached list has 12 items.  If none are dropped, then
two will fall out during SIGImage/SQL HPSQL voting prior to
sending forward to the 2001 SIB....

Ability to submit pro and con comments on the following
and additions (if any) expected to be available "soon" on
the Interex web site.  Detailed extended descriptions will
be included / linked as appropriate and as time allows, when
the list is up on the web.  Notice will be given when ready...


NOTE on one item that was on the 2000 HPSQL ballot, but
was dropped by majority vote of attendees at SIG3000:

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

Dropped because available NOW from >= one third-party
vendor (via intermediate PC server or workstation);  plus HP
says no plans to bundle (read that as NO PLANS).

Ken Sletten
SIGImage/SQL Chair
==========================================


2001 SIGImage/SQL Ballot:
HPSQL *Preliminary* pre-SIB "A" List Items:
-------------------------------------------------------

(1)    Ability to limit max number / percent of rows / columns
returned by SQL SELECT;  using a SET option or optional
parameter on SELECT statement (MS SQL/Server
"TOP dd [%]" equivalent):

SIDEBAR:  (1) above was the number one run-away single-
item winner on 2000 SIGHPSQL Ballot.

(2)    Implement TurboIMAGE database DBCLOSE ability
from ODBC / SQL:

(3)    IMAGESQL:  Improve DBA functions for managing
authorization IDs in a DBE:

(4)    Enhance IMAGESQL ATTACH command:  Allow DBA
user to ATTACH without password.   Add three options:
NOAUTOS (skip AUTO Masters), NOAUTOSPLIT (compound
items), and NOVIEWS (allow user to declare DBE views later,
instead of auto-create when ATTACH).  Register IMAGE
Master / Detail referential integrity constraints.

SIDEBAR:  (4) above combines what were five separate items
on just the IMAGESQL ATTACH command on the 2000 Ballot.

(5)    Allow wild-card ADD USER in IMAGESQL:

(6)    Let IMAGE keys split by IMAGESQL during ATTACH be
accessed as a full IMAGE key via SQL at run time:

(7)    ALLBASE and Image/SQL multi-Column INDEXED
retrievals:

(8)    More string manipulation & math functions for Image
and Allbase:

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

(10)  Provide an AUTOINCREMENT Datatype in ALLBASE:

(11)  Bundle all of ALLBASE with Image/SQL (need ninth
module);  at least on the new A-Class and N-Class boxes:

SIDEBAR:  (11) above is a SMALL effort; marketing decision.

(12)  Support SQL NULL ITEM functionality in Image/SQL.

SIDEBAR:  (12) above is a LARGE effort;  but is also a major
missing RDBMS standard functionality in Image/SQL.
===========================================