List of procedures

Name

Comment

ap_check_existence_sp

Used by object checking.

ap_compare_fkeys_sp

Compares fkeys in two tables and mirrors differences.

ap_compare_sequences_sp

Compares two sequences in different schemas.

ap_compare_tables_sp

Compares two tables in different schemas.

ap_compare_tabletypes_sp

Compares two table types to each other.

ap_compare_types_sp

Compare two user-defined types to each other.

ap_compare_xmlschemas_sp

Compares two XML schemas to each other.

ap_cop_get_all_sp

Retrieves install configuration properties.

ap_cop_install_sp

Install one entry in abaconfigproperties.

ap_cos_delete_subsys_sp

Delete configuration for a subsystem/database.

ap_cos_insert_sp

Insert setting of configuration option for subsystem/database.

ap_ddltri_sp

Help procedure for the DDL triggers in AbaPerls.

ap_error_handler_sp

Standard error handler

ap_hso_add_extra_sp

Writes an extra row to abahistsysobjects for -restruct.

ap_hso_get_dropobjects_sp

Gets all objects to drop at the end of a -restruct.

ap_hso_purge_old_sp

Utility procedure to trim down abahistsysobjects in size.

ap_inh_insert_sp

Insert row in abainstallhistory.

ap_ixd_ischanged_sp

Determines whether an index has changed.

ap_ixd_update_sp

Writes a row to abaindexdefinitions.

ap_list_to_table

UDF that unpacks a string to a table.

ap_obt_install_sp

Install one entry in abaobjecttypes.

ap_onoff

Translats bit to ON or OFF.

ap_oss_get_all_settings_sp

Get all settings for a table/index.

ap_oss_get_db_settings_sp

Returns storages settings not owned by AbaPerls.

ap_oss_script_index_sp

Scripts an index from the database.

ap_ppc_update_sp

Writes a row to abaprocparamcache.

ap_print_excec_cmd_sp

Internal SP for dynamic SQL

ap_quotestring

Quotes a string.

ap_rac_do_saved_cmds_sp

Rerun server-level commands on other AG nodes.

ap_rma_insert_sp

Inserts a row into abarepositorymappings

ap_sib_get_revokeall_sp

Produces REVOKE statements for all known objects.

ap_sla_translate_sp

Inserts a labels to abasslabels and translates it.

ap_sob_find_schemabound_ref_sp

Finds schemabound references.

ap_sob_get_fileversion_sp

Gets version information from a file-spec.

ap_sob_get_versioninfo_sp

Gets information about on objects from abasysobejcts.

ap_sob_getdrop_for_restruct_sp

Returns objects that must be dropped before a -restruct.

ap_sob_prepare_restruct_sp

Run inintially by DBBUILD -restruct

ap_sob_report_suspects_sp

Report odd things in abasysobjects.

ap_sob_retarget_synonyms_sp

Retarget the synonyms in a file to a different DB/server.

ap_sob_update_sp

Insert/update/delete an object in abasysobjects.

ap_spp_delete_oldcert_sp

Deletes an old certificate no longer in use.

ap_spp_grant_asssemperms_sp

Grants permission for a privileged assembly.

ap_spp_grant_perms_sp

Grants permission for a privileged module.

ap_spp_insert_spp

Inserts a row into abaspecialperms.

ap_spp_reload_database_sp

Reloads all special permissions in a database.

ap_spp_reload_server_sp

Reloads special permissions in all databases.

ap_spp_restore_for_object_sp

Restores permissions granted on an object.

ap_stp_install_sp

Install SP for abastorageproperties.

ap_sub_dereg_sp

Deregister a subsystem.

ap_sub_get_all_sp

Get all subsystems and settings in database.

ap_sub_insert_sp

Adds a subsystem.

ap_sub_rename_sp

Renames a subsystem.

ap_sub_update_sp

Updates a subsystem entry.

ap_zz_enable_constraints_sp

Enables all constraint in a database.

ap_zz_sob_load_sp

Loads all objects to abasysobjects.