Hi,
We are generating the xml files using xml output stage.If we hard code the filepath , it is generating the files.
If we pass the file path as parameter , xml files are not getting generated, but the job sucessfully runs without any warning.
Please let us know how to generate the files by giving filepath as parameter.
Thanks in advance.
Regards,
Hema K
How to pass file path as parameter in xml output stage
Moderators: chulett, rschirm, roy
-
- Premium Member
- Posts: 536
- Joined: Thu Oct 11, 2007 1:48 am
- Location: Bangalore
Hi,
You can parametrize the xml file path and file name.We have done in the same way.
File path =#EVENT_XML_PATH#/#XML_NAME#.xml
and its generating the output file successfully.
Please check with your path,if it is correct in parameter.
You can parametrize the xml file path and file name.We have done in the same way.
File path =#EVENT_XML_PATH#/#XML_NAME#.xml
and its generating the output file successfully.
Please check with your path,if it is correct in parameter.
Thanks
Prasoon
ETL Consultant
LinkedIn :- http://www.linkedin.com/profile/view?id ... ab_pro_top
Blog:- http://dsshar.blogspot.com/
Prasoon
ETL Consultant
LinkedIn :- http://www.linkedin.com/profile/view?id ... ab_pro_top
Blog:- http://dsshar.blogspot.com/
Hi Prasson,
Thanks for your reply.
The job is working fine after giving the job parameters.
Initially I have specified environmental variable for file path and it is not working.
Could you please let us know why it is not accepting environmental variable.what should be done If i want to use environmental variable ?
Please help.
Regards,
Hema K
Thanks for your reply.
The job is working fine after giving the job parameters.
Initially I have specified environmental variable for file path and it is not working.
Could you please let us know why it is not accepting environmental variable.what should be done If i want to use environmental variable ?
Please help.
Regards,
Hema K
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
You still need the "#" markers for environment variables, and these need to have been loaded into the job as parameters. For example:
File path =#$EVENT_XML_PATH#/#$XML_NAME#.xml
File path =#$EVENT_XML_PATH#/#$XML_NAME#.xml
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.