Posted: Tue Feb 13, 2007 4:02 pm Post subject: FMC00125E Incorrect filter specification
Newbie
Joined: 13 Feb 2007 Posts: 2
I have more than 1 million records in fmcdb with the states as force finished. So would like to fetch certain number(may be 100) but the filter is giving FMC00125E Incorrect filter specification.
Here is the code
STATE IN (FORCE_FINISHED) fetch first 100 rows only
Is there a way to give threshold limit to the filter?
You cannot post new topics in this forum You cannot reply to topics in this forum You cannot edit your posts in this forum You cannot delete your posts in this forum You cannot vote in polls in this forum