XML output to an URL

ping · Post by **ping** » Wed Sep 22, 2004 7:20 am

I need to read from an Oracle table and produce XML format output, and HTTP the output stream to an URL (one row at a time). Can DS do this? If yes how?

chulett · Post by **chulett** » Wed Sep 22, 2004 7:41 am

Welcome!

I don't believe so, at least not the "HTTP the output stream to an URL" part. There have been other posts on this subject here, you may be able to turn them up with a search.

ray.wurlod · Post by **ray.wurlod** » Wed Sep 22, 2004 3:58 pm

This capability was added to UniVerse after the split from DataStage, in the form of a function library called CallHTTP. It does not exist natively in DataStage.

DataStage can certainly produce XML output.

You will therefore need something external to DataStage to handle sending the generated text (XML) file to its URL. You can execute this under DataStage control, but you can't do it with DataStage as shipped.

Depending on how the utility is written, you may be able to use the Filter property on a Sequential File stage. Otherwise, use ExecSH/ExecDOS or call DSExecute to execute the external command.