DB2 Interview Questions and Answers Packages are the alternative to creating procedures and functions. They are stand alone schema objects. The advantages of packages are 1. Modularity All the procedures and functions belongs to a particular module of an application can be encapsulated in a package. Easy to design the application The package body and package specification can be coded and compiled separately without its body. Stored procedures are compiled and executed by qualifying the package names. Hiding Information The programming elements declared in the specification of the package is public. The package body elements are declared as private, i. Hence they are secured. Added Functionality Public variables and cursors are persisted for a session, which enables the sharing of data by all programs of the calling environment. Better Performance Packaged sub programs are invoked for the first time by loading the entire package into the memory. Disk IO operations are not needed for calling related sub programs in the package later. Overloading Multiple programs can be placed in the same package with different number of parameters or types or parameters. Die PCFAQ enthlt Antworten zu vielen Fragen rund um den PC, sowie Erklrungen der hufigsten Computerbegriffe und ein Wrterbuch. Q. What is meant by Debugging To debug is the process of running a stepbystep trace of a softwareprogram sourcecode in slowmotion, to remove program bugs. HTEx4g8/VQ09bV4eRaI/AAAAAAAABDo/RjpQa4EOy_w/s1600/dclgen%2BScreen.png' alt='Cobol Db2 Cics Program Compilation Definition' title='Cobol Db2 Cics Program Compilation Definition' />The coding workspace comprises columns 271, and is completely freeform. Column 1 is reserved for printer control. Programs start and end as shown above YOURNAME is. Aventail Client 64 Bit on this page.