InterSystems IRIS TSQL Code 536 Invalid length parameter passed to the s

In this post, you’ll learn about the SQL error code 536 in InterSystems IRIS database the reason why you are receiving the TSQL message when using the InterSystems IRIS data platform

Error Code :

536

Reason for the Error code 536 in InterSystems IRIS DBMS

Invalid length parameter passed to the substring function.