Archives of the TeradataForum
Message Posted: Tue, 15 Feb 2005 @ 14:20:11 GMT
| 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 ;-)