Split statements Transaction Notification on SAP B1H

[Former Member]

Hi,

I'm migrating a SQL Database to HANA and the transaction notification converted is realy extensive (more than 5000 lines), so when i try to create in HANA Studio i got the following message:

Could not split statements; SQL console content is too large

Statement 'CREATE PROCEDURE SBO_SP_TransactionNotification ( in object_type nvarchar(20), in transaction_type ...'

successfully executed in 2.392 seconds  (server processing time: 2.258 seconds) - Rows Affected: 0

Normally, the transaction notification take like 5 minutes to be created, but when i have the message "Could not split statements; SQL console content is too large" take like 5 seconds, so i'm not sure if this is ok or how to resolve it?

Kind regards,

[lbreddemann · Accepted solution]

This is an error message from the SAP HANA Studio SQL editor.

For several reasons it needs to parse the whole text you pasted into it before actually sending anything to the SAP HANA database.

In case you want to run your SQL command/script as-is you might find it easier to use the command line client hdbsql. There you can simply specify a text file containing your commands to be executed.

Other than that, reducing the overall text/command size might be the only option from within SAP HANA Studio. If your file consists of several commands, try running them one by one.

- Lars

[Former Member · Accepted solution]

Hi Lars,

Thanks for your answer, but in this case i'm working with the SBO Transaction Notification so it can't be executed separatly, the command text need to be completly saved.

I never worked with the hdbsql, do you have an example? it's possible to save the text/command in the hdbsql and be called in the SBO Transaction Notification?

Kind regards,

Juan Pablo

[Former Member · Accepted solution]

Hi Lars,

I solve the problem creating various procedures and then in the SBO Transaction Notification i nested all of them.

Kind regards,

Juan Pablo Fernandez