API Databases

API Databases

add_db_entry( “P_DB“ VARCHAR(16777216) )

add_db_entry( “P_DB“ VARCHAR(16777216) )

Adds a database entry to the table APP.DBS.

Parameters:

  • P_DB : Name of the new database.

create_db( “P_DB“ VARCHAR(16777216) )

create_db( “P_DB“ VARCHAR(16777216) )

Create the database. The previous procedure is called in this one.

Parameters:

  • P_DB : Name of the new database.

delete_db_entry( “P_DB“ VARCHAR(16777216) )

delete_db( “P_DB“ VARCHAR(16777216) )

delete_db_entry( “P_DB“ VARCHAR(16777216) )

delete_db( “P_DB“ VARCHAR(16777216) )

Similar methods for database deletion.

Parameters:

  • P_DB : Name of the database you want to delete.

get_db_entry()

get_db_entry()

Gets all databases from the table APP.DBS.

resume_database_tasks( “P_DB“ VARCHAR(16777216) )

suspend_database_tasks( “P_DB“ VARCHAR(16777216) )

resume_database_tasks( “P_DB“ VARCHAR(16777216) )

suspend_database_tasks( “P_DB“ VARCHAR(16777216) )

Resumes or resumes and suspends all tasks on the database.

Parameters:

  • P_DB : Name of the database you want to delete.

Examples:

call core.resume_database_tasks('<database_name>'); call core.delete_db('<database_name>');