How to read the XML files in Datastage PX?

[shivakumar]

Hi ,

I saw some IBM related website there they mentioned How to work with XML files in server job,For that they have used Folder stage.From this folder stage they are connecting to XML input stage.But when you open the PX job this stage is not present in the Pallet.So how to read from the XML files in PX.

Regards
Siva

[JoshGeorge]

Try reading an entire XML file as one single field in PX.To avoid "record is too big to fit in a block" error, APT_DEFAULT_TRANSPORT_BLOCK_SIZE need to be set to the double of maximum possible message size expected. You can read files in similar fashion using sequential stage:
File Pattern : #FilePath#*.xml
But reading entire contents of the XML files as one record/field like the Folder stage in Server is doubtful.