To run job from a file with empty fields

[loreandre]

Hi all,
When running a QS job, I am getting the following error:

ERROR: Incomplete record read from file /Ascential/QualityStage/Projects/Data/MALDDR

Investigating I believe that it is possible to have that QS perdite not to load a file that comes with null data. That I can do on the matter?

Many thanks

Lore

[jhmckeever]

LORE,

Your NULL data is not meeting the fixed-width requirement of your QualityStage job. Use some tool to substitute the appropriate number of space characters for the missing values (NULLS.) You can achieve this using DataStage, a Unix shell script, or possibly in whatever tool you are employing to generate your flat file.

HTH,
John.