Focal Point Banner


As of December 1, 2020, Focal Point is retired and repurposed as a reference repository. We value the wealth of knowledge that's been shared here over the years. You'll continue to have access to this treasure trove of knowledge, for search purposes only.

Join the TIBCO Community
TIBCO Community is a collaborative space for users to share knowledge and support one another in making the best use of TIBCO products and services. There are several TIBCO WebFOCUS resources in the community.

  • From the Home page, select Predict: WebFOCUS to view articles, questions, and trending articles.
  • Select Products from the top navigation bar, scroll, and then select the TIBCO WebFOCUS product page to view product overview, articles, and discussions.
  • Request access to the private WebFOCUS User Group (login required) to network with fellow members.

Former myibi community members should have received an email on 8/3/22 to activate their user accounts to join the community. Check your Spam folder for the email. Please get in touch with us at community@tibco.com for further assistance. Reference the community FAQ to learn more about the community.


Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     [CASE OPENED] Maximum Limit of Alphanumeric Define/Compute Fields

Read-Only Read-Only Topic
Go
Search
Notify
Tools
[CASE OPENED] Maximum Limit of Alphanumeric Define/Compute Fields
 Login/Join
 
Master
posted
As per documentation(WF8), maximum limit for alpha fields is 4095 characters.

But below sample code uses around 30,000 for field XYZ_1 and it still works fine in 8009.

Any one foresee any issues with beyond 4K characters?

-* File test_max_alpha_define.fex
 
-SET &XYZ='123121212121212121212121212121212123121212312121212121212121212121212121212312121231212121212121212121212121212121231212123121212121212121212121212121212123121212312121212121212121212121212121212312121231212121212121212121212121212121231212123121212121212121212121212121212123121212312121212121212121212121212121212312121231212121212121212121212121212121231212123121212121212121212121212121212123121212312121212121212121212121212121212312121231212121212121212121212121212121231212123121212121212121212121212121212123121212312121212121212121212121212121212312121231212121212121212121212121212121231212123121212121212121212121212121212123121212312121212121212121212121212121212312121231212121212121212121212121212121231212123121212121212121212121212121212123121212312121212121212121212121212121212312121231212121212121212121212121212121231212123121212121212121212121212121212123121212312121212121212121212121212121212312121231212121212121212121212121212121231212123121212121212121212121212121212123121212312121212121212121212121212121212312121231212121212121212121212121212121231212123121212121212121212121212121212123121212312121212121212121212121212121212312121231212121212121212121212121212121231212123121212121212121212121212121212123121212312121212121212121212121212121212312121231212121212121212121212112121212121212312121231212121212121212121212121212121231212123121212121212121212121212121212123121212312121212121212121212121212121212312121231212121212121212121212121212121231212123121212121212121212121212121212123121212312121212121212121212121231212123121212121212121212121212121212123121212312121212121212121212121212121212312121231212121212121212121212121212121231212123121212121212121212121212121212123121212312121212121212121212121212121212312121231212121212121212121212121212121231212123121212121212121212121212121212123121212312121212121212121211212121212121212121212312121231212121212121212121212121212121231212123121212121212121212121212121212123121212312121212121212121212121212121212312121231212121212121212121212121212121231212123121212121212121212121212121212123121212312121212121212121212121212121212312121231212121212121212121212121212121231212123121212121212121212121212121212123121212312121212121212121212121212121212312121231212121212121212121212121212121231212123121212121212121212121212121212123121212312121212121212121212121212121212312121231212121212121212121212121212121231212123121212121212121212121212121212123121212312121212121212121212121212121212312121231212121212121212121212121212121231212123121212121212121212121212121212123121212312121212121212121212121212121212312121231212121212121212121212121212121231212123121212121212121212121212121212123121212312121212121212121212121212121212312121231212121212121212121212121212121231212123121212121212121212312121231212121212121212121212121212121231212123121212121212121212121212121212123121212312121212121212121212121212121212312121231212121212121212121212121212121231212123121212121212121212121212121212123121212312121212121212121212121231212123121212121212121212121212121212123121212312121212121212121212121212121212312121231212121212121212121212121212121231212123121212121212121212121212121212123121212312121212121212121212121212121212312121231212121212121212121212121212121231212123121212121212121212121212121212123121212312121212121212121211212121212121212121212312121231212121212121212121212121212121231212123121212121212121212121212121212123121212312121212121212121212121212121212312121231212121212121212121212121212121231212123121212121212121212121212121212123121212312121212121212121212121212121212312121231212121212121212121212121212121231212123121212121212121212121212121212123121212312121212121212121212121212121212312121231212121212121212121212121212121231212123121212121212121212121212121212123121212312121212121212121212121212121212312121231212121212121212121212121212121231212123121212121212121212121212121212123121212312121212121212121212121212121212312121231212121212121212121212121212121231212123121212121212121212121212121212123121212312121212121212121212121212121212312121231212121212121212121212121212121231212123121212121212121212121212121212123121212312121212121212121212121212121212312121231212121212121212121212121212121231212123121221212121231212123121212121212121212121212121212123121212312121212121212121212121212121212312121231212121212121212121212121212121231212123121212121212121212121212121212123121212312121212121212121212121212121212312121231212121212121212121212121212121231212123121212121212121212121212121212123121212312121212121212121212121212121212312121231212121212121212121212121212121231212123121212121212121212121212121212123121212312121212121212121212121212121212312121231212121212121212121212121212121231212123121212121212121212121212121212123121212312121212121212121212121212121212312121231212121212121212121212123121212312121212121212121212121212121212312121231212121212121212121212121212121231212123121212121212121212121212121212123121212312121212121212121212121212121212312121231212121212121212121212121212121231212123121212121212121212121212121212123121212312121212121212121212121212121212312121231212121212121212121121212121212121212121231212123121212121212121212121212121212123121212312121212121212121212121212121212312121231212121212121212121212121212121231212123121212121212121212121212121212123121212312121212121212121212121212121212312121231212121212121212121212121212121231212123121212121212121212121212121212123121212312121212121212121212121212121212312121231212121212121212121212121212121231212123121212121212121212121212121212123121212312121212121212121212121212121212312121231212121212121212121212121212121231212123121212121212121212121212121212123121212312121212121212121212121212121212312121231212121212121212121212121212121231212123121212121212121212121212121212123121212312121212121212121212121212121212312121231212121212121212121212121212121231212123121212121212121212121212121212123121212312121212121212121212121212121212312121231212121212121212121212121212121231212123121212121212121212121212121212123121212312121212121212121212121212121212312121231212121212121212121212121212121231212123121212121212121212121212121212123121212312121212121212121212121212121212312121231212121212121212121212121212121231212123121212121212121212121212121212123121212312121212121212121212121212121212312121231212121212121212121212121212121231212123121212121212121212121212121212123121212312121212121212121212121212121212312121231212121212121212121212121212121231212123121212121212121212121212121212123121212312121212121212121212121212121212312121231212121212121212121212121212121231212123121212121212121212121212312121231212121212121212121212121212121231212123121212121212121212121212121212123121212312121212121212121212121212121212312121231212121212121212121212121212121231212123121212121212121212121212121212123121212312121212121212121212121212121212312121231212121212121212121212121212121231212123121212121212121212121212121212123121212312121212121212121212121212121212312121231212121212121212121212121212121231212123121212121212121212121212121212123121212312121212121212121212121212121212312121231212121212121212121212121212121231212123121212121212121212121212121212123121212312121212121212121212121212121212312121231212121212121212121212121212121231212123121212121212121212121212121212123121212312121212121212121212121212121212312121231212121212121212121212121212121231212123121212121212121212121212121212123121212312121212121212121212121212121212312121231212121212121212121212121212121231212123121212121212121212121212121212123121212312121212121212121212121212121212312121231212121212121212121212121212121231212123121212121212121212121212121212123121212312121212121212121212121212121212312121231212121212121212121212121212121231212123121212121212121212121212121212123121212312121212121212121212121212121212312121231212121212121212121212121212121231212123121212121212121212121212121212123121212312121212121212121212121212121212312121231212121212121212121212121212121231212123121212121212121212121212121212123121212312121212121212121212121212121212312121231212121212121212121212121212121231212123121212121212121212121212121212123121212312121212121212121212121212121212312121231212121212121212121212121212121231212123121212121212121212121212121212123121212312121212121212121212121212121212121231212123121212121212121212121212121212123121212312121212121212121212121212121212312121231212121212121212121212121212121231212123121212121212121212121212121212123121212312121212121212121212121212121212312121231212121212121212121212121212121231212123121212121212121212121212121212123121212312121212121212121212121212121212312121231212121212121212121212121212121231212123121212121212121212121212121212123121212312121212121212121212121212121212312121231212121212121212121212121212121231212123121212121212121212121212121212123121212312121212121212121212121212121212312121231212121212121212121212121212121231212123121212121212121212121212121212123121212312121212121212121212121212121212312121231212121212121212121212121212121231212123121212121212121212121212121212123121212312121212121212121212121212121212312121231212121212121212121212121212121231212123121212121212121212121212121212123121212312121212121212121212121212121212312121231212121212121212121212121212121231212123121212121212121212121212121212123121212312121212121212121212121212121212312121231212121212121212121212121212121231212123121212121212121212121212121212123121212312121212121212121212121212121212312121231212121212121212121212121212121231212123121212121212121212121212121212123121212312121212121212121212121212121212312121231212121212121212121212121212121231212123121212121212121212121212121212123121212312121212121212121212121212121212312121231212121212121212121212121212121231212123121212121212121212121212121212123121212312121212121212121212121212121212312121231212121212121212121212121212121231212123121212121212121212121212121212123121212312121212121212121212121212121212121231212123121212121212121212121212121212123121212312121212121212121212121212121212312121231212121212121212121212121212121231212123121212121212121212121212121212123121212312121212121212121212121212121212312121231212121212121212121212121212121231212123121212121212121212121212121212123121212312121212121212121212121212121212312121231212121212121212121212121212121231212123121212121212121212121212121212123121212312121212121212121212121212121212312121231212121212121212121212121212121231212123121212121212121212121212121212123121212312121212121212121212121212121212312121231212121212121212121212121212121231212123121212121212121212121212121212123121212312121212121212121212121212121212312121231212121212121212121212121212121231212123121212121212121212121212121212123121212312121212121212121212121212121212312121231212121212121212121212121212121231212123121212121212121212121212121212123121212312121212121212121212121212121212312121231212121212121212121212121212121231212123121212121212121212121212121212123121212312121212121212121212121212121212312121231212121212121212121212121212121231212123121212121212121212121212121212123121212312121212121212121212121212121212312122121212121212121231212123121212121212121212121212121212123121212312121212121212121212121212121212312121231212121212121212121212121212121231212123121212121212121212121212121212121212312121231212121212121212121212121212121231212123121212121212121212121212121212123121212312121212121212121212121212121212312121231212121212121212121212121212121231212123121212121212121212121212121212123121212312121212121212121212121212121212312121231212121212121212121212121212121231212123121212121212121212121212121212123121212123121212312121212121212121212121212121212312121231212121212121212121212121212121231212123121212121212121212121212121212123121212312121212121212121212121212121212312121231212121212121212121212121212121231212123121212121212121212121212121212123121212312121212121212121212121212121212312121231212121212121212121212121212121231212123121212121212121212121212121212123121212312121212121212121212121212121212312122121212121212121231212123121212121212121212121212121212123121212312121212121212121212121212121212312121231212121212121212121212121212121231212123121212121212121212121212121212121212312121231212121212121212121212121212121231212123121212121212121212121212121212123121212312121212121212121212121212121212312121231212121212121212121212121212121231212123121212121212121212121212121212123121212312121212121212121212121212121212312121231212121212121212121212121212121231212123121212121212121212121212121212123121212312121212121212121212121212121212312121231212121212121212121212121212121231212123121212121212121212121212121212123121212312121212121212121212121212121212312121231212121212121212121212121212121231212123121212121212121212121212121212123121212312121212121212121212121212121212312121231212121212121212121212121212121231212123121212121212121212121212121212123121212312121212121212112312121212121212121212121212121212312121231212121212121212121212121212121231212123121212121212121212121212121212123121212312121212121212121212121212121212312121231212121212121212121212121212121231212123121212121212121212121212121212123121212312121212121212121212121212121212312121231212121212121212121212121212121231212123121212121212121212121212121212123121212312121212121212121212121212121212312121231212121212121212121212121212121231212123121212121212121212121212121212123121212312121212121212121212121212121212312121231212121212121212121212121212121231212123121212121212121212121212121212123121212312121212121212121212121212121212312121231212121212121212121212121212121231212123121212121212121212121212121212123121212312121212121212121212121212121212312121231212121212121212121212121212121231212123121212121212121212121212121212123121212312121212121212121212121212121212312121231212121212121212121212121212121231212123121212121212121212121212121212123121212312121212121212121212121212121212312121231212121212121212121212121212121231212123121212121212121212121212121212123121212312121212121212121212121212121212312121231212121212121212121212121212121231212123121212121212121212121212121212123121212312121212121212121212121212121212312121231212121212121212121212121212121231212123121212121212121212121211212121212121231212123121212121212121212121212121212123121212312121212121212121212121212121212312121231212121212121212121212121212121231212123121212121212121212121212121212123121212312121212121212121212121212121212312121231212121212121212121212123121212312121212121212121212121212121212312121231212121212121212121212121212121231212123121212121212121212121212121212123121212312121212121212121212121212121212312121231212121212121212121212121212121231212123121212121212121212121212121212123121212312121212121212121212121212121212312121231212121212121212121121212121212121212121231212123121212121212121212121212121212123121212312121212121212121212121212121212312121231212121212121212121212121212121231212123121212121212121212121212121212123121212312121212121212121212121212121212312121231212121212121212121212121212121231212123121212121212121212121212121212123121212312121212121212121212121212121212312121231212121212121212121212121212121231212123121212121212121212121212121212123121212312121212121212121212121212121212312121231212121212121212121212121212121231212123121212121212121212121212121212123121212312121212121212121212121212121212312121231212121212121212121212121212121231212123121212121212121212121212121212123121212312121212121212121212121212121212312121231212121212121212121212121212121231212123121212121212121212121212121212123121212312121212121212121212121212121212312121231212121212121212121212121212121231212123121212121212121212121212121212123121212312121212121212121231212123121212121212121212121212121212123121212312121212121212121212121212121212312121231212121212121212121212121212121231212123121212121212121212121212121212123121212312121212121212121212121212121212312121231212121212121212121212123121212312121212121212121212121212121212312121231212121212121212121212121212121231212123121212121212121212121212121212123121212312121212121212121212121212121212312121231212121212121212121212121212121231212123121212121212121212121212121212123121212312121212121212121212121212121212312121231212121212121212121121212121212121212121231212123121212121212121212121212121212123121212312121212121212121212121212121212312121231212121212121212121212121212121231212123121212121212121212121212121212123121212312121212121212121212121212121212312121231212121212121212121212121212121231212123121212121212121212121212121212123121212312121212121212121212121212121212312121231212121212121212121212121212121231212123121212121212121212121212121212123121212312121212121212121212121212121212312121231212121212121212121212121212121231212123121212121212121212121212121212123121212312121212121212121212121212121212312121231212121212121212121212121212121231212123121212121212121212121212121212123121212312121212121212121212121212121212312121231212121212121212121212121212121231212123121212121212121212121212121212123121212312121212121212121212121212121212312121231212121212121212121212121212121231212123121212121212121212121212121212123121212312122121212123121212312121212121212121212121212121212312121231212121212121212121212121212121231212123121212121212121212121212121212123121212312121212121212121212121212121212312121231212121212121212121212121212121231212123121212121212121212121212121212123121212312121212121212121212121212121212312121231212121212121212121212121212121231212123121212121212121212121212121212123121212312121212121212121212121212121212312121231212121212121212121212121212121231212123121212121212121212121212121212123121212312121212121212121212121212121212312121231212121212121212121212121212121231212123121212121212121212121212312121231212121212121212121212121212121231212123121212121212121212121212121212123121212312121212121212121212121212121212312121231212121212121212121212121212121231212123121212121212121212121212121212123121212312121212121212121212121212121212312121231212121212121212121212121212121231212123121212121212121212112121212121212121212123121212312121212121212121212121212121212312121231212121212121212121212121212121231212123121212121212121212121212121212123121212312121212121212121212121212121212312121231212121212121212121212121212121231212123121212121212121212121212121212123121212312121212121212121212121212121212312121231212121212121212121212121212121231212123121212121212121212121212121212123121212312121212121212121212121212121212312121231212121212121212121212121212121231212123121212121212121212121212121212123121212312121212121212121212121212121212312121231212121212121212121212121212121231212123121212121212121212121212121212123121212312121212121212121212121212121212312121231212121212121212121212121212121231212123121212121212121212121212121212123121212312121212121212121212121212121212312121231212121212121212121212121212121231212123121212121212121212121212121212123121212312121212121212121212121212121212312121231212121212121212121212121212121231212123121212121212121212121212121212123121212312121212121212121212121212121212312121231212121212121212121212121212121231212123121212121212121212121212121212123121212312121212121212121212121212121212312121231212121212121212121212121212121231212123121212121212121212121212121212123121212312121212121212121212121212121212312121231212121212121212121212121212121231212123121212121212121212121212121212123121212312121212121212121212121212121212312121231212121212121212121212121212121231212123121212121212121212121212121212123121212312121212121212121212121231212123121212121212121212121212121212123121212312121212121212121212121212121212312121231212121212121212121212121212121231212123121212121212121212121212121212123121212312121212121212121212121212121212312121231212121212121212121212121212121231212123121212121212121212121212121212123121212312121212121212121212121212121212312121231212121212121212121212121212121231212123121212121212121212121212121212123121212312121212121212121212121212121212312121231212121212121212121212121212121231212123121212121212121212121212121212123121212312121212121212121212121212121212312121231212121212121212121212121212121231212123121212121212121212121212121212123121212312121212121212121212121212121212312121231212121212121212121212121212121231212123121212121212121212121212121212123121212312121212121212121212121212121212312121231212121212121212121212121212121231212123121212121212121212121212121212123121212312121212121212121212121212121212312121231212121212121212121212121212121231212123121212121212121212121212121212123121212312121212121212121212121212121212312121231212121212121212121212121212121231212123121212121212121212121212121212123121212312121212121212121212121212121212312121231212121212121212121212121212121231212123121212121212121212121212121212123121212312121212121212121212121212121212312121231212121212121212121212121212121231212123121212121212121212121212121212123121212312121212121212121212121212121212312121231212121212121212121212121212121231212123121212121212121212121212121212123121212312121212121212121212121212121212312121231212121212121212121212121212121231212123121212121212121212121212121212123121212312121212121212121212121212121212312121231212121212121212121212121212121212123121212312121212121212121212121212121212312121231212121212121212121212121212121231212123121212121212121212121212121212123121212312121212121212121212121212121212312121231212121212121212121212121212121231212123121212121212121212121212121212123121212312121212121212121212121212121212312121231212121212121212121212121212121231212123121212121212121212121212121212123121212312121212121212121212121212121212312121231212121212121212121212121212121231212123121212121212121212121212121212123121212312121212121212121212121212121212312121231212121212121212121212121212121231212123121212121212121212121212121212123121212312121212121212121212121212121212312121231212121212121212121212121212121231212123121212121212121212121212121212123121212312121212121212121212121212121212312121231212121212121212121212121212121231212123121212121212121212121212121212123121212312121212121212121212121212121212312121231212121212121212121212121212121231212123121212121212121212121212121212123121212312121212121212121212121212121212312121231212121212121212121212121212121231212123121212121212121212121212121212123121212312121212121212121212121212121212312121231212121212121212121212121212121231212123121212121212121212121212121212123121212312121212121212121212121212121212312121231212121212121212121212121212121231212123121212121212121212121212121212123121212312121212121212121212121212121212312121231212121212121212121212121212121231212123121212121212121212121212121212123121212312121212121212121212121212121212312121231212121212121212121212121212121231212123121212121212121212121212121212123121212312121212121212121212121212121212312121231212121212121212121212121212121212123121212312121212121212121212121212121212312121231212121212121212121212121212121231212123121212121212121212121212121212123121212312121212121212121212121212121212312121231212121212121212121212121212121231212123121212121212121212121212121212123121212312121212121212121212121212121212312121231212121212121212121212121212121231212123121212121212121212121212121212123121212312121212121212121212121212121212312121231212121212121212121212121212121231212123121212121212121212121212121212123121212312121212121212121212121212121212312121231212121212121212121212121212121231212123121212121212121212121212121212123121212312121212121212121212121212121212312121231212121212121212121212121212121231212123121212121212121212121212121212123121212312121212121212121212121212121212312121231212121212121212121212121212121231212123121212121212121212121212121212123121212312121212121212121212121212121212312121231212121212121212121212121212121231212123121212121212121212121212121212123121212312121212121212121212121212121212312121231212121212121212121212121212121231212123121212121212121212121212121212123121212312121212121212121212121212121212312121231212121212121212121212121212121231212212121212121212123121212312121212121212121212121212121212312121231212121212121212121212121212121231212123121212121212121212121212121212123121212312121212121212121212121212121212121231212123121212121212121212121212121212123121212312121212121212121212121212121212312121231212121212121212121212121212121231212123121212121212121212121212121212123121212312121212121212121212121212121212312121231212121212121212121212121212121231212123121212121212121212121212121212123121212312121212121212121212121212121212312121212312121231212121212121212121212121212121231212123121212121212121212121212121212123121212312121212121212121212121212121212312121231212121212121212121212121212121231212123121212121212121212121212121212123121212312121212121212121212121212121212312121231212121212121212121212121212121231212123121212121212121212121212121212123121212312121212121212121212121212121212312121231212121212121212121212121212121231212212121212121212123121212312121212121212121212121212121212312121231212121212121212121212121212121231212123121212121212121212121212121212123121212312121212121212121212121212121212121231212123121212121212121212121212121212123121212312121212121212121212121212121212312121231212121212121212121212121212121231212123121212121212121212121212121212123121212312121212121212121212121212121212312121231212121212121212121212121212121231212123121212121212121212121212121212123121212312121212121212121212121212121212312121231212121212121212121212121212121231212123121212121212121212121212121212123121212312121212121212121212121212121212312121231212121212121212121212121212121231212123121212121212121212121212121212123121212312121212121212121212121212121212312121231212121212121212121212121212121231212123121212121212121212121212121212123121212312121212121212121212121212121212312121231212121212121212121212121212121231212123121212121212121212121212121212123121212312121212121212121212121212121212312121231212121212121212121212121212121231212123121212121212121212121212121212123121212312121212121212121212121212121212312121231212121212121212121212121212121231212123121212121212121212121212121212123121212312121212121212121212121212121212312121231212121212121212121212121212121231212123121212121212121212121212121212123121212312121212121212121212121212121212312121231212121212121212121212121212121231212123121212121212121212121212121212123121212312121212121212121212121212121212312121231212121212121212121212121212121231212212121212121212123121212312121212121212121212121212121212312121231212121212121212121212121212121231212123121212121212121212121212121212123121212312121212121212121212121212121212312121231212121212121212121212121212121231212123121212121212121212121212121212123121212312121212121212121212121212121212312121231212121212121212121212121212121231212123121212121212121212121212121212123121212312121212121212121212121212121212312121231212121212121212121212121212121231212123121212121212121212121212121212123121212312121212121212121212121212121212312121231212121212121212121212121212121231212123121212121212121212121212121212123121212312121212121212121212121212121212312121231212121212121212121212121212121231212123121212121212121212121212121212123121212312121212121212121212121212121212312121231212121212121212121212122121212121212121231212123121212121212121212121212121212123121212312121212121212121212121212121212312121231212121212121212121212121212121231212123121212121212121212121212121212123121212312121212121212121212121212121212312121231212121212121212121212121212121231212123121212121212121212121212121212123121212312121212121212121212121212121212312121231212121212121212121212121212121231212123121212121212121212121212121212123121212312121212121212121212121212121212312121231212121212121212121212121212121231212123121212121212121212121212121212123121212312121212121212121212121212121212312121231212121212121212121212121212121231212212121212121212123121212312121212121212121212121212121212312121231212121212121212121212121212121231212123121212121212121212121212121212123121212312121212121212121212121212121212312121231212121212121212121212121212121231212123121212121212121212121212121212123121212312121212121212121212121212121212312121231212121212121212121212121212121231212123121212121212121212121212121212123121212312121212121212121212121212121212312121231212121212121212121212121212121231212123121212121212121212121212121212123121212312121212121212121212121212121212312121231212121212121212121212121212121231212123121212121212121212121212121212123121212312121212121212121212121212121212312121231212121212121212121212121212121231212123121212121212121212121212121212123121212312121212121212121212121212121212312121231212121212121212121212121212121231212123121212121212121212121212121212123121212312121212121212121212121212121212312121231212121212121212121212121212121231212ABC';
-TYPE &XYZ.LENGTH
-SET &XYZ=&XYZ || 'ABC';
-TYPE XYZ=&XYZ
-TYPE &XYZ.LENGTH
 
 
SET WEBVIEWER 	= ON
SET WEBVIEWALLPG = OFF
SET WEBVIEWCLOSE = OFF
SET WEBVIEWTARG	= OFF
SET WEBVIEWHELP = OFF
APP PATH IBISAMP
DEFINE FILE CAR
XYZ/I11 = &XYZ.LENGTH;
XYZ_1/A30600 = '&XYZ.EVAL';
END 
TABLE FILE CAR
PRINT
CAR
COUNTRY
DEALER_COST
RETAIL_COST
XYZ
XYZ_1
ON TABLE HOLD FORMAT ALPHA
END
-RUN
TABLE FILE HOLD
PRINT
*
HEADING
"" 
END
-RUN



Thanks,
Ram

This message has been edited. Last edited by: Ram Prasad E,
 
Posts: 542 | Location: Dearborn, MI | Registered: June 03, 2009Report This Post
Virtuoso
posted Hide Post
The 4095 limit is a storage limit for fixed format files, 3968 is for FOCUS file storage and 4096 for XFOCUS field storage.

There is a 32k (roughly) limit that is for SQL field actual/usage, so WF is built to handle this length of Alpha fields.


Alan.
WF 7.705/8.007
 
Posts: 1451 | Location: Portugal | Registered: February 07, 2007Report This Post
Master
posted Hide Post
 
Posts: 542 | Location: Dearborn, MI | Registered: June 03, 2009Report This Post
Master
posted Hide Post
I have opened a case with IBI for this.
-Ram
 
Posts: 542 | Location: Dearborn, MI | Registered: June 03, 2009Report This Post
Gold member
posted Hide Post
quote:
low sample code uses around 30,



Hi Ram,

Just reopening this.. What can be the maximum length that Alphanumeric can hold. i.e. A&listbox6.LENGTH

-SET &Phone_no = STRREP(&listbox6.LENGTH,&listbox6,02,'OR',1,',',&listbox6.LENGTH,'A&listbox6.LENGTH');

Thanks,
Ramya


WebFocus 7702
HTML
 
Posts: 73 | Registered: January 02, 2012Report This Post
Gold member
posted Hide Post
Hi Ram

The function is not happening if the value exceeds A4096

Thanks,
Ramya


WebFocus 7702
HTML
 
Posts: 73 | Registered: January 02, 2012Report This Post
  Powered by Social Strata  

Read-Only Read-Only Topic

Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     [CASE OPENED] Maximum Limit of Alphanumeric Define/Compute Fields

Copyright © 1996-2020 Information Builders