All Forums Teradata Applications
nani_hero 12 posts Joined 10/14
26 Oct 2014
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;

dnoeth 4628 posts Joined 11/04
26 Oct 2014

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.

Dieter

nani_hero 12 posts Joined 10/14
26 Oct 2014

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'
 

nerdgirl 10 posts Joined 05/15
18 May 2015

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

Cheers

alchang 8 posts Joined 05/14
12 Nov 2015

 
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.

Fred 1096 posts Joined 08/04
13 Nov 2015

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.

You must sign in to leave a comment.