@Kollol Misra
Thanks for your response. I have added the paths of SQLLIB/BIN , sqlj4.zip, db2jcc4.jar in CLASSPATH and PATH. When I run the java command you shared i get following error :
java sqlj.tools.Sqlj SampleSQLJ.sqlj
Error: Could not find or load main class sqlj.tools.Sqlj
Also can you please let me know if you have db2sqljcustomize file inside SQLLIB/BIN path ? I have the sqlj4.zip in SQLLIB/java , should we need any other files for SQLJ compilation ?
------------------------------
Rajakumari Rajasekaran
------------------------------
Original Message:
Sent: Thu November 28, 2024 05:22 AM
From: Kollol Misra
Subject: SQLJ compilation
C:\>which db2sqljcustomize
/c/SQLLIB/BIN/db2sqljcustomize
So make sure the PATH env variable points to the SQLLIB/BIN folder
As an alternate to the windows command you can use below class as well.
SQLJ command
java sqlj.tools.Sqlj samplesqlj.sqlj
db2sqljcustomize command
java com.ibm.db2.jcc.sqlj.Customizer -url jdbc:db2://host:port/database -user username -password password samplesqlj_SJProfile0.ser
After migrating to 11.5.* replace the CLASSPATH with the sqlj4.zip for SQLJ and db2jcc4.jar for JCC driver.
------------------------------
Kollol Misra
------------------------------