Can anyone tell me the appropriate cobol picture clause to use on a host variable to access a VARCHAR(MAX) column please ?
Currently we have this defined as PIC X(32000) but when interrogating the esql statement generated in Sql profiler this appears to
get converted into a TEXT data type which leads to an SQL error as we wish to use RTRIM.
We need to be moving away from using TEXT data types as Microsoft are indicating they intend to withdraw support.
Any advice would be much, appreciated. Thanks