Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Wed, 04 Feb 2004 @ 13:17:29 GMT


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


Subj:   Re: Error on multload
 
From:   Villeneuve Philippe

Thanks for your help,

I had well to do : release mload dsdsdsds.dssddsds

But now I have the error :

**** 14:10:31 UTY0805 RDBMS failure, 3538: A MultiLoad UPDATE Statement is Invalid.


My script :

.logtable DB_LOG.DW_SUIV_OPRT_TOUS_CLNT_16485;
.logon dbc/login,password,'dbc';
.begin import mload tables dbdevtu.DW_SUIV_OPRT_TOUS_CLNT WORKTABLES =
dbdevtu.DW_SUIV_OPRT_TOUS_CLNT_w ERRORTABLES =
dbdevtu.DW_SUIV_OPRT_TOUS_CLNT_e1 dbdevtu.DW_S
UIV_OPRT_TOUS_CLNT_e2 CHECKPOINT 0 SESSIONS 60 28;
.layout internal indicators;
.field DATE_ARRT_INFO * char(10);
.field CODE_ORGN_FINN * char(5);
.field CODE_GUIC * char(5);
.field CODE_PRDT_SERV * char(16);
.field REFR_PRDT * char(11);
.field IDNT_EDS_DOMC * char(8);
.dml label tdmload;
update dbdevtu.DW_SUIV_OPRT_TOUS_CLNT
 set IDNT_EDS_DOMC = :IDNT_EDS_DOMC
 where DATE_ARRT_INFO = :DATE_ARRT_INFO
   and CODE_ORGN_FINN = :CODE_ORGN_FINN
   and CODE_GUIC = :CODE_GUIC
   and CODE_PRDT_SERV = :CODE_PRDT_SERV
   and REFR_PRDT = :REFR_PRDT;
.import INFILE /devtu/dwh/datastage/autre/pve.mld format fastload layout =
internal apply tdmload;
.end mload;
.if &SYSETCNT then;
.set MLOADRC 20;
.else;
.if &SYSUVCNT then;
.set MLOADRC 20;
.else;
.set MLOADRC &SYSRC;
.endif;
.endif;
.logoff &MLOADRC;

What is wrong ?

Thanks


Regards,

--------------------------------------------
Philippe VILLENEUVE
Caisse d'épargne
France
---------------------------------------------



     
  <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: 23 Jun 2019