All sample programs are taken for either IBM's website or from past 3421 courses. Embedded SQL is another type of application that will need packages bound against a database so that it can execute its SQL. Embedded applications can be written in a number of host languages. C\C++, JAVA(SQLJ), COBOL and FORTRAN

Connect to the database you are using for your course

Table sailor

create table sailor (
   sid   smallint  not null,
    sname  varchar(20),
    rating smallint,
    age smallint,
        primary key (sid)
);


insert into sailor ( sid, sname,rating,age) values
(22,'Dustin',7,45.0),
(29,'BRUTUS',1,33.0),
(31,'Lubber', 8,55.5),
(32,'Andy',8, 25.5),
(58,'Rusty',10,35.0),
(64,'Horatio',7,35.0),
(71,'Zorba',10,16.0),
(74,'Horatio',9,40.0),
(85,'Art',3,25.5),
(95,'Bob',3,63.5);

Once created successfully

db2 "select * from sailor"

SID    SNAME                RATING    AGE    
------ -------------------- ------ --------
    22 Dustin                    7     45.0
    29 BRUTUS                    1     33.0
    31 Lubber                    8     55.5
    32 Andy                      8     25.5
    58 Rusty                    10     35.0
    64 Horatio                   7     35.0
    71 Zorba                    10     16.0
    74 Horatio                   9     40.0
    85 Art                       3     25.5
    95 Bob                       3     63.5

  10 record(s) selected.

— Program 1 sample Sample Connectivity type 4 driver
Steps to Compile: source db2cshrc

                javac  ezjava.java
                Execute : java ezjava <database name > <username> <user password>
                                       sample

Sample Java Sailor Program

This file will be downloaded as ezsailor.java Rename the file to EzSailor.java

   Source the client's profile
   source ~db2leduc/sqllib/db2cshrc
   
   Compile the program
      javac EzSailor.java
   
   Execute the program

      java EzSailor sample where sample is  the database I used to store my tables

Sample Perl Program

Sample Sqlj Program

For sqlj programs, you would need

• a sqlj precompiler which translates file.sqlj into java pgms.
• a java compiler
• Sqlj runtime classes (available *.zip)
  1. sqlj.runtime
  2. sqlj.runtime.ref
  3. sqlj.runtime.profile
  4. sqlj.runtime.profile.ref
• A jdbc driver implementing package java.sql

How to execute the sqlj

This program uses the universal type 2 driver

Steps to follow

• source the client's cshrc file
  1. ~db2leduc/sqllib/db2cshrc
• Pre-compile the program (Running it through a translator)
  1. This will strip the java code from the sql code within the sqlj program and create sub files. (Program name sqlj) eg sqlj <programname>

• Use db2sqljcustomize to process the SQLJ profile (.ser).
  1. The SQLJ customization process binds four packages to the DB2 server. - To run execute “ db2sqljcustomize -url jdbc:db2:c3421m sailor_SJProfile0.ser”

• Run your java program
  1. java sailor 71