Retrieve the syntax error offset
To determine the exact location of a syntax error, use the getSQLStatementOffset() method to return the syntax error offset.
The following example shows how to retrieve
the syntax error offset from an SQL statement (which is
10
in
this example):try {
Statement stmt = conn.createStatement();
String command = "select * fom tt";
stmt.execute( command );
}
catch(Exception e)
{
System.out.println
("Error Offset :"+((IfmxConnection conn).getSQLStatementOffset() );
System.out.println(e.getMessage() );
}