In this blog post, let’s learn about the error message “1310 The CREATE SCHEMA statement does not support the creation of triggers.” when working with HPE NonStop SQL/MX, the reason for the error and the solution to fix this error message.
Error Message
1310 The CREATE SCHEMA statement does not support the creation of triggers.
Reason for the Error
You specified creation of triggers in the CREATE SCHEMA statement.
Solution
Remove the creation of triggers from the CREATE SCHEMA statement and resubmit. Create triggers in separate statements