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 Sailors

create table sailors (

 sid   smallint  not null,
  sname  varchar(20),
  rating smallint,
  age smallint,
      primary key (sid)

);

insert into sailors ( 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);

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

</code>

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)
• 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