Skip to main content

Copy Data from User space to CLOB data type in AS400

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/

Comments

Post a Comment

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.  
Post a Comment
Read more

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 .
Post a Comment
Read more