Archives of the TeradataForum
Message Posted: Tue, 09 Dec 2003 @ 08:01:31 GMT
| Subj: | | Multiload error UTY3410 |
| |
| From: | | Danae Mead |
I have been receiving the following error on a couple of my multiload scripts the last few weeks:
"UTY3410 A semi-colon was not found to terminate the current statement."
This is caused because every time the multiload script is opened either by a mload or by a person notepad is adding a date/time stamp to
the bottom of the script. As I see it MLoad reads the script, preforms what is needed (deletes, insert, updates), reads the end transaction
and then tries to read the date/time stamps (of course no semi-colons at the end). Once it does this the script then errors out. If you do
not clean up the errors from this then of course the table is locked and you will not be able to load the next day's data. I have attached
the last part of the out log for people to view.
Has anyone else experienced this? What is most annoying is that the same script has been running perfectly fine for the last several
months and now we are starting to get this type of error messaging.
Danae
| 
