Home Page for the TeradataForum

Archives of the TeradataForum

Message Posted: Tue, 15 Feb 2005 @ 14:20:11 GMT

  <Prev Next>   <<First <Prev

Subj:   Re: Problem with Multiload and different types of records in a flatfile
From:   Dieter Noeth

Christian Holzapfel wrote:

  Thanks for the hint, I have tried to write an INMOD routine now, that processes the data. (C und MP-RAS). As this is my first INMOD, I am a little confused about the errors I recieve: The example (TD Multiload Reference) I viewed stated, that at first Status code 0 to initialize, than code 1 for all following records should appear, and finally 5 for termination. Yet I am sent only codes 6, than 3, and for each record a status of 7, which is responded by multiload with the following, even though I return it a status=zero for "everything okay":  

  **** 12:55:23 UTY1808 Record 1 of Import 1 rejected due to preceding error.  

You specified infile *and* inmod within your .import? So MLoad reads the records and passes them to the inmod to be modified. 6 is similar to 0 and 7 to 1.

Check the Windows Sample INMOD -> you have to set "data_buf->code = 0"

If your Inmod reads the data from file you have to remove the "infile = bla" from .import and you'll never see those codes 6/7 again ;-)


  <Prev Next>   <<First <Prev
  Top Home Privacy Feedback  
Copyright for the TeradataForum (TDATA-L), Manta BlueSky    
Copyright 2016 - All Rights Reserved    
Last Modified: 15 Jun 2023