[
https://issues.apache.org/jira/browse/DERBY-2527?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel#action_12497107
]
Suresh Thalamati commented on DERBY-2527:
-----------------------------------------
Thanks for addressing my comments, Laura. I read through your comments,
looks like you need my input only for this one:
>>We still need an example for
>>SYSCS_UTIL.SYSCS_EXPORT_QUERY_LOBS_TO_EXTFILE
Yes, it is similar to other SYSCS_EXPORT_QUERY procedures, But I agree with you
it will good to have an example for this one too.
Example exporting data from a query, using a separate export file for the LOB
data
The following example shows how to export employee data in department 20 from
the
STAFF table in a sample database to the main file staff.del and the lob
data to the file pictures.dat.
CALL SYSCS_UTIL.SYSCS_EXPORT_QUERY_LOBS_TO_EXTFILE(
'SELECT * FROM STAFF WHERE dept=20',
'c:\data\staff.del', ',','"','UTF-8','c:\data\pictures.dat');
> 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.
