[DERBY-6850] Enhancements to SYSCS_UTIL.SYSCS_EXPORT_TABLE

• Type: Improvement
• Status: Open
• Priority: Major
• Resolution: Unresolved
• Affects Version/s: 10.11.1.1, 10.12.1.1
• Component/s: Miscellaneous
• Environment: CENTOS
• Urgency: Urgent
• Assignee: Unassigned
• Reporter: Anjana
• Created: 06/Jan/16 04:31
• Updated: 06/Jan/16 04:31

Description

Following are enhancement request for SYSCS_UTIL.SYSCS_EXPORT_TABLE

1.Ability to import all or selective file name : Procedure should export all the tables of the provided schema. A path name can be taken as parameter and file name can be formulated internally using table naming convention.
2. Ability to overwrite the export file : If same file name is used to export it should be overwritten.
3. Ability to block writes : if export is selected for all tables it should block updates to database during the export process.Post export process is complete the writes should be enabled.