You are viewing a plain text version of this content. The canonical link for it is here.

Posted to derby-dev@db.apache.org by Danoja Dias <da...@gmail.com> on 2016/05/28 18:05:38 UTC

Adding a new argument to the system pocedure

Hi All,

Is there a way to make optional arguments on system procedures? How can we
add new argument on a system procedure?

Any suggestion is very helpful.


-- 
Thanks,
Best Regards,
Danoja Dias.

Re: Adding a new argument to the system pocedure

Posted by Danoja Dias <da...@gmail.com>.

Hi Rick,

This is about DERBY-4555 <https://issues.apache.org/jira/browse/DERBY-4555>
.  SYSCS_IMPORT_TABLE function to take new argument.
The unction is like this.
SYSCS_IMPORT_TABLE( String  schemaName, String  tableName, String
fileName, String  columnDelimiter, String  characterDelimiter, String
codeset, short   replace).

It needs to take a new argument to get the number of lines to be dropped.

Thanks.

On Sun, May 29, 2016 at 9:06 PM, Rick Hillegas <ri...@gmail.com>
wrote:

> On 5/28/16 11:05 AM, Danoja Dias wrote:
>
>> Hi All,
>>
>> Is there a way to make optional arguments on system procedures? How can
>> we add new argument on a system procedure?
>>
>> Any suggestion is very helpful.
>>
>>
>> --
>> Thanks,
>> Best Regards,
>> Danoja Dias.
>>
> Hi Danoja,
>
> The last argument of a  SQL routine (e.g., a function or a procedure) can
> be a varargs argument. A varargs argument will match an invocation which
> has 0 or more trailing arguments which have the type of the last, varargs
> argument. The routine must be declared with parameter style DERBY. See the
> section on CREATE PROCEDURE in the Reference manual:
> http://db.apache.org/derby/docs/10.12/ref/rrefcreateprocedurestatement.html
>
> What procedure do you have in mind?
>
> Thanks,
> -Rick
>

-- 
Thanks,
Best Regards,
Danoja Dias.

Re: Adding a new argument to the system pocedure

Posted by Rick Hillegas <ri...@gmail.com>.

On 5/28/16 11:05 AM, Danoja Dias wrote:
> Hi All,
>
> Is there a way to make optional arguments on system procedures? How 
> can we add new argument on a system procedure?
>
> Any suggestion is very helpful.
>
>
> -- 
> Thanks,
> Best Regards,
> Danoja Dias.
Hi Danoja,

The last argument of a  SQL routine (e.g., a function or a procedure) 
can be a varargs argument. A varargs argument will match an invocation 
which has 0 or more trailing arguments which have the type of the last, 
varargs argument. The routine must be declared with parameter style 
DERBY. See the section on CREATE PROCEDURE in the Reference manual: 
http://db.apache.org/derby/docs/10.12/ref/rrefcreateprocedurestatement.html

What procedure do you have in mind?

Thanks,
-Rick