DSXchange

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

What format properties are you using?

Record level
Final Delimiter = end (I this one with whitespace and none)
Field Defaults
Delimiter = commas
Quote= double (tried it with None as well )

Are you viewing the data in the output sequential stage? If so, perhaps your aggregator only output one row?

Actually I was looking at input stage "View Data" .

Have you set your view data options to limit to 1 row?

You need to define the record delimiter property. Check what process is generating the input file and are you able to view the file properly outside datastage.

ArndW wrote:Have you set your view data options to limit to 1 row? ...

No

us1aslam1us wrote:You need to define the record delimiter property.

Check what process is generating the input file and are you able to view the file properly outside datastage.

Input file was manually created and I am able to view it outside datastage.

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>?

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

ArndW wrote: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>? ...

It shows me only the last row on the file . Final delimiter is set to end . What is <CR> ?

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

I generated the text file in windows and trasferred it to the unix server .

Also when I use quote and Final Delimiter as none it gives me the following error
Error executing view data command
import validation failed .

Enabling the record delimiter property to DOS fixes the problem ,but I still don t understand the reason for this

Thanks

Your answer lies here:

I generated the text file in windows and trasferred it to the unix server .

[/code]