• Setting up Tomcat for DB2 and some tips

    November 16, 2004

    NOTE: These were tested on win2k “C:jakarta-slide-2.0-tomcat-5.0.19” is mentioned as $CATALINA_HOME Pre-Requisites: DB2. Latest Java SDK Steps: Set an Enviromental Variable “JAVA_HOME” to the Java SDK’s Home Directory. Download & Install the latest binaries from Apache’s Site (Get *.exe for windows to install as a service) Copy “C:Program FilesIBMSQLLIBjavadb2java.zip” file to C:jakarta-slide-2.0-tomcat-5.0.19commonlib” and rename the […]

  • PreCompiling and Running Embeded SQL

    November 15, 2004

    Write your Embeded SQL C code with a file extension .sqc Precompiling db2 connect to database name db2 prep filename.sqc db2 connect reset The Above Command on Sucess will give a filename.c file. The C File needs to compilied with special flags as follows gcc filename.c -Wall -I/home/db2inst1/sqllib/include/ -L/home/db2inst1/sqllib/lib -ldb2 -Wl,-rpath,/opt/IBM/db2/V8.1/lib -o Run the outputfile […]

 
Powered by Wordpress and MySQL. Theme by Shlomi Noach, openark.org