Archives of the TeradataForum

Message Posted: Fri, 30 Dec 2005 @ 12:33:03 GMT

	<Prev	Next>		<<First	<Prev	Next>	Last>>

Hi,

I needed some very very basic help with mload. I have dug up the documentation and tried that employee example but unfortunately the create table gives me errors.

I wanted to just get it working to confirm that my installation is correct. following is my mload script:

     .logtable inslogtable;
     .logon dbc/sdm,sdm;
     CREATE TABLE employee
          (
          EmpNo Integer
          );
     .begin import mload tables employee;
     .layout inslayout;
     .field EmpNo char(9);
     .dml label insdml;
     insert into employee (empno) values(:Empno);
     .import infile C:\MULTILOAD\insert.input
     format text
     layout inslayout
     apply insdml;
     .end mload;
     .logoff;

Following is my Logfile

     ------------------------------------------------------------------------
     =                                                                      =
     =          MultiLoad Utility    Release MLOD.07.07.01.000              =
     =          Platform WIN32                                              =
     =                                                                      =
     ------------------------------------------------------------------------
     =                                                                      =
     =          Copyright 1990-2005, NCR Corporation. ALL RIGHTS RESERVED.  =
     =                                                                      =
     ------------------------------------------------------------------------
     **** 15:08:34 UTY2411 Processing start date: FRI DEC 30, 2005

     ------------------------------------------------------------------------
     =                                                                      =
     =          Logon/Connection                                            =
     =                                                                      =
     ------------------------------------------------------------------------
     0001 .Logtable Logtable003;
     0002 .Logon dbc/sdm,;
     **** 15:08:36 UTY8400 Default character set: ASCII

     **** 15:08:36 UTY8400 Current RDBMS has interval support
     **** 15:08:36 UTY8400 Maximum supported buffer size: 1M
     **** 15:08:36 UTY8400 Data Encryption supported by RDBMS server
     **** 15:08:38 UTY6211 A successful connect was made to the RDBMS.
     **** 15:08:38 UTY6217 Logtable 'SDM.Logtable003' has been created.

     ------------------------------------------------------------------------
     =                                                                      =
     =          Processing Control Statements                               =
     =                                                                      =
     ------------------------------------------------------------------------
     0003 create table employee( empno integer);
     **** 15:08:38 UTY1016 'CREATE' request successful.
     0004 .Begin Import Mload
          Tables Employee;

     ------------------------------------------------------------------------
     =                                                                      =
     =          Processing MultiLoad Statements                             =
     =                                                                      =
     ------------------------------------------------------------------------
     0005 .Layout Layoutname;
     0006 .Field EmpNum 1 integer;
     0007 .DML Label inslbl;
     0008 insert into employee (empno) values(:Empno);
     0009 .Import Infile c:\multiload\insert.input
          Layout LayoutName
          Apply inslbl;
     0010 .End Mload;

     ------------------------------------------------------------------------
     =                                                                      =
     =          MultiLoad Initial Phase                                     =
     =                                                                      =
     ------------------------------------------------------------------------

Looking forward to your help.

Regards,

Jay Munshi

	<Prev	Next>		<<First	<Prev	Next>	Last>>