Ines Liefeld wrote : > Hallo, > > I have a problem with a statement like > > update dba.n_Stellen > set vze_anspruch=vze_anspruch+:vze > where deckring_sl in > (select deckring_sl from DBA.n_deckring > where verguet_sl=:c_verguet and not ueberlauf) > and akt_datum>=:c_beg and akt_datum<=:c_end > AND SCHULAMT_NR=:SANR > > It breaks with error -2010: Assignment impossible, char > value too long. > > The values are: > - c_verguet(int)=6 > - c_beg(date)='2002-01-01' > - c_end(date)='2002-08-01' > - sanr(int)=3 > - vze(float(38))=2.9285714285479964285714286000000000000E-02 > - vze_anspruch(float(38))=48.4517032971988 /52.4129120884674 > /49.4517032972108 / ... or so, but not null > > btw: the statement > > update dba.n_Stellen > set vze_anspruch=vze_anspruch+fixed(:vze,8,2) > where deckring_sl in > (select deckring_sl from DBA.n_deckring > where verguet_sl=:c_verguet and not ueberlauf) > and akt_datum>=:c_beg and akt_datum<=:c_end > AND SCHULAMT_NR=:SANR > > breaks with the same error message, but > > set vze=fixed(vze,8,2); > update dba.n_Stellen > set vze_anspruch=vze_anspruch+:vze > where deckring_sl in > (select deckring_sl from DBA.n_deckring > where verguet_sl=:c_verguet and not ueberlauf) > and akt_datum>=:c_beg and akt_datum<=:c_end > AND SCHULAMT_NR=:SANR > > works without error! > > What is wrong? > > Thanks for your help! >
This is a bug. The error occurred inside a db-procedure, where a local variable of type float(38) has been bound to an expression of an update statement. The parameter in this expression is described as float(20). Since the variable has more than 20 digits at runtime, error -2010 is returned. We will fix this problem as soon as possible. Thomas -- Thomas Anhaus SAP DB, SAP Labs Berlin [EMAIL PROTECTED] http://www.sapdb.org/ _______________________________________________ sapdb.general mailing list [EMAIL PROTECTED] http://listserv.sap.com/mailman/listinfo/sapdb.general _______________________________________________ sapdb.general mailing list [EMAIL PROTECTED] http://listserv.sap.com/mailman/listinfo/sapdb.general
