How to use the update command

[svanels]

I am upscaling and restructuring an access db to interbase and ran into some problems

I succeded to move the existing data using the insert command but but on some big tables this does not work properly. I am splitting the tables up in smallar logical groups.
I have managed to move a part of a record (about 80% of the fields) to another table using:


insert into R_OIL(
RNUM ,
LVGO_SG, etc..)

select e.RNUM,
p.SG_LVGO, ..etc

from RSAMPLE e, OILPROPS p
where e.R_date = p.dat_


How do I update the other fields in R_OIL?
RNUM is a keyfield, thus inserting would generate a key violation.


Regards


Steven van Els
SAvanEls@cq-link.sr

 

[MartijnTonies]

Your question is not clear. Can you tell what you expected and what goes wrong?

Can you show a sample of the data?

Martijn Tonies
Database Workbench - the developer tool for InterBase, Firebird, MySQL & MS SQL Server

http://www.upscene.com

 

[svanels]

When I use the datapump utility I get a general SQL error, when moving the data from access to interbase on some tables, the tables are created in Interbase but data is not transferred. I suspect it has something to do with the column names used in access.

Leaving out some columns, data is transferred to interbase and then I use SQL to rearrange the tables and data.

Regards

Steven van Els
SAvanEls@cq-link.sr

 

[MartijnTonies]

Steven,

I have no idea what's going on. Please, at least show the DDL for the tables. I cannot help or give pointers without information. For you, it might be totally clear that "it doesn't work" - for me, and others, this isn't a question. Just a remark.

Again:
- what is it exactly that you're trying to do. What datapump?
- what is the table DDL?
- what is the exact error message and at what point does it happen?

Martijn Tonies
Database Workbench - the developer tool for InterBase, Firebird, MySQL & MS SQL Server

http://www.upscene.com

 

[svanels]

Sorted it out , I was getting an "arithmetic exception, numeric overflow, or string truncation" when upscaling, caused by some fields. Guess I just needed some time to relax.

Steven van Els
SAvanEls@cq-link.sr

 

[MartijnTonies]

Well, good to know you figure it out



Martijn Tonies
Database Workbench - the developer tool for InterBase, Firebird, MySQL & MS SQL Server

http://www.upscene.com

 

[svanels]

Ok the whole story,
Datapump is an utility from Borland to move data from one RDBMS to another, basically it reads the structure of a DBMS an recreates it in another.

I was upscaling an access database to interbase and ran into problems, the access table was indeed replicated in Interbase but the data was not moved.

The culprit: there were some fields in access named like

"Conductivity Return Condensate" that were replicated in IB to "Conductivity_Return_Condensate"

The word return caused some errors in the script generated to move the data.

Steven van Els
SAvanEls@cq-link.sr