Problem viewing the data
Moderators: chulett, rschirm, roy
Problem viewing the data
Hi everybody
I have problem accessing the a seq file
Here is the job
SEQFILEINPUT -- > AGGREGATOR --> SEQFILEOUTPUT
My input has three columns X,Y,Z
with data looking like this (comma delimiter)
22,44,66
234,344,2222
345,456,7980
For some reason when I view data it gives me only last row ?
What can be the problem ?
Thanks
I have problem accessing the a seq file
Here is the job
SEQFILEINPUT -- > AGGREGATOR --> SEQFILEOUTPUT
My input has three columns X,Y,Z
with data looking like this (comma delimiter)
22,44,66
234,344,2222
345,456,7980
For some reason when I view data it gives me only last row ?
What can be the problem ?
Thanks
-
- Charter Member
- Posts: 822
- Joined: Sat Sep 17, 2005 5:25 pm
- Location: USA
Are you viewing the data in the output sequential stage? If so, perhaps your aggregator only output one row?
<a href=http://www.worldcommunitygrid.org/team/ ... TZ9H4CGVP1 target="WCGWin">
</a>
</a>
Have you set your view data options to limit to 1 row?
<a href=http://www.worldcommunitygrid.org/team/ ... TZ9H4CGVP1 target="WCGWin">
</a>
</a>
-
- Charter Member
- Posts: 822
- Joined: Sat Sep 17, 2005 5:25 pm
- Location: USA
If you only see one row, does it contain just the data for the first row in the correct format? Have you set your final delimiter to <cr>?
<a href=http://www.worldcommunitygrid.org/team/ ... TZ9H4CGVP1 target="WCGWin">
</a>
</a>
the sequential file you generated manually is different from using datastage when your ds server is Unix,i guess you must generate it in windows then transfer to Unix,that makes the different.if you directly generate it in unix,the file can be the same with datastage generated.you can compare the file you generated manually with datastage does in hex mode,you can see the file from Windows contain an additional x'0D' before x'0A',unix file only contains x'0A'.and i think if you choose Final Delimiter = none and Quote = none(if you really didn't add quote in the sequential file you generated),that will make you see all data
MaDFroG
I generated the text file in windows and trasferred it to the unix server .Zhang Bo wrote:the sequential file you generated manually is different from using datastage when your ds server is Unix,i guess you must generate it in windows then transfer to Unix,that makes the different.if you directly generate it in unix,the file can be the same with datastage generated.you can compare the file you generated manually with datastage does in hex mode,you can see the file from Windows contain an additional x'0D' before x'0A',unix file only contains x'0A'.and i think if you choose Final Delimiter = none and Quote = none(if you really didn't add quote in the sequential file you generated),that will make you see all data
Also when I use quote and Final Delimiter as none it gives me the following error
Error executing view data command
import validation failed .
-
- Charter Member
- Posts: 822
- Joined: Sat Sep 17, 2005 5:25 pm
- Location: USA