Jump to content United States-English
HP.com Home Products and Services Support and Drivers Solutions How to Buy
» Contact HP
HP.com home

ALLBASE/SQL specifications

» 

Business systems evolution

Site information

» Features archive
» Newsletters

HP e3000 program

» Home
» Transition training
» MPE/iX education
» Case Studies
» How to buy
» Technical resources
» Information library
» European information

Learn more about

» Linux® on HP Integrity servers
» Microsoft® Windows®
Content starts here
Content starts here

» ALLBASE/SQL technical specifications data sheet
(PDF 95 KB)
   

Standard features with ALLBASE/SQL


Industry standards for open, portable applications
  • ANSI/SQL '92, Entry Level Compliance
  • Microsoft ODBC via ODBCLink/SE
  • FIPS 127.1
  • X/A Compliance/Two-Phase Commit for CICS, Transarc and Tuxedo on HP 9000

Support for business-critical applications

  • Worldwide 24 x 7 Support for Unavailable Databases
  • "Hot" online backup for 24-hour availability (with TurboSTORE/iX 7x24 True-Online Backup)
  • Forward, rollback and on-line recovery
  • Replication for disaster recovery/remote backup/decision support
  • Row/page/table locking for maximum concurrency
  • Multi-processor support

Powerful application development capabilities

  • Stored procedures
  • Database triggers/business rules
  • Referential integrity
  • Binary Long Object (BLOB) support for both client/server and terminal/host
  • Multi-row stored procedures
  • Fourth generation languages including: Microsoft Visual Basic, PowerSoft PowerBuilder, Cognos PowerHouse, IBI Focus, Speed-Ware, Uniface and more!

High performance for queries and updates

  • ALLBASE/SQL performance tool bundled at no cost
  • Cost-based optimizer
  • Hash and B-tree indices
  • Outer joins
  • Faster table scans with parallel pre-fetch
  • Optimizer access path and modification capabilities

product information

» overview and features
» specifications
» latest enhancements
  » technology notes

hp e3000 transition program

  » initiatives
  » products
  » partners
» services
» resources
   

** About PDF files: The PDF files on this Web site can be read online or printed using Adobe® Acrobat® Reader. If you do not have this software installed on your system, you may download it from the Adobe Web site.
Privacy statement Using this site means you accept its terms Feedback to webmaster
© 2009 Hewlett-Packard Development Company, L.P.