Home > Ask the AS/400 Experts > iSeries Application Development Questions & Answers > What's the difference between the three types of subfiles as in the DDS?
Ask The iSeries 400 Expert: Questions & Answers
EMAIL THIS

What's the difference between the three types of subfiles as in the DDS?

John Blenkinsop EXPERT RESPONSE FROM: John Blenkinsop

Pose a Question
Other iSeries 400 Categories
Meet all iSeries 400 Experts
Become an Expert for this site


Digg This!    StumbleUpon Toolbar StumbleUpon    Bookmark with Delicious Del.icio.us   


>
QUESTION POSED ON: 16 December 2004
What's the difference between the three types of subfiles in the DDS, as well as the difference in programming the three. Also, how is one more advantageous over the other with respect to the OS/400, as well as the program?

>
Rather than go into a long and involved explanation here, I will point you to a number of articles on the subject by Kevin Vandever:

Back to Basics: Introduction to Subfiles: This is a basic introduction to subfiles in RPG, with an example of a LOAD ALL subfile.

Back to Basics -- Self-Extending Subfiles: This converts the LOAD ALL subfile to a SELF EXTENDING subfile.

Become the Master of Your Subfile Domain: This completes the trilogy with the page-at-a-time or single-page subfile.

Additional articles which will be of interest to anyone doing subfiles are:

Back to Basics: Multiple Subfiles on One Screen: This covers multiple LOAD ALL subfiles on a screen.

Back to Basics: Side-by-Side Subfiles: This covers 'side-by-side' subfiles (!)

Back to Basics: Modifying a Subfile: This shows how to let the user add and update database data from a subfile.

Back to Basics: Data Entry Subfiles: This article covers fast data entry using a subfile.

Empower Users with Embedded SQL: This combines embedded SQL with subfiles for a powerful enquiry program All the articles have downloadable code for you to build on. My own advice is to stick with self-extending subfiles unless there is a good reason for going for one of the other techniques. Once you have your code perfect for the technique you will normally use, it is then just a matter of copying code and making slight alterations when you have a new subfile program to write.

==================================
MORE INFORMATION ON THIS TOPIC
==================================

The Best Web Links: tips, tutorials and more.

Visit the ITKnowledge Exchange and get answers to your developing questions fast.

Ask the Experts yourself: Our application development gurus are waiting to answer your programming questions.


Digg This!    StumbleUpon Toolbar StumbleUpon    Bookmark with Delicious Del.icio.us   



RELATED CONTENT
iSeries Application Development
Monitoring escape messages and using RCVMSG for diagnostic messages
Listing contents of multiple FTP directories on AS/400
Chain operation error after converting RPG3 to ILE RPG (RPGIV)
Space offset X'0015FF00' or X'0000000000000000' is outside current limit for object QIGC2424C
Searching fields for values
iSeries application display subfiles with other program windows
Searching part of a name or address in AS/400
Passing parameters in an ILE RPG module
What's happening to my subfile?
What happening to my subfile?

RPG iSeries programming
Enhancing RPG with external SQL stored procedures
Introduction to SQLRPGLE on IBM i: Making a report
Making the most of RPG data handling on IBM i
IBM i shop boosts online sales with RPG-based Web platform
Migrating from RPG to EGL on IBM i
Allow access to data from a stored procedure result set using COBOL or RPG
EGL Rich UI on IBM i: Do you Dojo?
Programming for the Web on the IBM i, what is possible
A taste of COMMON: ILE, IBM releases, Web applications and new products
Documenting nested program structures on the AS/400

RELATED GLOSSARY TERMS
Terms from Whatis.com − the technology online dictionary
Report Program Generator  (Search400.com)

RELATED RESOURCES
2020software.com, trial software downloads for accounting software, ERP software, CRM software and business software systems
Search Bitpipe.com for the latest white papers and business webcasts
Whatis.com, the online computer dictionary



Search and Browse the Expert Answer Center
Search and browse more than 25,000 question and answer pairs from more than 250 TechTarget industry experts.
Browse our Expert Advice



iSeries Networking - Printing, Remote Access, TCP/IP
HomeNewsTopicsITKnowledge ExchangeTipsBlogsAsk the ExpertsMultimediaWhite PapersProducts
About Us  |  Contact Us  |  For Advertisers  |  For Business Partners  |  Site Index  |  RSS
SEARCH 
TechTarget provides technology professionals with the information they need to perform their jobs - from developing strategy, to making cost-effective purchase decisions and managing their organizations' technology projects - with its network of technology-specific websites, events and online magazines.

TechTarget Corporate Web Site  |  Media Kits  |  Site Map




All Rights Reserved, Copyright 1999 - 2009, TechTarget | Read our Privacy Policy
  TechTarget - The IT Media ROI Experts