Mload failing when trying to load file with þ (thorn) as delimiter

Tools

Mload failing when trying to load file with þ (thorn) as delimiter

Hi All,

Not sure what I'm doing wrong but I'm trying to load a thorn (þ) delimited file.  Here is a sample record 

"field1"þ"field2"þ"field3"þ"field4"þ"field5"þ"field6"þ"field7"þ"field8"þ"field9"þ"field10"þ"field11"þ"field12"þ"field13"þ"field14"þ"field15"

Multiload script follows :

.logtable test.testtbl_log;
.logon 192.168.201.133/dbc,xxxxxxxxxx;
drop table test.testtbl_et;
drop table test.testtbl_ut;
drop table test.testtbl_uv;
drop table test.testtbl_wt;

.begin import mload tables test.testtbl
SESSIONS 20;
.layout InputFile_layout;
.field DateStr * VARCHAR(255) ;
.field Event * VARCHAR(255) ;
.field ToolbarId * VARCHAR(255) ;
.field UserId * VARCHAR(255) ;
.field Username * VARCHAR(255) ;
.field UserEmail * VARCHAR(255) ;
.field FirstName * VARCHAR(255) ;
.field LastName * VARCHAR(255) ;
.field Browser * VARCHAR(255) ;
.field BrowserVersion * VARCHAR(255) ;
.field OS * VARCHAR(255) ;
.field ToolbarVersion * VARCHAR(255) ;
.field SearchSource * VARCHAR(4000) ;
.field ClickType * VARCHAR(4000) ;
.field ClickUrl * VARCHAR(4000) ;

.dml label TableName_InsertDML;
insert into test.testtbl
(
DateStr
,Event
,ToolbarId
,UserId
,Username
,UserEmail
,FirstName
,LastName
,Browser
,BrowserVersion
,OS
,ToolbarVersion
,SearchSource
,ClickType
,ClickUrl

)
values
(
trim(both from trim(both '"' from :DateStr ) )
,trim(both from trim(both '"' from :Event ) )
,trim(both from trim(both '"' from :ToolbarId ) )
,trim(both from trim(both '"' from :UserId ) )
,trim(both from trim(both '"' from :Username ) )
,trim(both from trim(both '"' from :UserEmail ) )
,trim(both from trim(both '"' from :FirstName ) )
,trim(both from trim(both '"' from :LastName ) )
,trim(both from trim(both '"' from :Browser ) )
,trim(both from trim(both '"' from :BrowserVersion) )
,trim(both from trim(both '"' from :OS ) )
,trim(both from trim(both '"' from :ToolbarVersion) )
,trim(both from trim(both '"' from :SearchSource ) )
,trim(both from trim(both '"' from :ClickType ) )
,trim(both from trim(both '"' from :ClickUrl ) )

);
.import infile testtbl_all.csv
format vartext '00FE'xc
display errors
layout InputFile_Layout
apply TableName_InsertDML;
.end mload;
.logoff;

I get the following error:

"field1"├╛"field2"├╛"field3"├╛"field4"├╛"field5"├╛"field6"├╛"field7"├╛"field8"├╛"field9"├╛"field10"├╛"field11"├╛"field12"├╛"field13"├╛"field14"├╛"field15"
**** 14:03:52 UTY4014 Access module error '61' received during 'pmReadDDparse'
operation: 'Warning, too few columns !ERROR! Delimited Data Parsing error:
Too few columns in row 1'
9 REPLIES
Teradata Employee

Re: Mload failing when trying to load file with þ (thorn) as delimiter

It appears your input is UTF8, so you need to tell MultiLoad that, e.g. via "-c UTF8" option on the mload command line.

Re: Mload failing when trying to load file with þ (thorn) as delimiter

Thanks for the reponse, Fred.

I did use -c utf8 for the mload command.  Here is the command along with the snippet from the log confirming that the character set is indeed utf8.

mload command:

mload -c utf8 < MLOAD_Delimited_file.script

snippet from log file showing utf8 as the character set:

**** 07:09:24 UTY8400 Teradata Database Release: 15.00.05.01
**** 07:09:24 UTY8400 Teradata Database Version: 15.00.05.01
**** 07:09:24 UTY8601 Character set specified: UTF8
Teradata Employee

Re: Mload failing when trying to load file with þ (thorn) as delimiter

You're halfway there.

The '00FE'xc is the UTF16BE representation of lower-case thorn, but by default the script encoding is assumed to be ASCII / TD LATIN. So either

  • Specify the equivalent TD Latin code point 'DE'xc for the delimiter, or
  • Add "-i UTF8" command-line option and specify the UTF8 representation 'C3BE'xc for the delimiter (the rest of your script contains only single-byte characters in UTF8 encoding, so would not require any conversion)
  • Convert the script to UTF16 encoding and set options / delimiter value accordingly (note Windows typically uses UTF16LE)

Re: Mload failing when trying to load file with þ (thorn) as delimiter

Please bear with me, code points and character sets confuse the hell out of me.  Trying to understand how you found out the TD Latin code point of 'DE'xc for a lower case thorn??

Teradata Employee

Re: Mload failing when trying to load file with þ (thorn) as delimiter

You can find the definition of Teradata Latin and Teradata ASCII in Appendix C of the International Character Set reference manual. Another good reference is the Orange Book: "Getting Started: International Character Sets and the Teradata Database".

Re: Mload failing when trying to load file with þ (thorn) as delimiter

Hi Fred,

I tried the first 2 suggested solutions.  The second solution works...thanks for your input.  Unfortunately, the first solution didn't and I'm trying to understand why.  Below is a desciption of what I did.  Thanks in advance.

For the first suggested solution:

My script encoding is Windows 1252.  

When I tried to code   format vartext  'DE'xc and run the mload using -c utf8 option, I got 

08:42:18 UTY4014 Access module error '39' received during 'pmSetSchema'
operation: 'Invalid UTF8 character encountered !ERROR! Specified
'Delimiter' character is not a valid UTF8 character'

When I ran the Mload without the -c utf8 I got :

´╗┐"field1"├¥"field2"├¥"field3"├¥"field4"├¥"field5"├¥"field6"├¥"field7"├¥"field8"├¥"field9"├¥"field10"├¥"field11"├¥"field12"├¥"field13"├¥"field14"├¥"field15"
**** 08:42:55 UTY4014 Access module error '61' received during 'pmReadDDparse'
operation: 'Warning, too few columns !ERROR! Delimited Data Parsing error:
Teradata Employee

Re: Mload failing when trying to load file with þ (thorn) as delimiter

I must admit I don't understand the "invalid character" message either. It is true that 'DE'xc is not a valid UTF8 character, but I would have expected that message only if the script encoding was UTF8.

Teradata Employee

Re: Mload failing when trying to load file with þ (thorn) as delimiter

Hi tonez01,

I copied your 'þ' character and put the in mload script as the delimiter, and just used the ASCII session character set,

      format vartext  'þ'

I was able to run the same job successfully, here is the output:

     ========================================================================

     =                                                                      =

     =     Copyright 1990-2016 Teradata Corporation. ALL RIGHTS RESERVED.   =

     =                                                                      =

     ========================================================================

**** 11:57:12 UTY2411 Processing start date: TUE MAR 08, 2016

     ========================================================================

     =                                                                      =

     =          Logon/Connection                                            =

     =                                                                      =

     ========================================================================

0001 .logtable testtbl_log;

0002 .logon <tdpid>/<user>,;

**** 11:57:12 UTY8400 Teradata Database Release: 15.10f.00.03

**** 11:57:12 UTY8400 Teradata Database Version: 15.10f.00.03

**** 11:57:12 UTY8601 Character set specified: ASCII                         

**** 11:57:12 UTY8400 Current RDBMS has interval support

**** 11:57:12 UTY8400 Current RDBMS has UDT support

**** 11:57:12 UTY8400 Current RDBMS has Large Decimal support

**** 11:57:12 UTY8400 Current RDBMS has TASM support

**** 11:57:12 UTY8400 Maximum supported buffer size: 1M

**** 11:57:12 UTY8400 Data Encryption supported by RDBMS server

**** 11:57:12 UTY6211 A successful connect was made to the RDBMS.

**** 11:57:12 UTY6217 Logtable 'IVY.testtbl_log' has been created.

     ========================================================================

     =                                                                      =

     =          Processing Control Statements                               =

     =                                                                      =

     ========================================================================

0003 drop table testtbl_et;

**** 11:57:12 UTY1008 RDBMS failure: 3807, Object 'testtbl_et' does not exist.

0004 drop table testtbl;

**** 11:57:12 UTY1016 'DROP' request successful.

0005 drop table testtbl_uv;

**** 11:57:12 UTY1008 RDBMS failure: 3807, Object 'testtbl_uv' does not exist.

0006 drop table testtbl_wt;

**** 11:57:12 UTY1008 RDBMS failure: 3807, Object 'testtbl_wt' does not exist.

0007 CREATE MultiSET TABLE testtbl, FALLBACK (

       DateStr varchar(255),

       Event varchar(255),

       ToolbarId varchar(255),

       UserId varchar(255),

       Username varchar(255),

       UserEmail varchar(255),

       FirstName varchar(255),

       LastName varchar(255),

       Browser varchar(255),

       BrowserVersion varchar(255),

       OS varchar(255),

       ToolbarVersion varchar(255),

       SearchSource varchar(4000),

       ClickType varchar(4000),

       ClickUrl varchar(4000)

     )

      PRIMARY INDEX(DateStr);

**** 11:57:12 UTY1016 'CREATE' request successful.

0008 .begin import mload tables testtbl

     SESSIONS 20;

     ========================================================================

     =                                                                      =

     =          Processing MultiLoad Statements                             =

     =                                                                      =

     ========================================================================

0009 .layout InputFile_layout;

0010 .field DateStr          *   VARCHAR(255) ;

0011 .field Event            *   VARCHAR(255)  ;

0012 .field ToolbarId        *   VARCHAR(255) ;

0013 .field UserId           *   VARCHAR(255)   ;

0014 .field Username         *   VARCHAR(255)   ;

0015 .field UserEmail        *   VARCHAR(255)  ;

0016 .field FirstName        *   VARCHAR(255)  ;

0017 .field LastName         *   VARCHAR(255)  ;

0018 .field Browser          *   VARCHAR(255)  ;

0019 .field BrowserVersion   *   VARCHAR(255)  ;

0020 .field OS               *   VARCHAR(255)  ;

0021 .field ToolbarVersion   *   VARCHAR(255)  ;

0022 .field SearchSource     *   VARCHAR(4000) ;

0023 .field ClickType        *   VARCHAR(4000) ;

0024 .field ClickUrl         *   VARCHAR(4000) ;

0025 .dml label TableName_InsertDML;

0026 insert into testtbl

      (

      DateStr            

      ,Event             

      ,ToolbarId         

      ,UserId            

      ,Username      

      ,UserEmail         

      ,FirstName         

      ,LastName      

      ,Browser           

      ,BrowserVersion    

      ,OS                

      ,ToolbarVersion   

      ,SearchSource  

      ,ClickType         

      ,ClickUrl      

      )

      values

      (

      trim(both from trim(both '"' from :DateStr      ) )

     ,trim(both from trim(both '"' from :Event          ) )

     ,trim(both from trim(both '"' from :ToolbarId   ) )

     ,trim(both from trim(both '"' from :UserId      ) )

     ,trim(both from trim(both '"' from :Username    ) )

     ,trim(both from trim(both '"' from :UserEmail   ) )

     ,trim(both from trim(both '"' from :FirstName   ) )

     ,trim(both from trim(both '"' from :LastName    ) )

     ,trim(both from trim(both '"' from :Browser     ) )

     ,trim(both from trim(both '"' from :BrowserVersion) )

     ,trim(both from trim(both '"' from :OS          ) )

     ,trim(both from trim(both '"' from :ToolbarVersion) )

     ,trim(both from trim(both '"' from :SearchSource ) )    

     ,trim(both from trim(both '"' from :ClickType   ) )

     ,trim(both from trim(both '"' from :ClickUrl    ) )

      );

0027 .import infile data1.txt

      format vartext  'þ'

      display errors

      layout InputFile_Layout

      apply TableName_InsertDML;

0028 .end mload;

     ========================================================================

     =                                                                      =

     =          MultiLoad Initial Phase                                     =

     =                                                                      =

     ========================================================================

**** 11:57:12 UTY0829 Options in effect for this MultiLoad import task:

     .       Sessions:    20 session(s).

     .       Checkpoint:  15 minute(s).

     .       Tenacity:    4 hour limit to successfully connect load sessions.

     .       Errlimit:    No limit in effect.

     .       AmpCheck:    In effect for apply phase transitions.

**** 11:57:12 UTY0817 MultiLoad submitting the following request:

     Select NULL from IVY.testtbl_log where (LogType = 125) and (Seq = 1) and

     (MloadSeq = 0);

**** 11:57:13 UTY0817 MultiLoad submitting the following request:

     Select NULL from IVY.testtbl_log where (LogType = 120) and (Seq = 1);

**** 11:57:13 UTY0817 MultiLoad submitting the following request:

     SET QUERY_BAND='UTILITYNAME=MULTLOAD;' UPDATE FOR SESSION;

**** 11:57:13 UTY0817 MultiLoad submitting the following request:

     CHECK WORKLOAD FOR BEGIN MLOAD testtbl;

**** 11:57:13 UTY0817 MultiLoad submitting the following request:

     CHECK WORKLOAD END;

**** 11:57:15 UTY0812 MLOAD session(s) requested: 20.

**** 11:57:15 UTY0815 MLOAD session(s) connected: 4.

**** 11:57:15 UTY0817 MultiLoad submitting the following request:

     BEGIN MLOAD testtbl WITH INTERVAL;

**** 11:57:15 UTY0817 MultiLoad submitting the following request:

     INS IVY.testtbl_log (LogType, Seq, MLoadSeq)VALUES(130, 1, 10);

**** 11:57:15 UTY0817 MultiLoad submitting the following request:

     MLOAD testtbl with WT_testtbl errortables ET_testtbl, UV_testtbl;

     ========================================================================

     =                                                                      =

     =          MultiLoad DML Transaction Phase                             =

     =                                                                      =

     ========================================================================

**** 11:57:15 UTY0817 MultiLoad submitting the following request:

     BT;

**** 11:57:15 UTY0817 MultiLoad submitting the following request:

     USING DATESTR(VARCHAR(255)), EVENT(VARCHAR(255)), TOOLBARID(VARCHAR(255)),

     USERID(VARCHAR(255)), USERNAME(VARCHAR(255)), USEREMAIL(VARCHAR(255)),

     FIRSTNAME(VARCHAR(255)), LASTNAME(VARCHAR(255)), BROWSER(VARCHAR(255)),

     BROWSERVERSION(VARCHAR(255)), OS(VARCHAR(255)),

     TOOLBARVERSION(VARCHAR(255)), SEARCHSOURCE(VARCHAR(4000)),

     CLICKTYPE(VARCHAR(4000)), CLICKURL(VARCHAR(4000)) insert into testtbl

      (

      DateStr            

      ,Event             

      ,ToolbarId         

      ,UserId            

      ,Username      

      ,UserEmail         

      ,FirstName         

      ,LastName      

      ,Browser           

      ,BrowserVersion    

      ,OS                

      ,ToolbarVersion   

      ,SearchSource  

      ,ClickType         

      ,ClickUrl      

      )

      values

      (

      trim(both from trim(both '"' from :DateStr      ) )

     ,trim(both from trim(both '"' from :Event          ) )

     ,trim(both from trim(both '"' from :ToolbarId   ) )

     ,trim(both from trim(both '"' from :UserId      ) )

     ,trim(both from trim(both '"' from :Username    ) )

     ,trim(both from trim(both '"' from :UserEmail   ) )

     ,trim(both from trim(both '"' from :FirstName   ) )

     ,trim(both from trim(both '"' from :LastName    ) )

     ,trim(both from trim(both '"' from :Browser     ) )

     ,trim(both from trim(both '"' from :BrowserVersion) )

     ,trim(both from trim(both '"' from :OS          ) )

     ,trim(both from trim(both '"' from :ToolbarVersion) )

     ,trim(both from trim(both '"' from :SearchSource ) )    

     ,trim(both from trim(both '"' from :ClickType   ) )

     ,trim(both from trim(both '"' from :ClickUrl    ) )

      );

**** 11:57:15 UTY0817 MultiLoad submitting the following request:

     INS IVY.testtbl_log (LogType, Seq, MLoadSeq)VALUES(130, 1, 20);

**** 11:57:15 UTY0817 MultiLoad submitting the following request:

     ET;

     ========================================================================

     =                                                                      =

     =          MultiLoad Acquisition Phase                                 =

     =                                                                      =

     ========================================================================

**** 11:57:15 UTY0817 MultiLoad submitting the following request:

     BEGIN TRANSACTION;

**** 11:57:15 UTY0817 MultiLoad submitting the following request:

     CHECKPOINT LOADING INTERVAL 0;

**** 11:57:15 UTY0817 MultiLoad submitting the following request:

     CHECKPOINT LOADING INTERVAL 0;

**** 11:57:16 UTY0817 MultiLoad submitting the following request:

     CHECKPOINT LOADING INTERVAL 0;

**** 11:57:17 UTY0817 MultiLoad submitting the following request:

     USING Ckpt(VARBYTE(1024)) INSERT IVY.testtbl_log         (Logtype, Seq,

     MLoadSeq, MLoadImpSeq, MLoadSrcSeq,        

     MiscInt1,MiscInt2,MiscInt3,MiscInt4,        

     MiscInt5,MiscInt6,MiscInt7,MiscInt8,CkptInterval,byteflag,MLoadCkpt)       

      VALUES (110, 1, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, :Ckpt);

**** 11:57:17 UTY0817 MultiLoad submitting the following request:

     CHECKPOINT LOADING INTERVAL 0;

**** 11:57:18 UTY0817 MultiLoad submitting the following request:

     USING Ckpt(VARBYTE(1024)) INSERT IVY.testtbl_log         (Logtype, Seq,

     MLoadSeq, MLoadImpSeq, MLoadSrcSeq,        

     MiscInt1,MiscInt2,MiscInt3,MiscInt4,        

     MiscInt5,MiscInt6,MiscInt7,MiscInt8,CkptInterval,byteflag,MLoadCkpt)       

      VALUES (110, 1, 1, 1, 0, 1, 1, 1, 1, 0, 0, 0, 0, 0, 1, :Ckpt);

**** 11:57:18 UTY0826 A checkpoint has been taken, recording that end of file

     has been reached for IMPORT 1 of this MultiLoad Import task.

**** 11:57:18 UTY0817 MultiLoad submitting the following request:

     CHECKPOINT LOADING INTERVAL 1;

**** 11:57:19 UTY0817 MultiLoad submitting the following request:

     USING Ckpt(VARBYTE(1024)) INSERT IVY.testtbl_log          (Logtype, Seq,

     MLoadSeq, MLoadImpSeq, MLoadSrcSeq,         

     MiscInt1,MiscInt2,MiscInt3,MiscInt4,         

     MiscInt5,MiscInt6,MiscInt7,MiscInt8,CkptInterval,byteflag,MLoadCkpt)       

       VALUES (110, 1, 2, 1, 0, 1, 1, 1, 1, 0, 0, 0, 0, 1, 1, :Ckpt);

**** 11:57:19 UTY1803 Import processing statistics

     .                                       IMPORT  1     Total thus far

     .                                       =========     ==============

     Candidate records considered:........           1.......           1

     Apply conditions satisfied:..........           1.......           1

     Candidate records not applied:.......           0.......           0

     Candidate records rejected:..........           0.......           0

**** 11:57:19 UTY1821 Aquisition Phase statistics

     Elapsed time:  00:00:04

     CPU time:      0.0156001 Seconds

     MB/sec:        3.975e-005

     MB/cpusec:     0.0101922

**** 11:57:19 UTY0817 MultiLoad submitting the following request:

     CHECKPOINT LOADING INTERVAL 1;

**** 11:57:20 UTY0817 MultiLoad submitting the following request:

     CHECKPOINT LOADING INTERVAL 1 END;

**** 11:57:21 UTY0817 MultiLoad submitting the following request:

     INS IVY.testtbl_log (LogType, Seq, MLoadSeq)VALUES(130, 1, 30);

**** 11:57:21 UTY0817 MultiLoad submitting the following request:

     ET;

     ========================================================================

     =                                                                      =

     =          MultiLoad Application Phase                                 =

     =                                                                      =

     ========================================================================

**** 11:57:21 UTY0817 MultiLoad submitting the following request:

     EXEC MLOAD testtbl;

**** 11:57:21 UTY0818 Statistics for table testtbl:

        Inserts:                    1

        Updates:                    0

        Deletes:                    0

**** 11:57:21 UTY1822 Application Phase statistics

     Elapsed time:  00:00:00

**** 11:57:21 UTY0817 MultiLoad submitting the following request:

     INS IVY.testtbl_log (LogType, Seq) VALUES (115, 1)

**** 11:57:21 UTY0817 MultiLoad submitting the following request:

     BEGIN TRANSACTION;

**** 11:57:21 UTY0817 MultiLoad submitting the following request:

     END MLOAD;

**** 11:57:21 UTY0817 MultiLoad submitting the following request:

     INS IVY.testtbl_log (LogType, Seq) VALUES (120, 1)

**** 11:57:21 UTY0817 MultiLoad submitting the following request:

     USING Ckpt(VARBYTE(1024)) INS IVY.testtbl_log (LogType, Seq,

     MLoadCkpt)VALUES(135, 1, :Ckpt);

**** 11:57:21 UTY0817 MultiLoad submitting the following request:

     END TRANSACTION;

     ========================================================================

     =                                                                      =

     =          MultiLoad Task Cleanup                                      =

     =                                                                      =

     ========================================================================

**** 11:57:22 UTY0817 MultiLoad submitting the following request:

     SELECT CAST(COUNT(*) AS BIGINT) FROM ET_testtbl;

**** 11:57:22 UTY0821 Error table ET_testtbl is EMPTY, dropping table.

**** 11:57:22 UTY0817 MultiLoad submitting the following request:

     BEGIN TRANSACTION;

**** 11:57:22 UTY0817 MultiLoad submitting the following request:

     INS IVY.testtbl_log (LogType, Seq, MLoadSeq)VALUES(125, 1, 1)

**** 11:57:22 UTY0817 MultiLoad submitting the following request:

     DROP TABLE ET_testtbl;

**** 11:57:22 UTY0817 MultiLoad submitting the following request:

     END TRANSACTION;

**** 11:57:22 UTY0817 MultiLoad submitting the following request:

     SELECT CAST(COUNT(*) AS BIGINT) FROM UV_testtbl;

**** 11:57:22 UTY0821 Error table UV_testtbl is EMPTY, dropping table.

**** 11:57:22 UTY0817 MultiLoad submitting the following request:

     BEGIN TRANSACTION;

**** 11:57:22 UTY0817 MultiLoad submitting the following request:

     INS IVY.testtbl_log (LogType, Seq, MLoadSeq)VALUES(125, 1, 2)

**** 11:57:22 UTY0817 MultiLoad submitting the following request:

     DROP TABLE UV_testtbl;

**** 11:57:22 UTY0817 MultiLoad submitting the following request:

     END TRANSACTION;

**** 11:57:22 UTY0817 MultiLoad submitting the following request:

     BEGIN TRANSACTION;

**** 11:57:22 UTY0817 MultiLoad submitting the following request:

     INS IVY.testtbl_log (LogType, Seq, MLoadSeq)VALUES(125, 1, 3)

**** 11:57:22 UTY0817 MultiLoad submitting the following request:

     DROP TABLE WT_testtbl;

**** 11:57:22 UTY0817 MultiLoad submitting the following request:

     END TRANSACTION;

**** 11:57:22 UTY0825 Error table statistics for:

     Target table 1: testtbl

     Number of Rows        Error Table Name

     ====================  ==================================================

                        0  ET_testtbl

                        0  UV_testtbl

**** 11:57:22 UTY0817 MultiLoad submitting the following request:

     BEGIN TRANSACTION;

**** 11:57:22 UTY0817 MultiLoad submitting the following request:

     USING Ckpt(VARBYTE(1024)) INS IVY.testtbl_log (LogType, Seq,

     MLoadCkpt)VALUES(140, 1, :Ckpt);

**** 11:57:22 UTY0817 MultiLoad submitting the following request:

     INS IVY.testtbl_log (LogType, Seq) VALUES (125, 1)

**** 11:57:22 UTY0817 MultiLoad submitting the following request:

     END TRANSACTION;

**** 11:57:23 UTY0822 MultiLoad processing complete for this MultiLoad import

     task.

     ========================================================================

     =                                                                      =

     =          MultiLoad Task Complete                                     =

     =                                                                      =

     ========================================================================

**** 11:57:24 UTY1024 Session modal request, 'SET

     QUERY_BAND='UTILITYNAME=MULTLOAD;' UPDATE FOR SESSION;', re-executed.

     ========================================================================

     =                                                                      =

     =          Processing Control Statements                               =

     =                                                                      =

     ========================================================================

0029  .logoff;

     ========================================================================

     =                                                                      =

     =          Logoff/Disconnect                                           =

     =                                                                      =

     ========================================================================

**** 11:57:24 UTY6216 The restart log table has been dropped.

**** 11:57:24 UTY6212 A successful disconnect was made from the RDBMS.

**** 11:57:24 UTY2410 Total processor time used = '1.06081 Seconds'

     .       Start : 11:57:12 - TUE MAR 08, 2016

     .       End   : 11:57:24 - TUE MAR 08, 2016

     .       Highest return code encountered = '0'.

Teradata Employee

Re: Mload failing when trying to load file with þ (thorn) as delimiter

BTW,

there is an additional blank space in-between field6" and the þ in your data file. The result could be a sightly different from non-addtional blank space.

"field6" þ"field7"

sel * from testtbl;

 *** Query completed. One row found. 15 columns returned.

 *** Total elapsed time was 1 second.

       DateStr field1

         Event field2

     ToolbarId field3

        UserId field4

      Username field5

     UserEmail field6"

     FirstName field7

      LastName field8

       Browser field9

BrowserVersion field10

            OS field11

ToolbarVersion field12

  SearchSource field13

     ClickType field14

      ClickUrl field15

The result w/o the additional bank space:

 *** Query completed. One row found. 15 columns returned.

 *** Total elapsed time was 1 second.

       DateStr field1

         Event field2

     ToolbarId field3

        UserId field4

      Username field5

     UserEmail field6

     FirstName field7

      LastName field8

       Browser field9

BrowserVersion field10

            OS field11

ToolbarVersion field12

  SearchSource field13

     ClickType field14

      ClickUrl field15