ECLPlus Query

[prachi]

Hello
We have ECL code to spray file like this:

Code: Select all

IMPORT Std;

SprayCSVFile_withContent :=STD.File.fSprayVariable('10.101.2.171','/var/lib/HPCCSystems/mydropzone/ClientWebCrawlData_withFileContent.csv',
,,,,
'mythor','~Sapphire::data::csvFile::withContent',,'http://10.101.2.170:8010/FileSpray',
,TRUE,TRUE,FALSE);

output(SprayCSVFile_withContent);

and ECLPlus code to invoke this file:

Code: Select all

eclplus owner=root password=newuser_123 cluster=thor server=10.101.2.170 @/usr/share/dumphere/hpcc/SprayCSVFile_withContent.ecl

file is getting sprayed.
But now i want remove the hardcoded name of file in ECL code and want to pass the name of file through ECLPlus code as parameter.

1.How to achieve this??
2.What changes has to be done in the ECL code to substitute file name as variable name.
(currently code has file name: ClientWebCrawlData_withFileContent.csv) ??
3.Is there any way other than ECLPlus to achieve??
4.Multiple parameters as arguments can be passed through ECLPlus??

[bforeman]

I have a dumb question...have you considered using the DFUPlus command line to spray instead of the ECLPlus? ...and also the ECL Command line will soon supercede the ECLplus command line.

DFUPlus was designed to spray and despray via the command line as needed.

Regardless, I've asked development to look at your issue the way you are trying to implement it.

Regards,

Bob