Skip to main content

How can a Logical file be bigger than its physical file!!!???

Found this interesting article. The solution is even better! Saving few gigs of space and lots of money saved on new Hard disks. See the article here.

https://powerwire.eu/logical-file-more-than-the-sum-of-its-parts

Comments

Popular posts from this blog

AS400 resources on the web

The AS/400 system thru iSeries and System I, has come a long way. With regular contributions from the growing community of AS/400 RPG, COBOL, ILE programmers, there maybe a solution to most of your issues. www.search400.com ,  search400.techtarget.com A good knowledge base for AS400 related information, Question and Answers, tutorials, news. I use it regularly. www.midrange.com In their own words " Your best source for IBM i / System i / iSeries / AS/400 Information on the Internet ". Please make your own judgement. www.code400.com This is a site dedicated to AS/400 programmers! Have fun coding! www.itjungle.com This site now has AS/400 programmers posting information.  

AS400 Database Trigger Programs ADDPFTRG

iSeries/ AS400/ System i programming allows a very useful feature called Triggers. It allows you to execute programs based on data changes in a database file. Use the command ADDPFTRG to add triggers to any database file. Recently, I used trigger to create a history/ audit trail for a Client Locations file which does not have any history. Trigger was preferred over direct program changes because One small program does the job well. Least impact and least testing involved! It saves me time and effort having to add code in a dozen places. It saves on testing time because of large number of changes. The performance overhead is negligible. Follow this link to a useful article on Trigger programming http://www.tylogix.com/Articles/TriggerTechniquesRevisited.htm .