Hi,
I have parallel job where data is coming from DRS stage(67 rows), then lookup is performed with ODBC stage(reference data, 1.5 million rows) which is then loaded into tdmload stage.
The job aborts with the error:Fatal Error: Fatal: MultiLoad returned: 8 ** Please refer to statements in /data/projects/vsd_dwhouse/data/VSD_PROD_MKTG/Logs/RETURN_ARS_RPT2 to resolve the issue **
In the mload generated file, the error obaserved is Bad keyword in the IMPORT command at position 110: Expected "LAYOUT" but found "AXSMOD".
Please help us in resolving this issue
Thanks
[/img][/list]
TDMload stage error:Bad keyword in the IMPORT command
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
Welcome aboard.
The error has come from the Teradata MLoad stage, in particular from the script that it has generated. Please verify that all settings in this stage are correct.
The error has come from the Teradata MLoad stage, in particular from the script that it has generated. Please verify that all settings in this stage are correct.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
-
- Premium Member
- Posts: 783
- Joined: Mon Jan 16, 2006 10:17 pm
- Location: Sydney, Australia