Stored Procedure Categories

The stored procedures included in SQL SDK fall into six categories:

Pool Modifiers – These stored procedures change or add the objects that are in a pool. Note that the value for any field can be reassigned.

sp_sql_set_field

sp_sql_set_<type>_field

sp_sql_retrieve_object

sp_sql_make_object

Virtual Ticket/Job Manager/Digital Storage Manager Table Modifiers – These stored procedures save an object from the pool to the database tables or just write into Virtual Ticket/Job Manager/Digital Storage Manager tables.

sp_sql_add_object

sp_sql_add_dr [VT/DSM ONLY]

sp_sql_add_dr_2 [VT ONLY]

sp_sql_add_extended_preview_page [VT/DSM ONLY]

sp_sql_update_object

sp_sql_delete_object

sp_sql_delete_extended_preview_page [VT/DSM ONLY]

sp_sql_get_next_row_id

Pool Viewers – These stored procedures allow you to get the values of fields in the pool or get other information about the pool.

sp_sql_get_field

sp_sql_get_<type>_field

sp_sql_get_<type>_field_part

Notification Procedures – These stored procedures allow you to add, acknowledge, and remove notifications.

sp_sql_add_notification

sp_sql_acknowledge_notifications

sp_sql_remove_notifications

Garbage Disposers – These stored procedures clean the pool by deleting objects no longer in use or delete pools that are no longer in use.

sp_sql_release_object

sp_sql_release_object_of

sp_sql_release_object_all

General Usage – These stored procedures are of general use and may be helpful in utilizing SQL SDK.

sp_sql_drop_procedure

sp_sql_drop_table

sp_sql_drop_trigger

sp_sql_drop_type

sp_sql_drip_view

sp_sql_normalize_date

sp_sql_normalize_time

sp_sql_blob_make_ref_to_object

sp_sql_blob_make_ref_to_pool

sp_sql_blob_make_ref_to_table

sp_sql_blob_parse_ref

sp_sql_blob_updatetext

sp_sql_blob_updatetext_binary

sp_sql_blob_updatetext_blob

sp_sql_blob_udpatetext_string

sp_sql_get_sdk_version

sp_sql_make_sql_transaction_name