-- Create HANA table
CREATE TABLE STUDENTS (
"S_ID" VARCHAR(3), "S_NAME" VARCHAR(20), "S_DEPT" VARCHAR(30)
);
-- load in some dummy data
insert into STUDENTS values ( 'S01', 'Partha', 'SAP' );
insert into STUDENTS values ( 'S02', 'John', 'Microsoft' );
insert into STUDENTS values ( 'S03', 'Mili', 'AWS' );
-- create the HDL table
call "SYSRDL#CG".REMOTE_EXECUTE('
drop table if exists STUDENTS;
CREATE TABLE STUDENTS (
"S_ID" VARCHAR(3), "S_NAME" VARCHAR(20), "S_DEPT" VARCHAR(30) );
');
-- creates the HANA SDA table for the table created above
-- HDL uses SYSRDL#CG for every remote database
-- HDL uses SYSRDL#CG_SOURCE for every remote server
-- "<NULL>" is just a dummy placeholder as IQ/HDL ignore this parameter anyway
CREATE VIRTUAL TABLE VT_HDL_STUDENTS AT "SYSRDL#CG_SOURCE"."<NULL>"."SYSRDL#CG"."STUDENTS";
-- get counts and make sure virtual table works
select 'HANA cnt: ' || count(*) from STUDENTS;
select 'HDL Virtual Table cnt: ' || count(*) from VT_HDL_STUDENTS;
-- copy data
insert into VT_HDL_STUDENTS select * from STUDENTS;
-- Get final counts to see that they are the same
select 'HANA cnt: ' || count(*) from STUDENTS;
select 'HDL Virtual Table cnt: ' || count(*) from VT_HDL_STUDENTS;
-- create HANA table
CREATE TABLE STUDENTS (
"S_ID" VARCHAR(3), "S_NAME" VARCHAR(20), "S_DEPT" VARCHAR(30)
);
-- load in some dummy data
insert into STUDENTS values ( 'S01', 'Partha', 'SAP' );
insert into STUDENTS values ( 'S02', 'John', 'Microsoft' );
insert into STUDENTS values ( 'S03', 'Mili', 'AWS' );
-- create the HDL table
call "SYSRDL#CG".REMOTE_EXECUTE('
drop table if exists STUDENTS;
CREATE TABLE STUDENTS (
"S_ID" VARCHAR(3), "S_NAME" VARCHAR(20), "S_DEPT" VARCHAR(30) );
');
-- creates the HANA SDA table for the table created above
-- HDL uses SYSRDL#CG for every remote database
-- HDL uses SYSRDL#CG_SOURCE for every remote server
-- "<NULL>" is just a dummy placeholder as IQ/HDL ignore this parameter anyway
CREATE VIRTUAL TABLE VT_HDL_STUDENTS AT "SYSRDL#CG_SOURCE"."<NULL>"."SYSRDL#CG"."STUDENTS";
-- get counts and make sure virtual table works
select 'HANA cnt: ' || count(*) from STUDENTS;
select 'HDL Virtual Table cnt: ' || count(*) from VT_HDL_STUDENTS;
-- copy data
insert into VT_HDL_STUDENTS select * from STUDENTS;
-- get final counts to see that they are the same
select 'HANA cnt: ' || count(*) from STUDENTS;
select 'HDL Virtual Table cnt: ' || count(*) from VT_HDL_STUDENTS;