Using the Packeting Container Details part with a database is very similar to how you use the container details part with a database. There are only a couple of additional settings you need to make in your query part(s). First, in the settings for your query part, ensure that the Enable packeting check box is checked so that packeting is enabled. Secondly, provide a numeric value in the Blocked fetch size for the number of rows that you want to fetch in a block.

A simple example you could try is as follows. Using the SAMPLE database that is shipped with DB2, create a StaffQuery similar to the one shown in the Adding database support chapter in the Visual Programming User Guide. Then, open the StaffQuery settings and check the Enable packeting check box, and set the Blocked fetch size to 10. Now you can create a view with the Packeting Container Details part to display the query. When you test the view, you will fetch 10 rows at a time. The status area will display at the bottom of the view indicating if more data is available. To fetch more data, click on the push button on the far right of the status area. When you have retrieved all of the data the status message will indicate that no more data is available.