I have a job like the following.
1. Extracting data form a xml file using a sequential file staging where the whole xml data is being read into a single column.
2. Parsing the xml by using new xml stage in datastage 8.5(the DS version where I developed the job).
3. Write the parsing records into one dataset.
After parsingn the xml I'm getting two records in the dataset which is actual. But when I'm using sequential file stage instead of datastage in the target then only one recor is showing when checking the data by using View Data.
Is there any proper reason for this type of behaviour of the stages?
Sequential file at the output of xml stage
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 152
- Joined: Mon Mar 07, 2011 6:16 am
I had a hard time following your setup. So the job looks something like this?
[Seq File] -> [XML Input] -> [Database]
And in the sequential file there's a column that is XML text. You use that column as the data source of the XML input?
And your question is, the XML string has two rows of data within the XML tags but when you do "View Data" in the sequential stage, you see just one row? Did I understand you correctly?
[Seq File] -> [XML Input] -> [Database]
And in the sequential file there's a column that is XML text. You use that column as the data source of the XML input?
And your question is, the XML string has two rows of data within the XML tags but when you do "View Data" in the sequential stage, you see just one row? Did I understand you correctly?
-
- Participant
- Posts: 152
- Joined: Mon Mar 07, 2011 6:16 am
Are you always seeing two rows leaving xml stage? If so, compare also to Peek, to be certain of what is going down those rows.
Ernie
Ernie
Ernie Ostic
blogit!
<a href="https://dsrealtime.wordpress.com/2015/0 ... ere/">Open IGC is Here!</a>
blogit!
<a href="https://dsrealtime.wordpress.com/2015/0 ... ere/">Open IGC is Here!</a>
-
- Participant
- Posts: 152
- Joined: Mon Mar 07, 2011 6:16 am
Also. Stop using "view data" when debugging this. Look at the sequential file using another editor. Your issue could simply be with view data. What are you getting in your sequential file.
Ernie
Ernie
Ernie Ostic
blogit!
<a href="https://dsrealtime.wordpress.com/2015/0 ... ere/">Open IGC is Here!</a>
blogit!
<a href="https://dsrealtime.wordpress.com/2015/0 ... ere/">Open IGC is Here!</a>
-
- Participant
- Posts: 152
- Joined: Mon Mar 07, 2011 6:16 am