HP 3000 Manuals HP 3000 Manuals
HP ALLBASE/QUERY Enhancements by Victor Veres Australian Software Operation This release of HP ALLBASE/QUERY features a number of enhancements: * EZCreate * EZUpdate * DATE/TIME data support * User settable SQL ISOLATION LEVEL for EZReport transaction * Full 16 bit localizability The following describes these features. EZCREATE The EZCreate module allows users to view, create, delete or modify SQL tables using a simple forms based interface. New tables can be added to any DBEFileset that the user nominates. The user is also able to control whether a table is created as PRIVATE or PUBLIC. All SQL datatypes are supported, including the new DATE/TIME data type. The authorization to modify the database still lies with the SQL security set-up, so systems administrators still have full control over the database. EXUPDATE With the EZUpdate module a user is able to specify a query using EZAccess or SQLAccess and then view, add, delete or update data on a record by record basis using a screen based interface. The interface allows the viewing and entry of long data items using scrolling and expanded field mechanisms. EZReport has also been enhanced to display long fields in a multi-line wrapped format. The internal transaction management utilizes the SQL COMMIT KEEP CURSOR mechanism to reduce the impact on the system of EZUpdate users. DATE/TIME DATA SUPPORT HP ALLBASE/QUERY supports the newly added HP ALLBASE/SQL DATE/TIME datatype. This support extends to EZAccess, EZCreate, EZReport and EZUpdate. The facility has been added for EZAccess users to be able to specify the isolation level that EZReport uses for reports. The default is RC, meaning that EZReport users will not significantly reduce system concurrency on databases. The stricter RR level of locking is also available for critical reports. HP ALLBASE/QUERY is now fully localizable for 8 and 16 bit languages.