db-derby-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Laura Stewart (JIRA)" <j...@apache.org>
Subject [jira] Commented: (DERBY-2527) Add documentation for import/export of LOBS and other binary data types.
Date Mon, 09 Apr 2007 18:13:32 GMT

    [ 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.


Mime
View raw message