Execution of this query results in error 905 - Missing right paranthesis.
I want to know the actual reason of this type of query. Is this fomat not supported or something else.
Could you please confirm which OpenText product you are using, I can then move your post to the correct location where experts can review.
I am using Centura Sqlbase 12.2.0
Please update your OpenText Connect account to include "My Support access" by completing this form. Once our support team reviews the request, you will receive confirmation on your access. At that time, you will then be able to post to our Gupta SQLBase product area where we have experts participating and monitoring.