AS/400 Expert, Financial Services domain, I90, RPG

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

2020-12-02T13:10:00.000-08:00

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

Copying logical files to another library, avoiding errors

2019-03-25T07:58:00.002-07:00

Problem:

I was copying logical files (LF) to another library, when I faced this problem; the copied LF was still pointing to a physical file (PF) in another library. My search brought me to the following article. Its wonderful how you can still learn something new even after years of experience.

https://www.itjungle.com/2004/09/08/crtdupobj-and-logical-files/

I hope this article is useful to you and saves you lots of difficult problems in your work. We RPG programmers use lots of logical files to read and update data. Its difficult to trace errors where our programs are referring to data in libraries not even on the library list!.

Happy coding!!!

Copy Data from User space to CLOB data type in AS400

2016-11-01T07:31:00.000-07:00

This is a good article about how to use CLOB data type on System i (iSeries/ AS400). It contains some practical insights not available in User Manuals or the Internet! Hope you find it useful.

http://shanichara.wordpress.com/2014/10/03/copy-data-from-user-space-to-clob-data-type-in-as400/

About Himanshu Singh

2016-11-01T07:30:00.000-07:00

See a presentation here to know me better. http://www.slideshare.net/HimanshuSingh426/himanshu-singh-62930270/1

AS400 Database Trigger Programs ADDPFTRG

2014-09-18T02:34:00.003-07:00

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.

Apple Has Finally Stuck A Dagger Into SMS. I Love It.

2011-06-06T20:52:00.000-07:00

MG Siegler

Now that the WWDC keynote is over and I’ve had a little bit of time to reflect, I’ve been thinking about what excited me the most from today’s announcements. The list is long, no doubt. But I think I’m going to have to go with something that surprised me — while at the same time making me look smarter than perhaps I really am. (Again, just perhaps.) iMessages.

As one of the core new features highlighted today in iOS 5, iMessages has one purpose: to kill SMS.

AS400 resources on the web

2011-05-03T19:21:00.000-07:00

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.