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 ?
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.
I haven't failed, I've found 10,000 ways that don't work.
Thomas Alva Edison(1847-1931)
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 .