AS/400 backup, AS/400 Career, AS/400 DB2, AS/400 errors, AS/400 FTP, AS/400 performance, AS/400 printing, AS/400 Query, AS/400 security, AS/400 upgrading, CL, CLLE, CLP, COBOL, CPYTOIMPF, DB2/400, DDS, DSPF, Ecommerce applications, i5, IFS, IS-B, iSeries, iSeries applications, iSeries database, iSeries development, iSeries Navigator, iSeries networking, iSeries programming commands, Logical partitions, OS/400, PF/LF, Printing/Output, PTFs, RPG, RPG ILE, RPG IV, RPG/400, RPGILE, RPGLE, SAVF, SNDDST, Spool files, Subfile, UDB for iSeries/i5, UDB for mainframe, V5R2, V5R3, V5R4 >>VIEW ALL TAGS
SETLL vs. LOOKUP
Fact based opinions requested. Is it faster to perform a SETLL on a file to do an existence test or read the file (note: it has a very small number of records) into a program array during *INZSR and then do a LOOKUP to do the existence test?
View Answer
| Dec 13 2007 4:51 PM GMT
| asked by
DJA
iSeries applications, LOOKUP, *INZSR
Related Member Blogs
System i Blogger
Covering Enterprise System i (AS/400 & iSeries) administration with the latest System i offerings, news, tips & tricks and more.
Views from the P.I.T.
People in IT: Bringing the human element back into the IT profession, by Suzanne Wheeler.
Related content from Search400.com
→ Expert Advice: Copying a physical file back to a spool file
→ Programmer Tips: System i document management tips
→ iSeries Security: New password-control security features for i5/OS V6R1
