[DERBY-6844] SYSCS_IMPORT_TABLE for multiple table should be in one transaction

• Type: Improvement
• Status: Open
• Priority: Major
• Resolution: Unresolved
• Affects Version/s: 10.11.1.1, 10.12.1.1
• Component/s: Build tools
• Environment: CENTOS
• Urgency: Normal
• Assignee: Unassigned
• Reporter: Anjana
• Created: 27/Nov/15 18:53
• Updated: 28/Nov/15 15:11

Description

We are using system procedure SYSCS_UTIL.SYSCS_IMPORT_TABLE to import data from a file. We have 30 imports of the table.

As per understanding each call to SYSCS_IMPORT_TABLE each import is in one transaction. The transaction for complete imports i.e all the table is not achievable.
If it is not then can we define system procedure . Can anyone please guide if any documentation available on same.

Thanks,
Anjana