Does fastLoad apply Exclusive lock on target table ? If not what type of lock is applied ?
It's not an exclusive lock, but a special lock in the table header preventing any SQL access until it's release by an END LOADING.
Let's say my FASTLOAD failed for some error. In that case, if I need to release the lock, should I write a script with this table as a fastload but not keeping any insert statement and (most important) just keeping an end_loading?
I am not Dieter, but let me give some directions:
In the fastload manual: