Differences

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

--- software:db2:start [2017/03/29 11:16] – seela
+++ software:db2:start [2017/03/29 11:23] (current) – seela
@@ Line 228: / Line 228: @@
 </code>
+====A Sample JDBC Program with type 4 connectivity====
+\\
+ {{:private:software:db2:ezsailor.java|JDBC sample program }}
+\\
+Once downloaded , rename the file to EzSailor.java
+\\
+Edit the java source file to modify the database and tables you have created
+\\
+{{:private:software:db2:ezjava.java|Another  sample table}}
+\\
+Must be renamed to EzJava.java and edited to make the right connection
+\\
+**How to execute the jdbc program**
+\\
+Make sure you have the table "sailor" created or else the query will not
+be able to execute
+  * source the client configuration file : ~db2leduc/sqllib/db2cshrc
+  * javac EzSailor.java
+  * java  EzJava c3421m
+----
+\\
+====A Sample Sqlj Program with type 4 connectivity====
+**How to execute the sqlj code**
+\\
+  * Download the sample code
+  * Table "sailor" should exist" or modify your code to use your own tables
+{{:private:software:db2:sailors.sqlj|sqlj}}
+\\
+This is a sample sqlj program that does the precompiling for you .
+Remember these are just example scripts to aid the development of your own code
+\\
+\\
+   * Program name : sailor.sqlj
+   * source ~db2leduc/.cshrc
+   * sqlj sailors.sqlj
+   * db2sqljcustomize -url jdbc:db2:c3421m sailors_SJProfile0.ser
+   * java sailors 71
+     will return your output
+\\