Updated on 2024-08-20 GMT+08:00

DB4AI.PREPARE_SNAPSHOT_INTERNAL

PREPARE_SNAPSHOT_INTERNAL is a built-in execution function of the DB4AI.PREPARE_SNAPSHOT function, as described in Table 1. The function involves information verification and cannot be directly called.

Table 1 Input parameters of DB4AI.PREPARE_SNAPSHOT_INTERNAL

Parameter

Type

Description

s_id

IN BIGINT

Snapshot ID.

p_id

IN BIGINT

Parent snapshot ID.

m_id

IN BIGINT

Matrix ID.

r_id

IN BIGINT

Root snapshot ID.

i_schema

IN NAME

Snapshot schema.

i_name

IN NAME

Snapshot name.

i_commands

IN TEXT[]

DDL and DML commands for modifying snapshots.

i_comment

IN TEXT

Snapshot description.

i_owner

IN NAME

Snapshot owner.

i_idx

INOUT INT

Index of exec_cmds.

i_exec_cmds

INOUT TEXT[]

DDL and DML commands for execution.

i_mapping

IN NAME[]

Maps user columns to backup columns. A rule is generated if the value is not NULL.