==== 3.4.1. Enable the standard PMX stored procedure ====

The following sections describe the process of enabling the standard PMX stored procedure with Microsoft SQL (section [[implementation:wms:install_standardstoredprocedure#with_microsoft_sql_server| 3.4.1.1]]) and SAP HANA (section [[implementation:wms:install_standardstoredprocedure#with_sap_hana| 3.4.1.2]]). 

=== 3.4.1.1. With Microsoft SQL Server ===

After the configuration is done, you need to enable the (custom) stored procedures in the stored procedure of SAP named “SBO_TransactionNotification”.

When applying the Produmex Add-on the first time to a database, you also need to adapt the stored procedure “SBO_SP_TransactionNotification”.

1. Open SQL Server Management Studio and connect to your database server.

2. Expand the Databases folder and locate the database to which you want to apply the Produmex Add-on.

3. Open this database directory and open the “Programmability\Stored Procedures” subdirectory.

4. Locate the “dbo.PMX_SP_TransactionNotification” stored procedure, right-click it and select “Modify”. 

{{:implementation:5.1.1.png?nolink|Enable the standard PMX stored procedure}}

5. Locate the “Produmex Logex Addon Code” at the end of this stored procedure (see illustration below)
 
{{:implementation:5.1.2.png?nolink|Enable the standard PMX stored procedure}}

6. Copy the “Produmex Logex Addon Code”. \\
Now paste the code into the “dbo.SBO_SP_TransactionNotification” stored procedure as follows.

7. Locate the “dbo.SBO_SP_TransactionNotification” stored procedure, right-click it and select''Modify''.
 
{{:implementation:5.1.3.png?nolink|Enable the standard PMX stored procedure}}

8. Paste the “Produmex Logex Addon Code” at the end of it. With a new installation you will see a marked area like “-- ADD YOUR CODE HERE”.

{{ :implementation:install:boyum:25._add_your_code_here.png |}}

9. Uncomment the SP by clicking on the ''Uncomment'' button in SQL Management Studio.

{{:implementation:5.1.5.jpg?nolink|Enable the standard PMX stored procedure}}

10. Execute the SBO_SP_TransactionNotification stored procedure. 

Continue with section [[implementation:wms:install_standardstoredprocedure#Enable_a_custom_stored_procedure|3.4.2. Enable a custom stored procedure]].

=== 3.4.1.2. With SAP HANA ===

After the configuration is done you need to enable the (custom) stored procedures in the stored procedure of SAP named “SBO_TRANSACTIONNOTIFICATION”.

When applying the Produmex Add-on the first time to a database you will also need to adapt the stored procedure “SBO_SP_TRANSACTIONNOTIFICATION”

1. Open the SAP HANA Studio and connect to your SAP HANA server.

2. Expand the “Catalog” folder and locate the schema to which you want to apply the Produmex Add-on.

3. Right-click on this schema and select “SQL Console” to open a new SQL console.

{{:implementation:hanastudio5.png?nolink|Enable the standard PMX stored procedure}}

Keep this SQL console open during the whole process.

4. Expand the schema directory and open the “Procedures” subdirectory.

5. Locate the “SBO_SP_TRANSACTIONNOTIFICATION” stored procedure, right-click it and select “Open Definition”. 

{{:implementation:hanastudio3.png?nolink|Enable the standard PMX stored procedure}}

6. Open its content by opening the //Create Statement// tab:

{{:implementation:hanastudio4.png?nolink|Enable the standard PMX stored procedure}}

7. Copy the content into the SQL console.

8. Locate the “PMX_SP_TransactionNotification” stored procedure, right-click it and select “Open Definition”.

{{:implementation:hanastudio1.png?nolink|Enable the standard PMX stored procedure}}

9. Open its content by opening the //Create Statement// tab, and locate the “Produmex Logex Addon Code” at the end of this stored procedure (see illustration below).
 
{{ :implementation:install:boyum:26._produmex_logex_addon_code_hana.png |Enable the standard PMX stored procedure}}

10. Copy the “Produmex Logex Addon Code”.

11. This code should now be pasted into the SQL console, where you have already pasted the content of the “SBO_SP_TRANSACTIONNOTIFICATION” stored procedure. Paste the “Produmex Logex Addon Code” at the end of it. With a new installation you will see a marked area like “-- ADD YOUR CODE HERE”.

12. Uncomment the copied code by removing the leading '--' from each line.

13. Add the following line on the top of your SQL console:\\
''DROP PROCEDURE SBO_SP_TransactionNotification;''

The SQL console should look like this:

{{ :implementation:install:boyum:27._produmex_logex_addon_code_hana_2.png |Enable the standard PMX stored procedure}}

14. Execute the code in your SQL console to modify the SBO_SP_TRANSACTIONNOTIFICATION procedure.