[
https://issues.apache.org/jira/browse/DERBY-2527?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel#action_12497112
]
Suresh Thalamati commented on DERBY-2527:
-----------------------------------------
Thanks Laura, I reviewed the import/export related sections in the attached
pdf files, changes looks good. Please commit the changes.
Some Minor things I noticed when I was reading through the doc again :
Derby tools Guide :
1)
On Page 46 :
It says , in the second section : "The import and export procedures read and
write only text files" not true any more , import/export writes and reads
binary data from the external lob file.
Please remove that sentence or change it to the following :
The import and export procedures read and write only text files, except when
blob data is imported or exported using an external file.
2) on Page 47 : section :Bulk import and export requirements and
considerations:
"
Restrictions on delimiters
You cannot specify Hex decimal characters (0-9, a-f, A-F) as delimiters for the
import
and export procedures"
you may want to remove the above , I don't want users to think that is the only
delimiter restriction.
This restriction is already listed under "File format for input and output" on
page page 49 :( Delimiters cannot be hex decimal characters (0-9, a-f, A-F).)
along with other delimiter restrictions.
3) I really like the way you listed procedures. One minor thing I noticed is :
a)
On page 50 :
1. Choose the correct procedure for the type of import that you want to perform:
and
For examples using these procedures, see Examples of bulk import and export.
Derby Tools and Utilities Guide
52
looks out of place.
you may want to have heading as : "Import Procedures "
and the below/above the table , write something like:
Choose the correct procedure for the type of import that you want to perform
from the table. For examples using these procedures,
see Examples of bulk import and export.Derby Tools and Utilities Guide
b) on page 52 , please do the same for export procedures.
Derby Reference Guide :
On page 126: SYSCS_UTIL.SYSCS_EXPORT_TABLE_LOBS_TO_EXTFILE example:
CALL SYSCS_UTIL.SYSCS_EXPORT_TABLE_LOBS_TO_EXTFILE(
'APP', 'STAFF', 'c:\data\staff.del', ', ', '"',
'UTF-8', 'c:\data\pictures.dat')
delete the space in the column delimiter parameter value : ', '
it shoud be just ','
Thanks
-suresh
> Add documentation for import/export of LOBS and other binary data types.
> ---------------------------------------------------------------------------
>
> Key: DERBY-2527
> URL: https://issues.apache.org/jira/browse/DERBY-2527
> Project: Derby
> Issue Type: Improvement
> Components: Documentation
> Affects Versions: 10.3.0.0
> Reporter: Suresh Thalamati
> Assigned To: Laura Stewart
> Attachments: derby2527_1.diff, derbytools.pdf, derbytools.pdf,
> iexlobs_v1.txt, refderby.pdf, refderby.pdf
>
>
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.
