Re: ERROR : **** 19:13:12 UTY0805 RDBMS failure, 5407: Invalid operation on an ANSI Datetime or Interval
Hi Anil, AAA is an ODBC setting, it doesn't matter in MLoad. MLoad only uses CLI, but never ODBC, that's why i asked.
If you don't set FORMAT it defaults to binary FASTLOAD format, but you need TEXT.
If DATEFORM is set to ANSIDATE it must be a properly formated string (your sample data looks ok) else you have to define a CHAR with an appropriate length. The details can be found in the MLoad manual.