Help on migrating oracle to db2, outerjoin# Database - 数据库
h*d
1 楼
Is there any outer join operator in DB2?
The following is one of my SQL statement:
CREATE OR REPLACE VIEW BANKREFERENCE_SEARCH_V ( CUSTOMERID,
CUSTOMERNAME, BANKNAME, REFERENCEDATE, ASSIGNEDTOSTR,
ASSIGNEDTO, FOLLOWUPDATE ) AS (
select distinct
customer.customerID as customerId,
customer.NAME as customerName,
br.NameOfInstitution as BankName,
br.referenceDate as ReferenceDate,
su.LastName || decode(nvl(br.assignedTo,-1),-1,'',', ') || su.
FirstName || decode(nvl(br.assignedTo,-1),-1,''
The following is one of my SQL statement:
CREATE OR REPLACE VIEW BANKREFERENCE_SEARCH_V ( CUSTOMERID,
CUSTOMERNAME, BANKNAME, REFERENCEDATE, ASSIGNEDTOSTR,
ASSIGNEDTO, FOLLOWUPDATE ) AS (
select distinct
customer.customerID as customerId,
customer.NAME as customerName,
br.NameOfInstitution as BankName,
br.referenceDate as ReferenceDate,
su.LastName || decode(nvl(br.assignedTo,-1),-1,'',', ') || su.
FirstName || decode(nvl(br.assignedTo,-1),-1,''