Probably very simple answer

bangorlad@hotmail.com · Wed Oct 19, 2005 7:29 am

hi,
I'm sure there is a very simple answer to this but I am going to ask anyway.

I have a comma delimited file which has five fields per line. However, on some lines several fields can be missing (even the commas) and the job won't run.

This is what the job log tells me,

'A2000_PopulatePCMTable..PCM_csv.L01: read_delimited() - row 1, column vchrPCM3, required column missing'

How can you get round this? I thought the 'Missing columns action' would circumvent this problem but it doesn't.

ArndW · Post by **ArndW** » Wed Oct 19, 2005 7:32 am

The missing columns setting will solve this, but you need to start at the last column and work your way back until you get to a column which cannot be missing. Also, are you telling it to ignore errors or drop rows?

WoMaWil · Post by **WoMaWil** » Wed Oct 19, 2005 7:33 am

I personal think, that there are (without knowing the file) no simple answers.

you can read the whole row (or the whole part) in one field and use the field-function to get fields out.

you can tell the sender to use fix-length.

Is perhaps excel the source?

Wolfgang

bangorlad@hotmail.com · Wed Oct 19, 2005 7:52 am

Thanks, I will try some of those and get back to you.

roy · Post by **roy** » Wed Oct 19, 2005 3:35 pm

Hi,
Having empty or missing fields is one thing (that you can handle)
But having missing delimiters even makes this impossible to handle automatically (since ther is no way to say I'm missing column number n, you can only say I'm missing a column or columns) and may force you to reject those rows for manual handling.

IHTH,

ameyvaidya · Post by **ameyvaidya** » Wed Oct 19, 2005 5:39 pm

In the Sequential file Stage's Columns tab, look for a column named "Incomplete Column"(Near the end just before Description). The default value for this column for all rows is "Error".

If this value is changed to "Replace" for all column defn. entries, the stage will replace all missing or incomplete rows in the sequential file with NULL's. and this has been tested to work for missing delimiters too.

No error or warning message will be posted.

IHTH

ray.wurlod · Post by **ray.wurlod** » Wed Oct 19, 2005 5:40 pm

You will probably need to scroll the Columns grid to the right to find the Missing Columns rule.