Derived table sql syntax size limit
I have a query with a very long sql syntax to put in a derived table.
It seems to me that there is a limitation on the numbers of characters or line for the sql syntax.
For example, my query has 3 000 lines but i can only past 1000 lines in the derived table.
Does anyone know what is the limitation and if it is possible to change it ?
If you are using XI 3.0 and above you cand now define derived tables on derived tables by using @Derived(Derivedètable_name) expression in your derived table.
This solution might solve your issue.