I am using in my stored procedure a very long sql inside EXECUTE IMMEDIATE
EXECUTE IMMEDIATE 'sql statements'
The problem is when I reach some kind of of characters (approx. 4000) inside EXECUTE IMMEDIATE, I cannot save the stored procedure because I got an error like
{0:0} The data type for parameter or SQL variable (is not supported in the routine, compound SQL statement, or parameter list of a cursor value constructor.. SQLCODE=-789, SQLSTATE=429BB, DRIVER=4.28.11
Will be their any character limitation?, when yes can we force to ignore?
DB2 Enterprise Server Edition: 11.1 DB2 v11.1.4.5, Fixpack 5