CloneSet1975


Previous CloneSetNext CloneSetBack to Main Report
Clone
Mass
Clones in
CloneSet
Parameter
Count
Clone
Similarity
Syntax Category
[Sequence Length]
2201.000statement_sequence[2]
Clone AbstractionParameter Bindings
Clone Instance
(Click to see clone)
Line CountSource Line
Source File
12693
E:/TSE/Projects-CloneDR/sql12/fw/src/net/sourceforge/squirrel_sql/fw/dialects/DB2DialectExt.java
22725
E:/TSE/Projects-CloneDR/sql12/fw/src/net/sourceforge/squirrel_sql/fw/dialects/DB2DialectExt.java
Next
Last
Clone Instance
1
Line Count
2
Source Line
693
Source File
E:/TSE/Projects-CloneDR/sql12/fw/src/net/sourceforge/squirrel_sql/fw/dialects/DB2DialectExt.java

/*
 * DB2 doesn't support adding an auto-increment column once the table has already been created. So this
 * can simulate one using trigger on the table to access a sequence. Found this idea at wikibooks:
 * http://en.wikibooks.org/wiki/SQL_dialects_reference/Data_structure_definition/Auto-increment_column
 * CREATE SEQUENCE sequence_name; CREATE TABLE table_name ( column_name INT ); CREATE TRIGGER
 * insert_trigger NO CASCADE BEFORE INSERT ON table_name REFERENCING NEW AS n FOR EACH ROW SET
 * n.column_name = NEXTVAL FOR sequence_name;
 */
final String tableName = column.getTableName();
final String columnName = column.getColumnName();


First
Previous
Clone Instance
2
Line Count
2
Source Line
725
Source File
E:/TSE/Projects-CloneDR/sql12/fw/src/net/sourceforge/squirrel_sql/fw/dialects/DB2DialectExt.java

final String tableName = column.getTableName();
final String columnName = column.getColumnName();


Clone AbstractionParameter Count: 0Parameter Bindings

/*
                 * DB2 doesn't support adding an auto-increment column once the table has already been created. So this
                 * can simulate one using trigger on the table to access a sequence. Found this idea at wikibooks:
                 * http://en.wikibooks.org/wiki/SQL_dialects_reference/Data_structure_definition/Auto-increment_column
                 * CREATE SEQUENCE sequence_name; CREATE TABLE table_name ( column_name INT ); CREATE TRIGGER
                 * insert_trigger NO CASCADE BEFORE INSERT ON table_name REFERENCING NEW AS n FOR EACH ROW SET
                 * n.column_name = NEXTVAL FOR sequence_name;
                 */
final String tableName = column.getTableName();
final String columnName = column.getColumnName();
 

CloneAbstraction
Parameter Bindings
Parameter
Index
Clone
Instance
Parameter
Name
Value
None