How to read whole XML file as a string and in DataStage.

[vgundavarapu]

Hi All,

I have XML file, so I need to read whole XML file as a string and map to one output column in DataStage. I have tried no. ways, but no luck. Please help on this.


Thanks,
Venkata

[qt_ky]

Have you tried using the XML stage?

Here is an article link.

http://www.ibm.com/developerworks/data/ ... index.html

[vgundavarapu]

Thank you for your quick reply.

I am using XML stage currently.

I have read that online document, but they didn't mentioned exactly how to read whole XML file and map to one column.

They only talked about retrieving two flat files and composed as XML file and load into DB2 table.

In my case, I have XML file as source and need to load whole XML file into DB2 Column as XML type or STRING.


Thanks,
Venkata

[chulett]

There's no need for two conversations on the same topic. This one wins.

[vgundavarapu]

Hi Craig,

It's OK for me.

I have read online documents since morning as you mentioned, but I didn't find the correct solution so far.

I need to one thing is how to read whole XML file as String.


Thanks,
Venkata

[eostic]

If you are just reading it all as one big string, and it's in a disk file, then use a Server Job, with a Folder Stage...that will pick up "the whole file" within a single column......push it wherever you want to. No sense parsing the xml if you don't have to.

When you drop the Folder Stage and create an output link, load the built-in table definition onto it (it's in the Table Defs/Built-in category). Your contents will go into the column called "Record".

The Connectors were updated awhile back for xml types of columns, but do some careful testing independently before you include the xml.

Ernie

[qt_ky]

Just to clarify, do you want to dump it into a DB2 column with a data type of CLOB or XML, and not parse the XML or validate it?

[yugee]

Try declaring your input column as SQLtype - LongVarChar, Extented - Unicode and don't mention the length