R3load insert

[Former Member]

Hi all,

I have one doubt.How does R3load insert the values in a heterogeous system copy when we are changing the database.We have few rows that have been exported by r3load for oracle database target database is sql server.How dows insert of data happens in db2 or sql server.How are the sql statements for insertion generated.Thanks.

[markus_doehr2 · Accepted solution]

> I have one doubt.How does R3load insert the values in a heterogeous system copy when we are changing the database.We have few rows that have been exported by r3load for oracle database target database is sql server.How dows insert of data happens in db2 or sql server.How are the sql statements for insertion generated.Thanks.

R3load uses the STR files to create the tables with the DDL statement in the corresponding DDL<DATABASE>.TPL file. Then it inserts the data from the PACKAGENAME.xxx files.

Since the R3load is database dependent and it uses the corresponding DDL file an export is database and operating system independent.

Markus

[Former Member · Accepted solution]

Hi Markus,

Thanks as always your response is just too good.

So does this mean that r3ldctl will generate the dml commands for insertion of data for the target database or else r3load understands and inserts the data.Dump data is independant of os and db right but how where does the insert command come from create command is there in ddl<dbs>.tpl file but there is no insert command.How does r3load get the command insert.Thanks.

[markus_doehr2 · Accepted solution]

> How does r3load get the command insert.Thanks.

This is done programatically, not through scripts. R3load uses the database interface functions of each database to do those inserts.

Markus

[Former Member · Accepted solution]

Hi Markus,

Thanks a ton.