[
https://issues.apache.org/jira/browse/DERBY-2859?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13826819#comment-13826819
]
Mano commented on DERBY-2859:
-----------------------------
Thanks for the reply.
I read it from one of the posts from Mr. Suresh Thalamati.
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')
If that is wrong. Could you please suggest me an example like above.
> Misleading error message if you supply too many arguments to
> SYSCS_UTIL.SYSCS_EXPORT_QUERY_LOBS_TO_EXTFILE
> ----------------------------------------------------------------------------------------------------------
>
> Key: DERBY-2859
> URL: https://issues.apache.org/jira/browse/DERBY-2859
> Project: Derby
> Issue Type: Bug
> Components: SQL, Tools
> Affects Versions: 10.3.1.4
> Reporter: Rick Hillegas
> Priority: Minor
> Labels: derby_triage10_5_2
>
> If you supply too many arguments to
> SYSCS_UTIL.SYSCS_EXPORT_QUERY_LOBS_TO_EXTFILE, you get an error message
> telling you that SYSCS_UTIL.SYSCS_EXPORT_QUERY_LOBS_TO_EXTFILE is an unknown
> procedure. Instead, you should get an error message which tells you that the
> signature can't be matched to a known overload of the procedure:
> ij> call SYSCS_UTIL.SYSCS_EXPORT_QUERY_LOBS_TO_EXTFILE
> (
> 'select * from lobtable where updateCount in( 2, 4 )',
> 'LOBTABLE',
> '/export/home/rick/junk/test-export-table1.dat',
> null,
> null,
> null,
> '/export/home/rick/junk/test-export-query1-lobs.dat'
> );
> ERROR 42Y03: 'SYSCS_UTIL.SYSCS_EXPORT_QUERY_LOBS_TO_EXTFILE' is not
> recognized as a function or procedure.
--
This message was sent by Atlassian JIRA
(v6.1#6144)
