XMLread

[yogeshcts]

Hi Everyone,
This is how my design looks
sequential stage--xml input--transformer--teradata database

I have XMl file with different hirerarchy

I am trying to read XML input through sequential stage as a single column
I have tried different format as follows


1)Final delimiter=end

when i am trying to read these way i am getting the error as
Consumed more than 100000 bytes looking for record delimiter; aborting


i have tried in all other ways

i am getting errors like

<Sequential_File_3,0> Missing record delimiter "\n", saw EOF instead
<APT_CombinedOperatorController,0> <_PEEK_IDENT_>: Error message too long (8033735 > 130970) and has no newlines at which to break;
these are the error i used to get more when i tried on different options

Missing record delimiter "\n", saw EOF instead
i was able to resolve the above error by editing my xml file
but not able to resolve the second error.


i have tried using external source file also to read the xml file
but of no use


can some body help me out to read the xml file through sequential file


Thanks in advance

[chulett]

i have tried using external source file also to read the xml file but of no use

How so 'no use'? That is the answer and the preferred method over the sequential file stage in PX jobs. For example:

http://dsrealtime.wordpress.com/2007/12 ... -a-source/