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
How to read the XML files in Datastage PX?
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 31
- Joined: Wed Mar 17, 2004 3:33 am
-
- Participant
- Posts: 612
- Joined: Thu May 03, 2007 4:59 am
- Location: Melbourne
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.
File Pattern : #FilePath#*.xml
But reading entire contents of the XML files as one record/field like the Folder stage in Server is doubtful.
Joshy George
<a href="http://www.linkedin.com/in/joshygeorge1" ><img src="http://www.linkedin.com/img/webpromo/bt ... _80x15.gif" width="80" height="15" border="0"></a>
<a href="http://www.linkedin.com/in/joshygeorge1" ><img src="http://www.linkedin.com/img/webpromo/bt ... _80x15.gif" width="80" height="15" border="0"></a>