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

Sample Java Program

This file will be downloaded as ezjava.java
Rename the file to EzJava.java
   Source the client's profile
   source ~db2leduc/sqllib/db2cshrc
   
   Compile the program
      javac EzJava.java
   
   Execute the program

      java EzJava sample

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