User Tools

Site Tools


implementation:wms:install_standardstoredprocedure

Differences

This shows you the differences between two versions of the page.

Link to this comparison view

implementation:wms:install_standardstoredprocedure [2018/01/17 15:54]
csuhaa created
implementation:wms:install_standardstoredprocedure [2019/09/17 13:27] (current)
vise upgrading to 19.2
Line 1: Line 1:
-==== 3.3.1. Enable the standard PMX stored procedure ==== +==== 3.4.1. Enable the standard PMX stored procedure ==== 
-=== 3.3.1.1. With Microsoft SQL Server ===+=== 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”. 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” +When applying the Produmex Add-on the first time to a database you also need to adapt the stored procedure “SBO_SP_TransactionNotification” 
-  * To do this open “SQL Server Management Studio” and connect to your database server. + 
-  ​* ​Expand the “Databases” folder and locate the database to which you want to apply the Produmex Add-on. +1. Open “SQL Server Management Studio” and connect to your database server. 
-  ​* ​Open this database directory and open the “Programmability\Stored Procedures” subdirectory. + 
-  ​* ​Locate the “dbo.PMX_SP_TransactionNotification” stored procedure, right-click it and select “Modify”. ​+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|}} {{:​implementation:​5.1.1.png?​nolink|}}
  
-Locate the “Produmex Logex Addon Code” at the end of this stored procedure (see illustration below)+5. Locate the “Produmex Logex Addon Code” at the end of this stored procedure (see illustration below)
    
 {{:​implementation:​5.1.2.png?​nolink|}} {{:​implementation:​5.1.2.png?​nolink|}}
  
-Copy the “Produmex Logex Addon Code”. \\ +6. Copy the “Produmex Logex Addon Code”. \\ 
-This code should now be pasted in the “SBO_SP_TransactionNotification” stored procedure, modify this stored procedure ​in the same way you modified the PMX_SP_TransactionNotification.+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|}} {{:​implementation:​5.1.3.png?​nolink|}}
  
-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”.+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:​5.1.4.png?nolink|}}+{{ :​implementation:​install:​boyum:​25._add_your_code_here.png |}}
  
-Afterwards you need to uncomment ​the SP by clicking the “uncomment” ​button in SQL management studio. +9. Uncomment ​the SP by clicking ​on the ''​Uncomment'' ​button in SQL management studio.
-The end result should look like this:+
  
 {{:​implementation:​5.1.5.jpg?​nolink|}} {{:​implementation:​5.1.5.jpg?​nolink|}}
Line 32: Line 37:
 After these modifications. Execute the SBO_SP_TransactionNotification stored procedure. After these modifications. Execute the SBO_SP_TransactionNotification stored procedure.
  
-=== 3.3.1.2. With SAP HANA ===+=== 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”. 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” When applying the Produmex Add-on the first time to a database you will also need to adapt the stored procedure “SBO_SP_TRANSACTIONNOTIFICATION”
-  * To do this open “SAP HANA Studio” and connect to your SAP HANA server. + 
-  ​* ​Expand the “Catalog” folder and locate the schema to which you want to apply the Produmex Add-on. +1. Open the SAP HANA Studio and connect to your SAP HANA server. 
-  ​* ​Right-click on this schema and select “SQL Console” to open a new SQL console+ 
 +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|}} {{:​implementation:​hanastudio5.png?​nolink|}}
Line 45: Line 53:
 Keep this SQL console open during the whole process. Keep this SQL console open during the whole process.
  
-Then locate the “SBO_SP_TRANSACTIONNOTIFICATION” stored procedure:​ +4. Expand the schema directory and open the “Procedures” subdirectory. 
-  * Expand the schema directory and open the “Procedures” subdirectory. + 
-  ​* ​Locate the “SBO_SP_TRANSACTIONNOTIFICATION” stored procedure, right-click it and select “Open Definition”. ​+5. Locate the “SBO_SP_TRANSACTIONNOTIFICATION” stored procedure, right-click it and select “Open Definition”. ​
  
 {{:​implementation:​hanastudio3.png?​nolink|}} {{:​implementation:​hanastudio3.png?​nolink|}}
  
-Open its content by opening the Create ​statement” ​tab:+6. Open its content by opening the //Create ​Statement// ​tab:
  
 {{:​implementation:​hanastudio4.png?​nolink|}} {{:​implementation:​hanastudio4.png?​nolink|}}
  
-Copy the content into the SQL console.+7. Copy the content into the SQL console.
  
-Next, locate ​the “PMX_SP_TransactionNotification” stored procedure, right-click it and select “Open Definition”.+8. Locate ​the “PMX_SP_TransactionNotification” stored procedure, right-click it and select “Open Definition”.
  
 {{:​implementation:​hanastudio1.png?​nolink|}} {{:​implementation:​hanastudio1.png?​nolink|}}
  
-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)+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:​hanastudio2.png?nolink|}}+{{ :​implementation:​install:​boyum:​26._produmex_logex_addon_code_hana.png |}} 
 + 
 +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.
  
-  * Copy the “Produmex Logex Addon Code”. +13Add the following line on the top of your SQL console:\\
-  * 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”. +
-  * You also need to uncomment the copied code by removing the leading '​--'​ from each line. +
-  * Finally, add the following line on the top of your SQL console:\\+
 ''​DROP PROCEDURE SBO_SP_TransactionNotification;''​ ''​DROP PROCEDURE SBO_SP_TransactionNotification;''​
  
-The SQL console should look like this+Now the SQL console should look like this:
  
-{{:​implementation:​hanastudio6.png?nolink|}}+{{ :​implementation:​install:​boyum:​27._produmex_logex_addon_code_hana_2.png |}}
  
-Finally, execute ​the code in your SQL console to modify the SBO_SP_TRANSACTIONNOTIFICATION procedure.+14. Execute ​the code in your SQL console to modify the SBO_SP_TRANSACTIONNOTIFICATION procedure.
implementation/wms/install_standardstoredprocedure.txt · Last modified: 2019/09/17 13:27 by vise