Javelin: Length of Query Restriction?

Document ID : KB000014475
Last Modified Date : 14/02/2018
Show Technical Document Details
Question:

As we are unable to register Alias in Datamaker, we are executing insert statements for Alias using Javelin. We are using DB2 – Execute Query in Javelin to execute many insert statements for Alias. We are using semicolons at the end of each query, and no new line character between queries. Still after certain length, we get compilation errors in Javelin. If we use three DB2 - Execute Query boxes to divide the inserts, we do not get compilation errors. The queries used are not static queries. We need to pass variables in all these queries.

Is there any restriction of length in Query field?
Is there another way to execute multiple Alias Inserts in one go?
If I create a file, how will I pass this variable to the file and it should be replaced with this variable? 

Environment:
CA Test Data Manager (TDM)- Javelin
Answer:

There is no limit or restriction on length in the Query field. As the workflow file gets too big, it is good idea to keep it in a file, then have the read file text in a variable, and then pass it to the DB2 Execute Query. String could have double quotes in it which might cause a compilation error. 

Use a token like [CUSTOMER_ID] in text file and use the Assign activity available in primitives. Then set: query = query.Replace("[CUSTOMER_ID]", varCustomerID) 
Where [CUSTOMER_ID] is the token in the text file and varCustomerID is the variable in Javelin that needs to be replaced.

Additional Information:

If you experience any further issues, please open a support case by going to https://www.ca.com/us/services-support/ca-support/contact-support.html