Cannot read the data sequential stage

kashif007 · Post by **kashif007** » Wed Jan 03, 2007 6:02 pm

Hi I have a strange problem.
I cannot read the following file into my sequential stage, it has about 99000 rows. Below are a few of the lines from the file. There is another file same like this and it gets uploaded very easy. Can anyone tell me what will the problem. My format is perfectly fine.

| |000000000000000171 |ES97 |
| |000000000000000480 |AT92 |
| |000000000000000566 |AT92 |
| |000000000000000630 |AT92 |
| |000000000000000682 |AT92 |
| |000000000000001003 |DE03 |
| |000000000000001003 |DE04 |

Please tell me the format that works for this text file. I am using
Final Delimiter : End
Delimiter : |
The number of records get loaded but i cant see anything in the Data view, with this I cannot perform a join further in the job. Please help.

us1aslam1us · Post by **us1aslam1us** » Wed Jan 03, 2007 6:25 pm

In the last post you had resolved this, right!!

Why again you are not using field delimiter as TAB?

Sam

kashif007 · Post by **kashif007** » Wed Jan 03, 2007 6:33 pm

I did try that but it's not working for field delimiter as tab.

us1aslam1us · Post by **us1aslam1us** » Wed Jan 03, 2007 6:36 pm

Is it giving any error message. If so post it here.

kashif007 · Post by **kashif007** » Wed Jan 03, 2007 6:39 pm

There is no error it's just that i cannot see the data in view data from the sequential file, and since all the field come empty i cannot process them further in the job.

naren · Post by **naren** » Wed Jan 03, 2007 7:35 pm

kashif007 wrote:Hi I have a strange problem.
I cannot read the following file into my sequential stage, it has about 99000 rows. Below are a few of the lines from the file. There is another file same like this and it gets uploaded very easy. Can anyone tell me what will the problem. My format is perfectly fine.

| |000000000000000171 |ES97 |
| |000000000000000480 |AT92 |
| |000000000000000566 |AT92 |
| |000000000000000630 |AT92 |
| |000000000000000682 |AT92 |
| |000000000000001003 |DE03 |
| |000000000000001003 |DE04 |

Please tell me the format that works for this text file. I am using
Final Delimiter : End
Delimiter : |
The number of records get loaded but i cant see anything in the Data view, with this I cannot perform a join further in the job. Please help.

check the metadata properly and use final delimeter as |

kumar_s · Post by **kumar_s** » Wed Jan 03, 2007 7:37 pm

If other file is working fine, you may defenitly need to check the difference between the two file or the metadata of the two files been used.

kashif007 · Post by **kashif007** » Wed Jan 03, 2007 7:57 pm

The metadata is good.
I have used five columns to read the data and final delimiter is end if i look into the file in ultra edit. Some how I am not able to view it.

ray.wurlod · Post by **ray.wurlod** » Thu Jan 04, 2007 12:19 am

Whta data types are specified? What null representations have been specified? Try a record schema with five VarChar fields.

us1aslam1us · Post by **us1aslam1us** » Thu Jan 04, 2007 8:57 am

Sample data is having four columns. Also check again with your final delimiter?

Sam

samsuf2002 · Post by **samsuf2002** » Thu Jan 04, 2007 10:22 am

can you provide the complete file format you are using in sequential file stage?

kashif007 · Post by **kashif007** » Thu Jan 04, 2007 4:15 pm

Thanks guys. My Datastage is stupid or may be i am Stupid. I could see the data this morning.

us1aslam1us · Post by **us1aslam1us** » Thu Jan 04, 2007 4:53 pm

Either there has been some changes made to the file or the way you are processing it.

Sam

DSXchange

Cannot read the data sequential stage

Cannot read the data sequential stage

Re: Cannot read the data sequential stage