Work at SourceForge, help us to make it a better place! We have an immediate need for a Support Technician in our San Francisco or Denver office.

Close

#71 Oracle Connect By verb in SQL

closed
nobody
None
5
2010-05-25
2010-05-16
JimN
No

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); }

Discussion

  • JimN
    JimN
    2010-05-16

     
    Attachments
  • VenkatK
    VenkatK
    2010-05-16

    Fixed available 05/24/2010

     
  • VenkatK
    VenkatK
    2010-05-25

    • status: open --> closed