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 <[email protected]> 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.
