Converting XML Attributes to Elements

Hey, David:

We receive XML documents describing real estate. We match standard element names to database fields and use the element values to load our database. One new account asked if they could send us listing information as attributes instead of elements. They are using an SQL Server utility. Without thinking, I told them it would be no problem, because we could use an XSLT transform to convert the data to elements. I thought this would take a couple of hours, but I can't find any examples on the Internet.

READ MORE >

Executing Qshell Commands Dynamically

Hey, Ted:

I hope you can help another Qshell newbie. I would like to load a variable with a value like ">output.txt" or "|sort -r >anotherfile.txt" in order to specify the destination of output of a command at runtime. Qshell always responds with error 001-2113. Is it possible to specify redirection of output in a variable?

READ MORE >

Reader Feedback and Insights: Unix Is Not All Bad

Hey, Ted:

I've been racking my brain trying to use Unix Shell commands. Although CL is not perfect, I'll take it over Unix any day. Maybe someday IBM will provide us with CL commands that we true AS/400 programmers can use. As a matter of fact, the biggest thing I could use is the capability to create a subroutine within a CL to execute a repetitive task. Yes, I know that I can write another CL program, but overhead is a consideration.