Thanks to all who have responded.

I think I worded my original questions badly because I didn't know enough to formulate a good question. The responses have still be useful, though.

I'd like to reformulate my questions:

1. What does data-centric programming really mean in an iSeries COBOL shop using DB2 for i?

2. Is data-centric development something that makes for better web and mobile apps? If yes, how?


Kelly Cookson
IT Project Leader
Dot Foods, Inc.
1.217.773.4486 ext. 12676

-----Original Message-----
From: WEB400 [mailto:web400-bounces@xxxxxxxxxxxx] On Behalf Of Nathan Andelin
Sent: Friday, October 02, 2015 7:29 AM
To: Web Enabling the IBM i (AS/400 and iSeries)
Subject: Re: [WEB400] Elevator speech on DB2 development and web enablement?

I have a very vague idea that moving business logic and development
from COBOL into DB2 as much as possible is a good thing.

The idea is to move data validation and business rules "out of applications" and "into the DB", meaning that the logic is run in (or
behind) triggers. So "rules" and "business logic" cannot be bypassed. That ensures DB integrity, and makes the logic more readable and maintainable.

COBOL would actually be a good language for such because it compiles into native programs and procedures. Some prefer using SQL triggers, which are transformed into C, which also compiles into programs. Language environments such as Node.js, PHP, Python, Ruby, MS .Net, and Java are ill-suited for such.

Applications then just issue DB I/O statements and handle error messages generated in or behind triggers.
This is the Web Enabling the IBM i (AS/400 and iSeries) (WEB400) mailing list To post a message email: WEB400@xxxxxxxxxxxx To subscribe, unsubscribe, or change list options,
or email: WEB400-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives at

This thread ...


Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2020 by and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].