Home Page for the TeradataForum
 

Archives of the TeradataForum

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


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


Subj:   How can i use .ACCEPT in my script?
 
From:   Shukla, Neha

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>>  
 
 
 
 
 
 
 
 
  
  Top Home Privacy Feedback  
 
 
Copyright for the TeradataForum (TDATA-L), Manta BlueSky    
Copyright 2016 - All Rights Reserved    
Last Modified: 27 Dec 2016