Variable Length Strings - Effective Retrieval Size Limit Issue

Larry_Jones

Larry_Jones

Legendary Poster
OK- hopefully someone out there has some insight or solution to my issuehere.

Background:
--------------
I have a virtual table (database view described as a JDE Table) that has a large Variable Length String (defined as nvarchar(max) or nText).
I created a DD Item to describe this column to JDE as a Variable Length String (Type 20, Class VARLEN) with a defined size of 99999 (FYI size seems to be immaterial to the issue).

The Issue:
------------
In a simple test UBE I can retrieve the values in this field... but only up to 1695 characters. It gets truncated past that point.
Querying the DB View external to JDE has no such issues. The entire string is retrieved.

Any ideas on what could be causing the issue?
 
Back
Top