What’s New

This topic lists the significant new features and changes to existing features in D3 Linux 9.0.

Access

• ACCESS now supports utilizing indexes when using the >, >=, <, <= and # operators.

• The Access File Translate processing code now supports the ability to return a sub-value.

• Implemented the eval, conv, and fmt AQL modifiers.

Administration Console

• Added a new graphical application that allows Administrators to perform D3 administration.

APIs

• MVSP .NET API

Added the MVSP .NET API to allow developers access to MultiValue data and subroutines from Microsoft's Visual .NET Framework. This simplified .NET API allows developers to build applications using the latest versions Visual Studio .NET (and in any Visual Studio .NET development language, including C#, C++ and Visual Basic).

Features include:

1. • Supports executing and capturing TCL command results

   • Supports executing AQL queries and returning results in a resultset

   • Supports calling Pick/BASIC subroutines

   • Supports these functions: read, readu, write, writeu, delete, release, fileSelect, readNext, root, key

   • Supports these MultiValue functions: count, dcount, delete, extract, field, swap, insert, replace

   • Installation includes the following folder:

• MVSP Java API

Added the MVSP Java API to allow developers access to MultiValue data and subroutines from the Java programming language. This is a simplified Java API that allows Java developers to build applications using their preferred Java IDE.

Features include:

1. • Supports executing and capturing TCL command results

   • Supports executing AQL queries and returning results in a structured array

   • Supports calling Pick/BASIC subroutines

   • Supports these functions: read, readu, write, writeu, delete, release, fileSelect, readNext

   • Supports these MultiValue functions: count, dcount, delete, extract, field, swap

   • Installation includes the following folders:

Basic Compiler

• Added a flashbasic command with (n and (f options to enable or disable FlashBASIC runtime, respectively. When disabled, runtime will execute the BASIC object code.

Editor

• Added the ability to set an item lock from the Editor using the new i option with the ed command or by adding an i in attribute 3 of the ed command definition.

File Management

• Added the "DQ" file type which allows sequential processes (such as Count, Select, and so on) on "DQ" files to execute without locking the file control block. Eliminates lock contention when a file with an index or a callx trigger is updated while a sequential processes is running against it.

• Added the ability to create a case sensitive account with the new (s option to the create-account command.

Hot-Backup

• Enhanced Hot-Backup to better enable distinguishing two different instances of the already running message.

• Enhanced the Hot-Backup Helper processes to ensure they obey the log slave updates flag.

Indexes

• Implemented numeric indexes in the VME. Note that for numeric indexes to work properly, numeric data must be stored in scaled internal format (that is, with no decimal or thousands separators {-} n {n...}). This ensures correct behavior when accessing numeric indexes.

• Enhanced list-index to return whether an index is numeric.

• Enhanced verify-index to properly verify numeric indexes.

• Enhanced the index management commands to allow an ADI to be specified as the reference to the index.

IPv6

• Added support for IPv6.

Licensing

• Added activation licensing to Hot-Backup.

• Enhanced licensing to allow 3 connections from one IP address using a single license with a maximum of 2 connections of each type (ODBC or Turnkey Telnet only). For the first connection from an IP address you will get a maximum of 3 connections for the cost of 1 user license. Within the 3 connections you can have a maximum of 2 of any type before additional user licenses is consumed.

Memory

• 64-bit versions of Linux will support a shared memory segment of up to 3.5 GB on D3 9.0.

MVSP QuickStart Guide

• The MVSP QuickStart Guide is a new document that describes setting up a server for the MultiValue Server Protocol (MVSP) account and configuring accounts and users on the server. The MVSP account is the server-side component that allows MVSP clients (.NET and Java) supplied with D3 9.0 to access data stored in MultiValue databases. This guide (MVSP.pdf) is installed in the Documentation directory.

OSFI

• Added the OSFI "binx" driver which allows reading, manipulating, and writing D3 binary items. This allows processes such as BASIC to read using the binx driver, returning a hexadecimal string of characters, which can then be modified and written back to the file.

• The OpenDB OSFI driver now supports longer SQL statements.

Overflow Handler

• Implemented the set-runaway-autoquit command to allow instructing processes to automatically quit in the event of an overflow runaway condition, rather than displaying a message and prompting Continue or Quit.

• Added the ability to set runaway limits for individual pibs with the new (l option on the set-runaway-limit command.

Programs & Utilities

• Implemented the ptype command to return whether a Basic program is a subroutine or a main program.

• Implemented the :exec-always-capture command. When this switch is set to on, an execute with capturing will receive output even if the basic program is activated by a PROC ph command.

• Added the (q option to the odbc-setup stop function. This new option allows bypassing the confirmation prompt and stops all servers.

Save/Restore

• Added the ability to verify an incremental (Update) save tape with the new (u option of the t-verify command.

Supported Operating Systems

• D3 Linux 9.0 is now supported on the CentOS Linux distribution (32 or 64 bit).

SQL/ODBC

• Increased the internal buffersize of an ODBC connection from 1k to 8k. This allows updates of larger columns (attributes).

System

• Implemented the file-access-setup utility to facilitate the creation of system privileges in compliance with the Sarbanes-Oxley Act.