XML File Format ?

[nitin376]

Hi,
I am extracting XMl file from a sequential stage using file pattern option with the following wildcard option *.xml

Well, I need to specify the formats in sequential stage as what type of format, the xml file has i.e fixed width or delimiter or record field formats etc

Please suggest me, What formats I should fill in the format tab in seq stage ?
The meta data is as follows:
Filename 50 varchar
Filecontent 999999 varchar

Please advise me the solution to this problem

Thanks,
Nitin

[ray.wurlod]

The format can be whatever you require. But you can not read file name; you can only have one column being read, into the large VarChar. And you will probably still not get what you want; you will get one row for each line terminator in the file. The file name can be obtained from a stage property whose name I forget at the moment - search the forum to learn it.