PROGRAM PREPARATION AND EXECUTION

•                                     Pre compile
•                                     Compile          
•                                     Link-edit
•                                     Bind/Rebind
•                                     Execution

*  Languages that can be used with SQL :

            -  Assembler

            -  BASIC

            -  COBOL

            -  FORTRAN

            -  PL/1

            -  C

                  DB2 DATA TYPES AND EQUIVALENT COBOL FIELD DEFINITIONS

            DATA TYPES KIND OF DATA         COBOL DEFINITION

         SMALLINT                    Half word integer         PIC S  9(4)  COMP

         INTEGER                       Full word integer          PIC S  9(9)  COMP

         DECIMAL(p,s)               Packed decimal                        PIC S  9(7)V99 COMP-3

         FLOAT(n)                       Floating point data       (n < 22) COMP-1

                                                                           (22<= 53) COMP-2

         CHAR                             Fixed-length character PIC  X(254)

         VARCHAR                     Variable-length character   L  PIC  S9(4) COMP

                                                                                        D PIC  X(254)

GRAPHIC                       Fixed-length                 PIC  G(n) DISPLAY

                                                                                    n=127

         VARCHAR                     Variable-length                        L  PIC  S  9(4)  COMP

                                                                           T  PIC G(127) DISPLAY

         DATE                             Date                             PIC  X(10)

         TIME                              Time                            PIC  X(8)

         TIMESTAMP                  Date and Time             PIC  X(26)