Page 1 of 1
XML output to an URL
Posted: Wed Sep 22, 2004 7:20 am
by ping
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?
Posted: Wed Sep 22, 2004 7:41 am
by chulett
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.
Posted: Wed Sep 22, 2004 3:58 pm
by ray.wurlod
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.