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

DB4AI.CREATE_SNAPSHOT

CREATE_SNAPSHOT is a function that creates snapshots for the DB4AI feature, as described in Table 1. You can call this function by using the CREATE SNAPSHOT syntax.

Table 1 DB4AI.CREATE_SNAPSHOT input parameters and return values

Parameter

Type

Description

i_schema

IN NAME

Name of the schema storing snapshots. The default value is the current user or PUBLIC.

i_name

IN NAME

Snapshot name.

i_commands

IN TEXT[]

SQL commands for obtaining data.

i_vers

IN NAME

Version suffix.

i_comment

IN TEXT

Snapshot description.

res

OUT db4ai.snapshot_name

Result.