Fixed Column Width in PX Sequential File

ds_debasis · Post by **ds_debasis** » Tue Aug 28, 2007 3:07 pm

Hi
I'm using a sequential file with fixed width columns (no white space or tab separator). On sequential file format property I'm using
Final Delimiter : none
Delimiter : none
Quote : none

it is giving only one column while viewing the records.
This job was there in server edition and running as server job sequential file has got option of fixed width length.

Can some one help me to get the records in all the columns ?

Thanks
Debasis

ArndW · Post by **ArndW** » Tue Aug 28, 2007 3:13 pm

What are your first two column metadata definitions in your job? When you do a 'display data' do you only get the 1st column contents (correctly)? What is displayed for the 2nd column?

ds_debasis · Post by **ds_debasis** » Tue Aug 28, 2007 3:23 pm

Duplicate....

ds_debasis · Post by **ds_debasis** » Tue Aug 28, 2007 3:23 pm

ArndW wrote:What are your first two column metadata definitions in your job? When you do a 'display data' do you only get the 1st column contents (correctly)? What is displayed for the 2nd column? ...

Varchar ( 8 )
Varchar ( 11 )

Yaa, I'm getting first column correctly.
Second column is NULL for all the records.

total length of the record is 25 chars. but I need only first 19.

Thanks for the quick reply.

Regards
Debasis