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.



Read-Only Read-Only Topic
Go
Search
Notify
Tools
in file limit
 Login/Join
 
prash.cp
Member
posted
Hi,

What is the limit of records in a "IN file " command.

EG:
when i save a file with employee id in it and use the same further down in a table with in file command in where statment, it is throwing a error
" computational field is too large"


any idea?

thanks


WF 7.1.4
Windows
Excel, Html, PDF



 
Posts: 5 | Registered: February 02, 2008Report This Post
Tony A
Expert
posted Hide Post
Mentioned many times before in posts -

32000 chars

Use join or match instead of IF fieldname EQ (filename) to overcome restriction.

T


In FOCUS
since 1986		WebFOCUS Server 8.2.01M, thru 8.2.07 on Windows Svr 2008 R2  
WebFOCUS App Studio 8.2.06 standalone on Windows 10 
 
Posts: 5694 | Location: United Kingdom | Registered: April 08, 2004Report This Post
GinnyJakes
Expert
posted Hide Post
With WHERE, the limit is 16,000 characters, and 32K with IF.


Ginny
---------------------------------
Prod: WF 7.7.01 Dev: WF 7.6.9-11
Admin, MRE,self-service; adapters: Teradata, DB2, Oracle, SQL Server, Essbase, ESRI, FlexEnable, Google
 
Posts: 2723 | Location: Ann Arbor, MI | Registered: April 05, 2006Report This Post
FrankDutch
Virtuoso
posted Hide Post
There are some tricks.

What I do is split the selection into more than one hold file.

Than I do a define like

DEFINE FILE XXX
SEL1/I1=DECODE CLIENTCODE(HOLD1 ELSE 1);
SEL2/I1=DECODE CLIENTCODE(HOLD2 ELSE 1);
SEL3/I1=DECODE CLIENTCODE(HOLD3 ELSE 1);
SEL4/I1=DECODE CLIENTCODE(HOLD4 ELSE 1);
END
TABLE FILE XXX

....
WHERE SEL1 EQ 0 OR SEL2 EQ 0 OR ....
END


A join would be better, but sometimes you need some other solutions.




Frank
prod: WF 7.6.10 platform Windows,
databases: msSQL2000, msSQL2005, RMS, Oracle, Sybase,IE7
test: WF 7.6.10 on the same platform and databases,IE7

 
Posts: 2387 | Location: Amsterdam, the Netherlands | Registered: December 03, 2006Report This Post
GinnyJakes
Expert
posted Hide Post
The IN FILE technique is a great replacement to avoid doing heterogeneous joins to a relational target. Select the keys from the 'parent' into a save file. Multiply the length of the field by the number of rows (use DST. to make sure you only have unique values) to determine if you are within the size limit. Make sure that the WHERE is done in the TABLE part, not in a DEFINE, so that the proper SQL is generated.

I successfully used and taught this technique to a new developer who had a fixed file he needed to join to DB2 and Teradata.


Ginny
---------------------------------
Prod: WF 7.7.01 Dev: WF 7.6.9-11
Admin, MRE,self-service; adapters: Teradata, DB2, Oracle, SQL Server, Essbase, ESRI, FlexEnable, Google
 
Posts: 2723 | Location: Ann Arbor, MI | Registered: April 05, 2006Report This Post
  Powered by Social Strata  

Read-Only Read-Only Topic


Copyright © 1996-2020 Information Builders