Hello,
I appreciate the extensive capabilities of KNIME, but I am stuck on one point related to this thread. I am interested in running KNIME from the command line, and need to be able to pass dates to a stored procedure executing on a T-SQL database. My Database Reader node has the command exactly as shown below (no additional single- or double-quotes):
execute sql.dbo.Test_Knime '1/1/2011', '5/1/2011', '5/1/2011', '6/1/2011'
I have created a Workflow Variable called SQLCommand, of type string, whose value is exactly
execute sql.dbo.Test_Knime '1/1/2011', '5/1/2011', '5/1/2011', '6/1/2011'
(I have also created a simple test Workflow Variable called MyTest that is an integer with a default value of 123456. I output that in a comment field in my CSV Writer node.
The command to execute this (in DOS) is:
knime -consoleLog -noexit -nosplash ^
-reset -failonloaderror ^
-application org.knime.product.KNIME_BATCH_APPLICATION ^
-workflowDir="C:\Users\williamn\Documents\KNIME\Classifier" ^
-workflow.variable="SQLCommand","execute sql.dbo.Test_Knime '2/1/2011', '6/1/2011', '6/1/2011', '7/1/2011'",String ^
-workflow.variable="MyTest","1236",int
This dies with the error message:
Couldn't parse -workflow.variable argument: -workflow.variable=SQLCommand,execute sql.dbo.Test_Knime '2/1/2011', '6/1/2011', '6/1/2011', '7/1/2011',String: Invalid argument list
I have tried various versions of quotes but I am just guessing. Removing the first workflow.variable parameter set (and leaving MyTest) generates the expected, successful result.
Thanks in advance for any help.
Bill N