Differences

This shows you the differences between two versions of the page.

--- software:db2:using_cli [2013/03/01 15:05] – seela
+++ software:db2:using_cli [Unknown date] (current) – removed - external edit (Unknown date) 127.0.0.1
@@ Line 1: / Line 1: @@
-====== Using Embedded SQL ======
-**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====
-{{:software:db2:EzJava.java|Sample Java Program }}
-<code>
-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
-</code>
-====Sample Perl Program====
-{{:software:db2:sailor.pl|Sample Perl Program}}
-====Sample Sqlj Program====
-{{:software:db2:sailors.sqlj|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)
-      -sqlj.runtime
-      - sqlj.runtime.ref
-      - sqlj.runtime.profile
-      - 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
-       - ~db2leduc/sqllib/db2cshrc
-   *  Pre-compile the program (Running it through a translator)
-       -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).
-       - 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
-       - java sailor 71