Archives of the TeradataForum
Message Posted: Thu, 05 Jun 2008 @ 09:12:07 GMT
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!
|Copyright 2016 - All Rights Reserved|
|Last Modified: 28 Jun 2020|