#71 Oracle Connect By verb in SQL

[JimN]

I have found that when a Connect By verb is used in a SQL, the converted cobol does not contain the connect by portion of the SQL, however the execute that produced the Java code did not show errors.

The attached cobol program produces the following java code that shows the sql in the cobol with the connect by statements that are missing.

//@CobolSourceFile("TESTCOB2.cbl",39,13)
//EXEC SQL
// SELECT SupplyPointID
// into :sv-Integer
// FROM SupplyPointParent
// CONNECT BY SupplyPointID = PRIOR ParentSupplyPointID
// START WITH ParentSupplyPointID = 3910834
//END-EXEC
try {
__dao().prepareStatement("SELECT SupplyPointID "+
"FROM "+
"SupplyPointParent") ;
__dao().executeStatement();
if(__dao().resultExists()) {
wsSqlVariables.setSvInteger(__dao().getLong(1));
}
} catch(SQLException se) { se.printStackTrace();
} catch(Exception e) { e.printStackTrace(); System.exit(1); }

[JimN]

[VenkatK]

Fixed available 05/24/2010