DSXchange

Hi All,

Iam trying to view data in sequential file but it is throwing the following error, can any one please help me. Thanks!

I IIS-DSEE-TFSC-00001 10:13:51(011) <main_program> APT configuration file: /opt/IBM/InformationServer/Server/Configurations/default.apt
##W IIS-DSEE-TFIG-00182 10:13:52(000) <Sequential_File_20,0> Bad trailing quote character at field "TIMESTMP"; looking for '34' but found '.', at offset: 261
##W IIS-DSEE-TOIX-00154 10:13:52(001) <Sequential_File_20,0> Import warning at record 0.
##W IIS-DSEE-TOIX-00018 10:13:52(002) <Sequential_File_20,0> Import unsuccessful at record 0.
##W IIS-DSEE-TFIG-00182 10:13:52(003) <Sequential_File_20,0> Bad trailing quote character at field "TIMESTMP"; looking for '34' but found '.', at offset: 249
##W IIS-DSEE-TOIX-00154 10:13:52(004) <Sequential_File_20,0> Import warning at record 1.
##W IIS-DSEE-TOIX-00018 10:13:52(005) <Sequential_File_20,0> Import unsuccessful at record 1.
##W IIS-DSEE-TFIG-00182 10:13:52(006) <Sequential_File_20,0> Bad trailing quote character at field "TIMESTMP"; looking for '34' but found '.', at offset: 212
##W IIS-DSEE-TOIX-00154 10:13:52(007) <Sequential_File_20,0> Import warning at record 2.
##W IIS-DSEE-TOIX-00018 10:13:52(008) <Sequential_File_20,0> Import unsuccessful at record 2.

Is it fixed length file or delimiter file?

its a comma seperated file

Please check your sequencial file in unix using below command
awk -F ',' '{print $34}' infile | sort -n | uniq -c
It might be your data contains some wrong value.

command not found . we are using linux operating system(bash)

Ok. I send command for Unix.. Might be Number of fields are less comparing with your file.

The error message says a lot:

Bad trailing quote character at field "TIMESTMP"; looking for '34' but found '.', at offset: 261

What is your schema for the file and what do the records actually look like?

Regards,

actually i have took the target table metadata table definitions so i dont think there is a problem of fields being less in file. and schema of file is table structure

That may be so, but you failed to supply the answer to my questions:

What is the schema being used to read the file? Post the actual schema, don't just tell me where you got it from.

What do the records which failed look like? Post the records themselves--copy and paste from vi, more, less, head, tail, whatever

The point being: The schema being used to read the file does not match the file's data in some way.

I expect that this is a non-default timestamp format, which you should be able to resolve by providing the correct timestamp format in the metadata (whether that's in the job or in a schema file). The import operator is looking for the trailing quote character or a timestamp character, but found "." character.