DSXchange

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?

Quotes handling in parallel jobs. Search the forum for more information.

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

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.

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

Time to mark this thread as 'Resolved' :D