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
Program: tmp0.sqlj

import java.sql.*;
import sqlj.runtime.*;
import sqlj.runtime.ref.*;

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

class tmp0
Class.forName("").newInst ance();
catch (Exception e)

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


Precompile: sqlj -compile=false tmp0.sqlj
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.