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
Fixed Column Width in PX Sequential File
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 17
- Joined: Fri May 25, 2007 11:59 am
-
- Participant
- Posts: 17
- Joined: Fri May 25, 2007 11:59 am
-
- Participant
- Posts: 17
- Joined: Fri May 25, 2007 11:59 am
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