By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
440,727 Members | 757 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 440,727 IT Pros & Developers. It's quick & easy.

DB2 UDB 8.1 SQLJ precompile: attribute error

P: n/a
DB2 UDB V8.1 Fixpak 4 AIX 5.1
CLASSPATH:
/usr/opt/db2_08_01/java/db2jcc.jar:/usr/opt/db2_08_01/java/db2jcc_license_cu.jar:/usr/opt/db2_08_01/java/sqlj.zip:/usr/java131/jre/lib/rt.jar:
Program: tmp0.sqlj

import java.sql.*;
import sqlj.runtime.*;
import sqlj.runtime.ref.*;
import com.ibm.math.*;

#sql iterator table1_Cursor1 implements sqlj.runtime.Scrollable with
(sensitivity=SENSITIVE, dynamic=false) (String c1);

class tmp0
{
static
{
try
{
Class.forName("com.ibm.db2.jcc.DB2Driver").newInst ance();
}
catch (Exception e)
{
e.printStackTrace();
}
}

public static void main(String argv[])
{
try
{
table1_Cursor1 cursor1=null;
#sql cursor1 = { SELECT c1 from schema1.table1};
}
catch( Exception e )
{
System.out.println("\n Trapped " );
e.printStackTrace();
System.exit(1);
}

}
}

Precompile: sqlj -compile=false tmp0.sqlj
Error/warning:
tmp0.sqlj:6.1-6.119: Warning: Iterator attribute dynamic is not
defined in the SQLJ specification.
tmp0.sqlj:27.1-27.47: Error: Invalid sensitivity WITH value. Detail
message: null
Total 1 error and 1 warning.

The (universal) sqlj driver works for basic cursor and fetch next. But
this precompile fails. Is there an update for sqlj I missed?

Bernard Dhooghe
Nov 12 '05 #1
Share this question for a faster answer!
Share on Google+

This discussion thread is closed

Replies have been disabled for this discussion.