Skip to main content

I have a column in my database that needs to be 20,000 characters. I defined it as varchar(max), using a cobol program I was able to insert the data using a host variable defined as Pic X(20000), however when I tried to read the data using the same host variable no data is retrieved but I get a sqlcode of 0. The primary key is a numeric value. I tried to use the host variable syntax definition as described in the documentation but that didn't work either. Any ideas on how I can get this to work? We are using Acucobol version 8.1.3.1.

Thanks

I have a column in my database that needs to be 20,000 characters. I defined it as varchar(max), using a cobol program I was able to insert the data using a host variable defined as Pic X(20000), however when I tried to read the data using the same host variable no data is retrieved but I get a sqlcode of 0. The primary key is a numeric value. I tried to use the host variable syntax definition as described in the documentation but that didn't work either. Any ideas on how I can get this to work? We are using Acucobol version 8.1.3.1.

Thanks

AcuSQL access to varchar columns is limited to <= 4000.  See the documentation here:

documentation.microfocus.com/.../GUID-EEC95B72-9D64-4546-AAB6-3367089F214B.html