[DERBY-6851] Enhancement to SYSCS_IMPORT_TABLE

• Type: Improvement
• Status: Open
• Priority: Major
• Resolution: Unresolved
• Affects Version/s: 10.11.1.1, 10.12.1.1
• Component/s: SQL, Tools
• Environment: CENTOS
• Urgency: Normal
• Assignee: Unassigned
• Reporter: Anjana
• Created: 06/Jan/16 04:37
• Updated: 06/Jan/16 14:17

Description

Following enhancement are needed for import procedure SYSCS_IMPORT_TABLE

1. Ability to import to all tables from a selected path.
2. Ability to turn off implicit commit in SYSCS_IMPORT_TABLE. So that the user can commit when this procedure is executed after other SQL queries i.e. alter column etc
3. Ability to import empty file in replace mode
4. Ability to disable constraint during import. If implicit commit is disable then imports can be performed without constraint violation.