XFM problem due to fixed width file delimited

rhaddur · Post by **rhaddur** » Mon Apr 02, 2007 5:28 am

Dear Gurus

1>my source system use to send flat files(around 100) 58 column with FIXED WIDTH delimited now they are added one more column 59

some files having column having 58 columns and some 59

when I am trying to process at tranformation with 59 columns(meta data)it is creating problem as follows

read_fixedwidth() - row 712840, column CUST_ID, required column

missing

my env as follows
datastage 7.1 unix 8,

Please guid on the same how to solve the problem

chulett · Post by **chulett** » Mon Apr 02, 2007 6:04 am

Try sliding your Columns over to the right and setting the last field's Incomplete column attribute to Replace.

ray.wurlod · Post by **ray.wurlod** » Mon Apr 02, 2007 8:44 am

However you approach it you are going to have to edit the table definition in your repository to include the new column. Optionally you might set the "incomplete column" property as suggested.

Before doing that, select the table definition and perform a Usage Analysis to identify all the jobs that use this table definition. You will also need to check each of these jobs to adjust the design to handle the fact that there is an extra column that must be read - since it is a sequential file you must read it, to get to the next row, even if you subsequently do nothing with it.

rhaddur · Post by **rhaddur** » Tue Apr 03, 2007 12:35 am

chulett wrote:Try sliding your Columns over to the right and setting the last field's Incomplete column attribute to Replace. ...

please let me know how you will slide through datastage

kumar_s · Post by **kumar_s** » Tue Apr 03, 2007 1:10 am

Do you need to extract the column that has been added or do you with to drop it.
You can increase the length of the last column and specify the "Incomplete column" so that in case of short of last column it should take care.

chulett · Post by **chulett** » Tue Apr 03, 2007 7:22 am

rhaddur wrote:
chulett wrote:Try sliding your Columns over to the right and setting the last field's Incomplete column attribute to Replace. ...
please let me know how you will slide through datastage

What? Really? Ok, more details...

Get to the Columns tab of the Sequential File stage. There's more to it than can display all at once, hence the existence of the 'slider' / scroll bar at the bottom of the window. Click/hold on it and drag ('slide' or 'scroll') it over to the right to see the other columns available, including the one I mentioned.

kumar_s · Post by **kumar_s** » Tue Apr 03, 2007 9:45 pm

Double clicking on the field will give its properties.

ray.wurlod · Post by **ray.wurlod** » Tue Apr 03, 2007 10:31 pm

Right click on a row in the Columns grid and choose Edit Row from the menu. You can also double click on the row number in the Columns grid. In the Sequential File stage there is a horizontal scroll bar at the bottom that will get you to where Craig suggested you go.