I am using WHERE field in FILE HOLD syntax and this syntax have a limitation of 16,000 bytes. If the value goes more than that it throws the error

"computational element is too large"

Is there a way to solve this issue?

I split the list you get with the hold file into two or more files.
Then I use those files in a DECODE (in DEFINE)
Then I can use the DEFINED field in the WHERE statement.

there are numerous posts and code examples of techniques for this on the forum if you use the search functionality

As Darin say multiple.

e.g. JOIN or MATCH don't have this limitation.

Try changing it to IF fieldname EQ (filename).

Darin, Before posting any discussion I use the search functionality first and if I couldn't find anything that I look for then only I will open a discussion. I know how valuable everybody's time is.

I will try the IF and let you know.

Thanks for the suggestions

PBrightwell, your suggestion worked great.

Thanks

Using IF increases the limitation to 32K. If you get larger than that, you will still have the same problem. If you joined to that file with an inner join, you would never have the problem regardless of the size of the file.