Archives of the TeradataForum

Message Posted: Fri, 06 Feb 2004 @ 15:46:35 GMT

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

Hello,

I get the following error in multiload :

UTY0805 RDBMS failure, 3538: A MultiLoad UPDATE Statement is Invalid

The special thing is that I try to pass a constant value in the where clause, because I update a key value of the table. Is it possible to do this ?

my mload script :

.layout internal indicators;
.field DATE_ARRT_INFO * char(10);
.field CODE_ORGN_FINN * char(5);
.field CODE_GUIC * char(5);
.field REFR_PRDT_SERV * char(20);
.field NUMR_PERS * decimal(9,0);
.field NUMR_CHRN_PROF * decimal(3,0);
.field RANG_PERS * decimal(2,0);
.field CODE_MARC * char(6);
.field AGE * decimal(3,0);
.field IDNT_EDS_DOMC * char(8);
.field CODE_NIV_SERV * char(2);
.field CODE_SLE * char(6);
.field CODE_SEGM_COMP * char(4);
.field CODE_VALR_CLNT * char(1);
.field IDNT_AGNT * char(8);
.field SURF_FINN_EPAR * decimal(15,0);
.field CODE_INS_LOCL * char(5);
.field CODE_PACK * char(2);
.field CODE_PRDT_SERV * char(16);
.dml label tdmload;

update dbdwh_cean.DW_SUIV_OUVR_CLTR_CLNT
 set NUMR_PERS = :NUMR_PERS,
   CODE_MARC = :CODE_MARC,
   AGE = :AGE,
   IDNT_EDS_DOMC = :IDNT_EDS_DOMC,
   CODE_NIV_SERV = :CODE_NIV_SERV,
   CODE_SLE = :CODE_SLE,
   CODE_SEGM_COMP = :CODE_SEGM_COMP,
   CODE_VALR_CLNT = :CODE_VALR_CLNT,
   IDNT_AGNT = :IDNT_AGNT,
   SURF_FINN_EPAR = :SURF_FINN_EPAR,
   CODE_INS_LOCL = :CODE_INS_LOCL,
   CODE_PACK = :CODE_PACK

 where DATE_ARRT_INFO = :DATE_ARRT_INFO
   and CODE_ORGN_FINN = :CODE_ORGN_FINN
   and CODE_GUIC = :CODE_GUIC
   and REFR_PRDT_SERV = :REFR_PRDT_SERV
   and NUMR_PERS= 999999999
   and NUMR_CHRN_PROF = :NUMR_CHRN_PROF
   and RANG_PERS = :RANG_PERS
   and CODE_PRDT_SERV = :CODE_PRDT_SERV

The primary index of the table :

PRIMARY INDEX ( DATE_ARRT_INFO ,CODE_ORGN_FINN ,CODE_GUIC ,
REFR_PRDT_SERV ,NUMR_PERS ,NUMR_CHRN_PROF ,RANG_PERS ,CODE_PRDT_SERV );

Thanks in advance,

--------------------------------------------
Philippe VILLENEUVE
DSI .PBD D�cisionnel
--------------------------------------------

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