Livelink DB and views - TODO VIEW - (+) sign???

Can ansyone comment what does sign (+) mean while working with Livelink Database?You will come across it if you look at the SQL for TODOview -CREATE OR REPLACE VIEW TODO ( WORK_WORKID, WORK_OWNERID, WORK_MANAGERID, WORK_STATUS, WORK_OWNERPERMS, SUBWORK_SUBWORKID, SUBWORK_TITLE, SUBWORK_STATUS, SUBWORKTASK_TASKID, SUBWORKTASK_PERFORMERID, SUBWORKTASK_TITLE, SUBWORKTASK_DATEMILESTONE, SUBWORKTASK_DATEDUE_MAX, SUBWORKTASK_DATEREADY, MAPTASK_STARTDATE, MAPTASK_TYPE, MAPTASK_SUBTYPE, WORK_OWNERID_NAME, WORK_MANAGERID_NAME, SUBWORKTASK_PERFORMERID_NAME ) AS select TodoBase.*, a.Name Work_OwnerID_Name, b.Name Work_ManagerID_Name, c.Name SubWorkTask_PerformerID_Namefrom TodoBase, KUAF a, KUAF b, KUAF c where Work_OwnerID=a.ID(+) and Work_ManagerID=b.ID(+) and SubWorkTask_PerformerID=c.ID(+) Any comments much appreciated.

Find more posts tagged with

Comments

Hans_Stoop_(hstoop_(Delete)_1579932)

Message from Hans Stoop <<A HREF="mailto:hstoop@opentext.com">hstoop@opentext.com> via eLink

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">eLink

That specifes an outer-join. See you DB documentation for details.

The (+) syntax is Oracle specific.

Hans

-----Original Message-----
From: eLink Discussion: Development Discussion [mailto:development@elinkkc.opentext.com]
Sent: maandag 6 oktober 2003 18:37
To: eLink Recipient
Subject: Livelink DB and views - TODO VIEW - (+) sign???

Livelink DB and views - TODO VIEW - (+) sign??? Posted by BRITANNIAAdmin (Gough, John ) on 10/06/2003 12:32 PM

Can ansyone comment what does sign (+) mean while working with Livelink Database?

You will come across it if you look at the SQL for TODO
view -

CREATE OR REPLACE VIEW TODO ( WORK_WORKID,
WORK_OWNERID, WORK_MANAGERID, WORK_STATUS, WORK_OWNERPERMS,
SUBWORK_SUBWORKID, SUBWORK_TITLE, SUBWORK_STATUS, SUBWORKTASK_TASKID,
SUBWORKTASK_PERFORMERID, SUBWORKTASK_TITLE, SUBWORKTASK_DATEMILESTONE, SUBWORKTASK_DATEDUE_MAX,
SUBWORKTASK_DATEREADY, MAPTASK_STARTDATE, MAPTASK_TYPE, MAPTASK_SUBTYPE,
WORK_OWNERID_NAME, WORK_MANAGERID_NAME, SUBWORKTASK_PERFORMERID_NAME ) AS select
TodoBase.*, a.Name Work_OwnerID_Name, b.Name Work_ManagerID_Name, c.Name SubWorkTask_PerformerID_Name
from TodoBase, KUAF a, KUAF b, KUAF c
where Work_OwnerID=a.ID(+) and Work_ManagerID=b.ID(+) and
SubWorkTask_PerformerID=c.ID(+)

Any comments much appreciated.

Jonny_Coombes

Message from Jonny Coombes <<A HREF="mailto:jcoombes@opentext.com">jcoombes@opentext.com> via eLink

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">eLink

In Oracle SQL dialect, the (+) sign denotes an OUTER join.

Cheers

Jonny Coombes
Principal Solutions Architect
Global Services
Opentext Corporation

Tel : +44 (0)1494 679700
Mobile: +44 (0)7748 986937
Email : jcoombes@opentext.com

From: eLink Discussion: Development Discussion [mailto:development@elinkkc.opentext.com]
Sent: 06 October 2003 17:37
To: eLink Recipient

Livelink DB and views - TODO VIEW - (+) sign???
Posted by BRITANNIAAdmin (Gough, John ) on 10/06/2003 12:32 PM

Can ansyone comment what does sign (+) mean while working with Livelink Database?

You will come across it if you look at the SQL for TODO
view -

CREATE OR REPLACE VIEW TODO ( WORK_WORKID,
WORK_OWNERID, WORK_MANAGERID, WORK_STATUS, WORK_OWNERPERMS,
SUBWORK_SUBWORKID, SUBWORK_TITLE, SUBWORK_STATUS, SUBWORKTASK_TASKID,
SUBWORKTASK_PERFORMERID, SUBWORKTASK_TITLE, SUBWORKTASK_DATEMILESTONE, SUBWORKTASK_DATEDUE_MAX,
SUBWORKTASK_DATEREADY, MAPTASK_STARTDATE, MAPTASK_TYPE, MAPTASK_SUBTYPE,
WORK_OWNERID_NAME, WORK_MANAGERID_NAME, SUBWORKTASK_PERFORMERID_NAME ) AS select
TodoBase.*, a.Name Work_OwnerID_Name, b.Name Work_ManagerID_Name, c.Name SubWorkTask_PerformerID_Name
from TodoBase, KUAF a, KUAF b, KUAF c
where Work_OwnerID=a.ID(+) and Work_ManagerID=b.ID(+) and
SubWorkTask_PerformerID=c.ID(+)

Any comments much appreciated.