Examples of org.apache.derby.iapi.sql.dictionary.TabInfo.deleteRow()

Package org.apache.derby.iapi.sql.dictionary

Class org.apache.derby.iapi.sql.dictionary.TabInfo

Examples of org.apache.derby.iapi.sql.dictionary.TabInfo.deleteRow()

org.apache.derby.iapi.sql.dictionary.TabInfo.deleteRow()
Given a key row, delete all matching heap rows and their index rows.
LOCKING: row locking if there is a key; otherwise, table locking. @param tc transaction controller @param key key to delete by. @param indexNumber Key is appropriate for this index. @return the number of rows deleted. If key is not unique,this may be more than one. @exception StandardException Thrown on failure

          ExecIndexRow keyRow)
      throws StandardException
  {
    TabInfo           ti = coreInfo[SYSCOLUMNS_CORE_NUM];


    ti.deleteRow( tc, keyRow, SYSCOLUMNSRowFactory.SYSCOLUMNS_INDEX1_ID );
  }


  /**
   * Update the column descriptor in question.  Updates
   * every row in the base conglomerate.

View Full Code Here


    /* Set up the start/stop position for the scan */
    ExecIndexRow keyRow = (ExecIndexRow) exFactory.getIndexableRow(1);
    keyRow.setColumn(1, viewIdOrderable);


    ti.deleteRow( tc, keyRow, SYSVIEWSRowFactory.SYSVIEWS_INDEX1_ID );


  }


  /**
   * Scan sysfiles_index2 (id) for a match.

View Full Code Here

    idOrderable = getValueAsDVD(fid.getUUID());


    /* Set up the start/stop position for the scan */
    keyRow1 = (ExecIndexRow) exFactory.getIndexableRow(1);
    keyRow1.setColumn(1, idOrderable);
    ti.deleteRow( tc, keyRow1, SYSFILESRowFactory.SYSFILES_INDEX2_ID );
  }


  /**
   * Get a SPSDescriptor given its UUID.
   *

View Full Code Here


    /* Set up the start/stop position for the scan */
    ExecIndexRow keyRow = (ExecIndexRow) exFactory.getIndexableRow(1);
    keyRow.setColumn(1, stmtIdOrderable);


    ti.deleteRow( tc, keyRow, SYSSTATEMENTSRowFactory.SYSSTATEMENTS_INDEX1_ID );


    /* drop all columns in SYSCOLUMNS */  
    dropAllColumnDescriptors(uuid, tc);
  }

View Full Code Here


    /* Set up the start/stop position for the scan */
    ExecIndexRow keyRow = (ExecIndexRow) exFactory.getIndexableRow(1);
    keyRow.setColumn(1, idOrderable);


    ti.deleteRow(tc, keyRow, SYSTRIGGERSRowFactory.SYSTRIGGERS_INDEX1_ID);
  }


  /**
   * Update the trigger descriptor in question.  Updates
   * every row in the base conglomerate that matches the uuid.

View Full Code Here


    /* Set up the start/stop position for the scan */
    ExecIndexRow keyRow = (ExecIndexRow) exFactory.getIndexableRow(1);
    keyRow.setColumn(1, stmtIdOrderable);


    ti.deleteRow( tc, keyRow, SYSSTATEMENTSRowFactory.SYSSTATEMENTS_INDEX1_ID );


    /* drop all columns in SYSCOLUMNS */  
    dropAllColumnDescriptors(uuid, tc);
  }

View Full Code Here


    /* Set up the start/stop position for the scan */
    ExecIndexRow keyRow = (ExecIndexRow) exFactory.getIndexableRow(1);
    keyRow.setColumn(1, idOrderable);


    ti.deleteRow(tc, keyRow, SYSTRIGGERSRowFactory.SYSTRIGGERS_INDEX1_ID);
  }


  /**
   * Update the trigger descriptor in question.  Updates
   * every row in the base conglomerate that matches the uuid.

View Full Code Here

    /* Set up the start/stop position for the scan */
    keyRow = (ExecIndexRow) exFactory.getIndexableRow(2);
    keyRow.setColumn(1, constraintNameOrderable);
    keyRow.setColumn(2, schemaIDOrderable);


    ti.deleteRow( tc, keyRow, SYSCONSTRAINTSRowFactory.SYSCONSTRAINTS_INDEX2_ID );
  }


  /**
   * Drops all ConstraintDescriptors from the data dictionary
   * that are associated with the given table,

View Full Code Here


    /* Set up the start/stop position for the scan */
    keyRow1 = (ExecIndexRow) exFactory.getIndexableRow(1);
    keyRow1.setColumn(1, constraintIdOrderable);


    ti.deleteRow( tc, keyRow1, indexNum);
  }


  /**
   * Get a SubCheckConstraintDescriptor from syschecks for
   * the specified constraint id.  (Useful for check constraints.)

View Full Code Here


    /* Set up the start/stop position for the scan */
    checkRow1 = (ExecIndexRow) exFactory.getIndexableRow(1);
    checkRow1.setColumn(1, constraintIdOrderable);


    ti.deleteRow( tc, checkRow1, SYSCHECKSRowFactory.SYSCHECKS_INDEX1_ID );
  }


  /**
   * Get all of the ConglomerateDescriptors in the database and
   * hash them by conglomerate number.

View Full Code Here

0 1 2 3 4 5

TOP

All source code are property of their respective owners. Java is a trademark of Sun Microsystems, Inc and owned by ORACLE Inc. Contact coftware#gmail.com.