copydb -c from VMS to Linux Money error.



Interesting error encountered a couple times. Anyone seen this?; (see
below)

I've used the "-c" on my copydb. Am also using -f4F79.38 -f8F79.38 for
float nums. Unloading accross a NETU via SQL command from a VMS Ingres
2.0/AXM to Ingres 2006 NPTL (64-bit)

It's complaining on the reload about max money value. Is it posible
I've got some rows of data with 2 decimal points or is this a
"redharring" and it's really complaning about the way Ingres 2006
handles money fields?

Any suggestions?

Thanks in advance,

Tyler

________________________________________________________
E_CO0039 COPY: Error processing row 16978. Cannot convert column
'accrl_dlr_amt' to tuple format.

E_US1131 exceeded the maximum money value allowed.

E_CO002B COPY: 1 rows could not be processed.

E_CO002A COPY: Copy has been aborted.

- Terminated by Errors
Ingres 2006 Version II 9.0.4 (int.lnx/104)NPTL logout
Mon Sep 11 19:35:02 2006

.



Relevant Pages

  • Re: An old version licence key problem
    ... no longer maintained and for which new Ingres company does not assume ... and money to get it working. ... the risk with the reward. ... try to keep your site as a customer, not as a money making venture. ...
    (comp.databases.ingres)
  • Re: Rounding in Ingres
    ... We're having to work in other datatypes besides money (which does round for us). ... I'd like avoid trying to manually round numbers. ... Subject: [Info-Ingres] Rounding in Ingres ...
    (comp.databases.ingres)
  • Re: [Info-ingres] Re: Treasures from afar
    ... Subject: [Info-ingres] Re: Treasures from afar ... Ingres for RoR should need to pay for support! ... The stuff about money was partly tongue in ...
    (comp.databases.ingres)
  • Re: copydb -c from VMS to Linux Money error.
    ... Unloading accross a NETU via SQL command from a VMS Ingres ... It's complaining on the reload about max money value. ... the data file should be in text. ... copy in, to dump rows which couldn't be copied into a separate file, ...
    (comp.databases.ingres)