HomeAbout SpanProducts DownloadsContact Us


View Manuals Online


SPICE/SQL Release 3.1

The explosion in the number of on-line application systems has not removed the need for batch processing. Every industry can quote processes that are most efficiently performed by programs that do not require direct supervision from a terminal. It is a growing trend that commercial and competitive considerations dictate that such processing be performed concurrently with the on-line systems. DB2 applications can be run in such a fashion only if they are restartable.

SPICE SQL is a software package that complements IBM's DB2 systems facilities for batch application programs. It provides a complete environment for the development, maintenance and operation of restartable DB2 application programs

Users of SPICE/SQL benefit from the following:

SPICE SQL provides easy to use facilities for controlling SPICE SQL programs. It provides fully automatic restart of failing application programs, simply by resubmission of the job; no JCL changes are required. The same operational technique can be applied to all application jobs using SPICE SQL.

The SPICE SQL programming facilities are simple to learn and use. Minimal training of programming staff is required. SPICE SQL includes powerful facilities for controlling application program database commit processing. These facilities minimise the programmer's responsibility for commit point frequency. This results in less complex programs. Senior development staff are released from the task of developing and maintaining in-house facilities and procedures. SPICE SQL results in reduced development and maintenance cost.

SPICE SQL meets the highest standards of reliability and integrity. The nature and timing of external failures will not compromise the ability of SPICE SQL to restart the application successfully.

SPICE SQL was developed and is marketed by Span Software Consultants Limited. Span Software has been providing systems software for IBM mainframes since 1976. Furthermore, Span Software has over 25 years of experience in delivering and maintaining software to support restartable applications.


SPICE and SPICE SQL are trademarks of Span Software Consultants Limited. IBM and DB2 are trademarks of the International Business Machines Corporation.