[
https://issues.apache.org/jira/browse/DERBY-2527?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel#action_12487589
]
Laura Stewart commented on DERBY-2527:
--------------------------------------
Thanks for the spec. I have a few questions.
I'm a little confused by the example:
CALL SYSCS_UTIL.SYSCS_EXPORT_TABLE_LOBS_TO_EXTFILE(
null,'staff','c:\data\staff.del',null,null,null, 'c:\data\pictures.dat');
I don't quite understand all of the arguments for the
SYSCS_UTIL.SYSCS_EXPORT_TABLE_LOBS_TO_EXTFILE system procedure.
Have these been documented yet?
Please explain the arguments in your example:
null = ? Is this supposed to be the schema name? If the user enters "null"
does Derby take the current schema name?
staff' = source table name
'c:\data\staff.del' = main export file path and name
null = ? Is this supposed to be the columnDelimiter? If the user enters "null"
what does Derby do? Is there a default columnDelimiter?
null = ? Is this supposed to be the characterdelimiter? If the user enters
"null" what does Derby do? Is there a default characterdelimiter?
null = ?Is this supposed to be the codeset? If the user enters "null" what
does Derby do? Is there a default codeset?
'c:\data\pictures.dat' = LOB column export file path and name
I see the current syntax for the IMPORT and EXPORT system procedures in the
docs. And am glad to see that NULL is explained for each argument. But the
syntax is shown in a very poor way. The user NEVER specifies "IN".
Instead of this:
SYSCS_UTIL.SYSCS_IMPORT_DATA (IN SCHEMANAME VARCHAR(128),
IN TABLENAME VARCHAR(128), IN INSERTCOLUMNS VARCHAR(32672),
IN COLUMNINDEXES VARCHAR(32672), IN FILENAME VARCHAR(32672),
IN COLUMNDELIMITER CHAR(1), IN CHARACTERDELIMITER CHAR(1),
IN CODESET VARCHAR(128), IN REPLACE SMALLINT)
The syntax should appear in the docs as:
SYSCS_UTIL.SYSCS_IMPORT_DATA(
SCHEMANAME, TABLENAME, INSERTCOLUMNS, COLUMNINDEXES, FILENAME,
COLUMNDELIMITER,
CHARACTERDELIMITER, CODESET, REPLACE
)
The "IN", data type, and length should not appear in the syntax but in the
explanation... do you agree???
> 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
> Attachments: iexlobs_v1.txt
>
>
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.
