CloneSet240


Previous CloneSetNext CloneSetBack to Main Report
Clone
Mass
Clones in
CloneSet
Parameter
Count
Clone
Similarity
Syntax Category
[Sequence Length]
31210.996statement_sequence[7]
Clone AbstractionParameter Bindings
Clone Instance
(Click to see clone)
Line CountSource Line
Source File
13290
E:/TSE/Projects-CloneDR/sql12/plugins/db2/src/net/sourceforge/squirrel_sql/plugins/db2/exp/SequenceParentExpander.java
23192
E:/TSE/Projects-CloneDR/sql12/plugins/db2/src/net/sourceforge/squirrel_sql/plugins/db2/exp/UDFParentExpander.java
Next
Last
Clone Instance
1
Line Count
32
Source Line
90
Source File
E:/TSE/Projects-CloneDR/sql12/plugins/db2/src/net/sourceforge/squirrel_sql/plugins/db2/exp/SequenceParentExpander.java

final ObjFilterMatcher filterMatcher = new ObjFilterMatcher(session.getProperties());
String sql = SQL;
if (isOS400) {
  sql = OS_400_SQL;
}
final PreparedStatement pstmt = conn.prepareStatement(sql);
ResultSet rs = null;
try {
  pstmt.setString(1, schemaName);
  pstmt.setString(2, filterMatcher.getSqlLikeMatchString());
  rs = pstmt.executeQuery();
  while (rs.next()) {
    IDatabaseObjectInfo si = new DatabaseObjectInfo(catalogName, schemaName, rs.getString(1), DatabaseObjectType.SEQUENCE, md);
    if (filterMatcher.matches(si.getSimpleName())) {
      childNodes.add(new ObjectTreeNode(session, si));
    }
  }
}
finally {
  SQLUtilities.closeResultSet(rs);
  SQLUtilities.closeStatement(pstmt);
}
return childNodes;


First
Previous
Clone Instance
2
Line Count
31
Source Line
92
Source File
E:/TSE/Projects-CloneDR/sql12/plugins/db2/src/net/sourceforge/squirrel_sql/plugins/db2/exp/UDFParentExpander.java

final ObjFilterMatcher filterMatcher = new ObjFilterMatcher(session.getProperties());
String sql = SQL;
if (isOS400) {
  sql = OS_400_SQL;
}
final PreparedStatement pstmt = conn.prepareStatement(sql);
ResultSet rs = null;
try {
  pstmt.setString(1, schemaName);
  pstmt.setString(2, filterMatcher.getSqlLikeMatchString());
  rs = pstmt.executeQuery();
  while (rs.next()) {
    IDatabaseObjectInfo si = new DatabaseObjectInfo(catalogName, schemaName, rs.getString(1), DatabaseObjectType.UDF, md);
    if (filterMatcher.matches(si.getSimpleName())) {
      childNodes.add(new ObjectTreeNode(session, si));
    }
  }
}
finally {
  SQLUtilities.closeResultSet(rs);
  SQLUtilities.closeStatement(pstmt);
}
return childNodes;


Clone AbstractionParameter Count: 1Parameter Bindings

final ObjFilterMatcher filterMatcher = new ObjFilterMatcher(session.getProperties());
String sql = SQL;
if (isOS400) {
  sql = OS_400_SQL;
}
final PreparedStatement pstmt = conn.prepareStatement(sql);
ResultSet rs = null;
try {
  pstmt.setString(1, schemaName);
  pstmt.setString(2, filterMatcher.getSqlLikeMatchString());
  rs = pstmt.executeQuery();
  while (rs.next()) {
    IDatabaseObjectInfo si = new DatabaseObjectInfo(catalogName, schemaName, rs.getString(1), DatabaseObjectType. [[#variable18d83420]], md);
    if (filterMatcher.matches(si.getSimpleName())) {
      childNodes.add(new ObjectTreeNode(session, si));
    }
  }
}
finally {
  SQLUtilities.closeResultSet(rs);
  SQLUtilities.closeStatement(pstmt);
}
return childNodes;
 

CloneAbstraction
Parameter Bindings
Parameter
Index
Clone
Instance
Parameter
Name
Value
11[[#18d83420]]
SEQUENCE 
12[[#18d83420]]
UDF