Skip to content
≡

Administrator

Developer

Tools

External Tools

4. New Features of Altibase Version 7.1.0.0.9#

This chapter introduces new features available for Altibase version 7.1.0.0.9.

Improved Features#

AUTHID Option#

The user can specify the permission to execute a procedure, function, or package in a stored procedure. If omitted, it executes with constructor authority and refers to the object.

  • AUTHID CURRENT_USER : User authority

  • AUTHID DEFINER: Definer authority

Please refer to the manual below for more information.

  • Stored Procedures Manual > Chapter 2. SQL Statements for Managing Stored Procedures > CREATE PROCEDURE, CREATE FUNCTION

  • Stored Procedures Manual > Chapter 11. Stored Package > CREATE PACKAGE

  • General Reference > Chapter 3. The Data Dictionary > SYS_PACKAGES_, SYS_PROCEDURES_

Character Function#

The following character functions have been added:

  • REGEXP_REPLACE
    : Finds the matching string and replace it with another character or remove it.

Please refer to the manual below for more information.

  • SQL Reference> Chapter 7. SQL Functions> Character functions

Others#

autoextend off#

When changing the auto-extend size of a tablespace, the size can be changed without executing 'autoextend off'.

Properties#

New Properties#

  • LB_MSGLOG_COUNT

  • LB_MSGLOG_FILE

  • LB_MSGLOG_FLAG

  • LB_MSGLOG_SIZE