Skip to Content
0

Copy Data from virtual table to another virtual table.

Nov 24, 2016 at 03:39 PM

40

avatar image
Former Member

Hi guys,

Here is a scenario in which I'm having data in one virtual table named 'VT1'. This VT1 table is getting updated by one CV.

My requirement is to update an another virtual table named 'VT2' from the data available in table VT1. Both the table is having same structure.

I tried to use a simple INSERT statement which is

INSERT INTO "VT2" (SELECT * FROM "VT1");

But this statement is giving error like..... SAP DBTech JDBC: [403]: internal error: Error executing query [Oracle][ODBC]Invalid datetime format. for query " INSERT INT......"

VT1 table definition is like Field1(varchar 56), Field2(varchar 100), Field3(timestamp), Field4(varchar 2000), Field5(varchar 2000), Field6(timestamp), Field7(varchar 2000), Field8(varchar 80), Field9(timestamp),Field10(varchar 80), Field11(timestamp)

Any suggestions here, expert @lars.breddemann @thomas.jung? Sincere thanks in advance.

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

1 Answer

Timo Wagner
Nov 29, 2016 at 08:29 PM
0

Hi Saurabh,

for me it seems like the schema of VT1 is not exactly matching the one of VT2. (Column Names, Datatypes etc.)

Can you please have a look at that? It might be that you need to do some transformation ontop of VT1 so that it produces valid output for VT2.

Thanks,

Timo Wagner

Share
10 |10000 characters needed characters left characters exceeded