Archives of the TeradataForum

Message Posted: Thu, 05 Jun 2008 @ 09:12:07 GMT

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

Hi All,

I want to use .ACCEPT in one of my scripts, but am not able to come up with a working example. Can anyone help? right now i am usng the below script

     .logtable mloadlog;
     .logon DBC/ABC, ABC;


     CREATE TABLE accTAB (
     DeptNo SMALLINT  );

     .ACCEPT in_DeptNo from file  in_accept.input;

     .BEGIN MLOAD TABLES employee, accTAB;
     .layout lay1 ;
     .field DeptNo 2 char(5);

     .dml label insdml;


     Delete from employee where DeptNo = &in_DeptNo;
     insert into accTab (DeptNo) VALUES (:DeptNo);

     .import infile insert.input
     format text
     layout lay1
     apply insdml;

     .end mload;
     .logoff;

but i am getting this error:

     12:36:39 UTY0817 MultiLoad submitting the following request:
     BEGIN MLOAD employee,accTAB WITH INTERVAL;
     12:36:39 UTY0832 This MultiLoad import task cannot proceed: an
     unexpected MultiLoad phase, DML transaction, was reported by the RDBMS.

Can any one please help!

Thanks

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