hi all, sorry if this is a stupid question (i'm new to db)

exists a way to ignore the insertion of an invalid row?

for example if i have a not-null constraint on the id column
when i make an INSERT with a null value as id i want that firebird will ignore that insert operation.

i must do the insertion of a lot of records with an higth percentage of invalid data so i think that if i can manage the exeception (that is ignoring the invalid record) at the database level it's better that managing that at application level.

another stupid question about performance is that, when i must do a lot of insert (~1000) it's better to wrap them into an explicit single transaction or left the default implicit transaction management? (i don't need to rollback all if same insertion fails, every insert is indipendent)

thanks