problem while reading sequential file

snt_ds · Post by **snt_ds** » Wed Aug 06, 2008 11:49 pm

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?

ray.wurlod · Post by **ray.wurlod** » Thu Aug 07, 2008 1:02 am

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

dspxlearn · Post by **dspxlearn** » Thu Aug 07, 2008 1:40 am

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

snt_ds · Post by **snt_ds** » Thu Aug 07, 2008 2:19 am

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

dspxlearn · Post by **dspxlearn** » Thu Aug 07, 2008 3:01 am

Time to mark this thread as 'Resolved' :D