[Antelope] Forcibly Adding Records with matching keys

Hank Ratzesberger hankr at icess.ic.ucsb.edu
Thu Dec 17 16:45:45 CST 2009


Hi,

My question:

I am copying tables from one database to another, with some
transformations in the process.

How can add records even when they break the primary/secondary keys?
It's not clear to me if/how I can do this.  A snippet would be great.
It is not clear if calling dbaddv() for each column will format
the data properly, and if dbput() will attempt to enforce the
uniqueness checks.

dbaddnull()
dbput()

Thank you,

P.S. If you are curious why I am doing this:

I need to mash up a database so that the station names we collected  
under
(GVA01, GVA02, etc) are all the same (GVDA).  Along with various sensor
and datalogger changes, this means that some records no longer fit the
schema.  But the location part of the channel is unique so I know I can
do this for my limited purposes.



Hank Ratzesberger
NEES at UCSB
Institute for Crustal Studies,
University of California, Santa Barbara
805-893-8042








More information about the Antelope mailing list