UTY3403 Only one statement per line is allowed. Extra characters were detected beginning in column '10''

Teradata Applications
Enthusiast

UTY3403 Only one statement per line is allowed. Extra characters were detected beginning in column '10''

hi ,

im getting the  above error while running the script but i cant find any mistakes in the script plz, help me where it went wrong. it shows in begin import task .

.run file d:\practise\conn.txt;

.LOGTABLE ablog;

.BEGIN IMPORT MLOAD

    TABLES test.a,

        test.b

    WORKTABLES

         a_wt,

         b_wt

    ERRORTABLES

         a_et

         a_uv,

         b_et

         b_uv ;    

.LAYOUT aly ;

    .FIELD a_id * integer;

    .FILLER a_name * varchar(10);

.LAYOUT bly ;

    .FIELD b_id * integer;

    .FILLER b_name * varchar(10);

.DML LABEL albl;

    insert into a(id,name)values(:a_id,:a_name);

.DML LABEL blbl;

    insert into b(id,name)values(:b_id,:b_name);

.IMPORT INFILE D:\practise\mload\source\a.txt;

   FROM 1 FOR 2 THRU 2

   FORMAT vartext ','

   LAYOUT aly

   APPLY albl;

.IMPORT INFILE D:\practise\mload\source\b.txt;

   FROM 1 FOR 2 THRU 2

   FORMAT vartext ','

   LAYOUT blbl

   APPLY blbl;

.END MLOAD;

.LOGOFF;

5 REPLIES
Senior Apprentice

Re: UTY3403 Only one statement per line is allowed. Extra characters were detected beginning in column '10''

You should show the output of running this script, it should stop right where this error occured, usually it's due to a non-visible character like a tab.

And the semicolons at the end of the IMPORT line should be removed, the following lines are part of it.

Enthusiast

Re: UTY3403 Only one statement per line is allowed. Extra characters were detected beginning in column '10''

hi dneoth, thanks

after removing tabs space in begin import task again facing same error in diff column integer value.

.BEGIN IMPORT MLOAD

TABLES test.a,test.b

WORKTABLES a_wt,b_wt

ERRORTABLES a_et  a_uv,b_et b_uv ;

UTY3043 ONLY ONE STATEMENT per line is allowed.Extra characters were detected

begining in column '35'.

HERE IM GETTING ERROR............prev in column '10' now column '35'

Enthusiast

Re: UTY3403 Only one statement per line is allowed. Extra characters were detected beginning in column '10''

Is this been resolved? I am facing the same issue. 

Enthusiast

Re: UTY3403 Only one statement per line is allowed. Extra characters were detected beginning in column '10''

I got a same error on fastexport: 

UTY3043 ONLY ONE STATEMENT per line is allowed. Extra characters were detected

begining in column '25'.

I also tried to remove the extra characters after each semicolon. But the error is repeated.  

The fastexport table only have less than 10 columns, so what is the column '25' means here?  

And how can I locate the column? 

Thanks.

Teradata Employee

Re: UTY3403 Only one statement per line is allowed. Extra characters were detected beginning in column '10''

This error means there is something other than spaces between the semicolon and the end of the line. The 25 represents the relative character position within the script line that contains the offending character.