Convert XML to Physical file (or CSV)

Theo Kouwenhoven
Theo Kouwenhoven used Ask the Experts™
Hi Experts,

I have to transform XML files from the IFS to CSV. In the past I did that with a XSL file and execute the next command from QSH;
java -classpath /QIBM/ProdData/OS400/xml/lib/xalan241.jar:/QIBM/ProdData/OS400/xml/lib/xerces411.jar:. org.apache.xalan.xslt.Process -IN file.xml -XSL file.xsl -OUT file.csv -TEXT

Open in new window

It seems that this command is no longer supported in V7R3, what is the alternative, to convert XML to a CSV or  a Physical-file
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Top Expert 2016

It seems that this command is no longer supported in V7R3
Which command? What you posted is a command to run a Java app
VP Technology / Senior Consultant
Xalan and Xerxes are supplied as part of the XML Tooklkit: 5733-XT2.  As far as I know it is supported under V7R3.  Is it installed (GO LICPGM, Option 10)?  If not, install it.

Do the two JAR files listed in the classpath exist in the same location?

What error(s) do you get when you try to run the command shown?

What version of IBM i OS was running on this system pre-upgrade?

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial