While viewing the sequential file in parallel job:
"No rows were returned from the viewData sever command. Would you like to see the commands output? when i clicked yes I got a message like:
"Bad trailing quote character at field "Account_Number"; looking for '34' but found '1', at offset: 13"
Same file i can able to view data in server job with out any warnings/errors.
Can anyone suggest me what might be the problem?
problem while reading sequential file
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
Hi,
Thanks for your quick response.
Now i can able to see the data because "Account_Number" column is of datalength 10 only, previously it was 12 thats is the reason datastage looking for double quotes in second field.
Thanks for your quick response.
Now i can able to see the data because "Account_Number" column is of datalength 10 only, previously it was 12 thats is the reason datastage looking for double quotes in second field.
dspxlearn wrote:It is probably trying to find double quote character (34 is the ascii value of "") and it found '1'. Check your data length and the format in the sequential file stage.
Open the file and see what it is exactly at the end of "Account_Number" field..