September 12


Which %BIF for Chain, Read and other naughty native file IO

By NickLitten

September 12, 2017

bif, RPG, snippet

RPG ILE %BIF (Built In Function)

I always forget the differences between %EOF, %EQUAL and Not %Found when writing native file I/O in RPG ILE Programs.  Sometimes a file record is %found and sometimes its not. Even after all these years I still scratch my head about which one is which.

I know, I know – I should be using SQL right? SQL does things differently so these problems don’t bite us – but us crusty old time RPG chaps still have a secret soft-spot for good old fashioned chains don’t we?

I tend to copy blocks of code when writing source, it’s all too easy to copy a block of logic doing a subfile readc and change it to a chain without changing the %EOF to a %found. Which is exactly what I’ve been doing today. Of course, this ends up with chains looking for %EOF which compiles just fine. Grrrrr.

Since chain doesn’t necessarily set the file pointer to “end of file” sometimes I execute the NOT %eof( ) logic. Bloody annoying and not easy to spot a simply typo like this.

Must remember:

  • %found is for chains
  • %eof for reads
  • %equal for setll

So, here is a quick little cheat sheet of which built in function to use with which command:

  • Chain – %Found
  • Check – %Found
  • CheckR – %Found
  • Delete – %Found
  • LookUp – %Equal, %Found
  • Read – %Eof
  • ReadC – %Eof
  • ReadE – %Eof
  • ReadP – %Eof
  • ReadPE – %Eof
  • Scan – %Found
  • SetGT – %Found
  • SetLL – %Equal, %Found
  • Write (subfile only) – %Eof

One further note – SETLL checking for %found means it positioned before the key but %EQUAL means it found the exact key.

{"email":"Email address invalid","url":"Website address invalid","required":"Required field missing"}

Join the IBM i Community for FREE Presentations, Lessons, Hints and Tips