| Author |
Message
|
| praj1740 |
 Posted: Mon Mar 18, 2013 4:58 am Post subject: Configuring file output node properties through Esql |
 |
|
Apprentice
Joined: 05 Feb 2013
Posts: 29
Location: INDIA
|
Hi i am trying to create multiple output files For different records.For that im setting the file output node properties through esql for generating diff o/p files.For that the code im using is
| Code: |
SET OLE.Destination.File.Directory ='C:\temp\output' ;
SET OLE.Destination.File.Name = currentid||'.txt';
SET OLE.Destination.File.Action='Create';
SET OLE.Destination.File.TimeStamp=CURRENT_TIMESTAMP; |
here based on currentid it has to generate multiple o/p files.
But in the output im getting a file of name which is specified on the fileoutput node.Can Anyone help me in resolving this.Thank you. |
|
| Back to top |
|
 |
| Vitor |
| Posted: Mon Mar 18, 2013 5:05 am Post subject: Re: Configuring file output node properties through Esql |
|
|
Grand High Poobah
Joined: 11 Nov 2005
Posts: 26093
Location: Texas, USA
|
| praj1740 wrote: |
| But in the output im getting a file of name which is specified on the fileoutput node. |
Assuming "OLE" in your code is a reference to OutputLocalEnvironment, are you passing that to the FileOutput node?
_________________
Honesty is the best policy.
Insanity is the best defence. |
|
| Back to top |
|
|
| praj1740 |
| Posted: Mon Mar 18, 2013 5:07 am Post subject: |
|
|
Apprentice
Joined: 05 Feb 2013
Posts: 29
Location: INDIA
|
| Yes OLE is my reference and im passing it to file output node |
|
| Back to top |
|
|
| Vitor |
| Posted: Mon Mar 18, 2013 5:12 am Post subject: |
|
|
Grand High Poobah
Joined: 11 Nov 2005
Posts: 26093
Location: Texas, USA
|
| praj1740 wrote: |
| im passing it to file output node |
If you're certain that you've taken the steps necessary to do that (it doesn't happen by default) then you should raise a PMR as you've found a bug in the software.
But first I'd review what you're doing as that ESQL sets 4 fields which:
a) are read only
b) are part of the WrittenDestination tree not the Destination tree.
I don't think that would cause your problem (I think the FileOutput node will just ignore the Action and Timestamp fields) but does show that you've not read the documentation quite carefully enough.
_________________
Honesty is the best policy.
Insanity is the best defence. |
|
| Back to top |
|
|
| Esa |
| Posted: Mon Mar 18, 2013 5:15 am Post subject: |
|
|
Grand Master
Joined: 22 May 2008
Posts: 1387
Location: Finland
|
As you are setting the values in OutputLocalEnvironment you should verify that the Compute Mode of your Compute Node contains LocalEnvironment. Otherwise you should set the values in InputLocalEnvironment.
Also verify that you have not overridden the locations in the Request tab of your FileOutput node |
|
| Back to top |
|
|
| praj1740 |
| Posted: Mon Mar 18, 2013 5:25 am Post subject: |
|
|
Apprentice
Joined: 05 Feb 2013
Posts: 29
Location: INDIA
|
| I have set the compute mode property as localEnvironment and Message,and havn't changed the properties of Request tab of FileOutput node and left them as default. |
|
| Back to top |
|
|
| praj1740 |
| Posted: Mon Mar 18, 2013 5:39 am Post subject: |
|
|
Apprentice
Joined: 05 Feb 2013
Posts: 29
Location: INDIA
|
| Thanks For the Valuable info and Help.It is Working now.One Mistake i made is i have done is setting the PROPAGATE statement before configuring the fileOutput node in the eqsl.Now it has been Rectified |
|
| Back to top |
|
|
|
|
