Skip to Content
avatar image
Former Member

JDBC table to table

снимок.jpgHello!
Need help in implementing this task (and setting up the mapping and SCL commands in communicational channel)
There are two tables in the PISANDBOX database
PERSWORK
PERSINFO

You must configure the transfer of new entries from the PERSWORK table to PERSINFO. New entries have the field NEW is NULL.
Configure Mapping:
1. FAM + NAME -> FULLNAME
2. If the HIREDATE is filled, then in STATE send "H", if FIREDATE, then "F"
3. Fill in the fields COMPANY, POSITION

The PERSWORK table is filled with data. The PERSINFO table is empty.

CREATE TABLE "PERSWORK"
( "PERNR" VARCHAR2(20) NOT NULL ENABLE,
"FAM" VARCHAR2(40),
"NAME" VARCHAR2(40),
"POSITION" VARCHAR2(40),
"COMPANY" VARCHAR2(40) NOT NULL ENABLE,
"HIREDATE" DATE,
"FIREDATE" DATE,
"NEW" VARCHAR2(20),
CONSTRAINT "PERSWORK_PK" PRIMARY KEY ("PERNR", "COMPANY") ENABLE
) ;

CREATE TABLE "PERSINFO"
( "PERNR" VARCHAR2(20) NOT NULL ENABLE,
"FULLNAME" VARCHAR2(80),
"POSITION" VARCHAR2(40),
"COMPANY" VARCHAR2(40),
"STATE" NVARCHAR2(20),
CONSTRAINT "PERSINFO_PK" PRIMARY KEY ("PERNR") ENABLE
) ;

снимок2.jpg

снимок2.jpg (172.8 kB)
снимок.jpg (238.3 kB)
Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

0 Answers