We create a datamaker subset model, on ORACLE SGBD.
We need to create a post publish action, that will run some commands to delete some lines.
But when Datamaker run the SQL Action; it returns me a error regarding the delimitators we used here.
I run this command on Oracle, and on Datamaker Sql Window, and it worked; but using on the action it returns me the error.
We are using " ; " delimitator...
Which delimitator we need to use on the SQL Action?
Release : 4.9
Component : CA Agile Requirements Designer - TMX Script Generator
Multiple queries in one action are not supported in datamaker. However they are supported in Portal using ';' as a delimiter.
under (Code Type
only) Specify the following fields:
for more details
It is a low priority enhancement but will eventually be addressed in datamaker
Alternatively you can use DDL type action NOT SQL action type in Datamaker to run them