All,

I am trying to create a LEFT OUTER JOIN in a businees view, right after save, it is saving as a inner join. could any one help me on how to add left outer join to Busness View?

Thanks
Ver. 7.7.01

quote:

LEFT OUTER JOIN in a businees view

Are you going for a SQL query or Join command?

Could you please post down your code here ?

Thanks Ram,
Here is the sample code, here i am trying to add left outer join instead of inner join(JOIN_WHERE) in of the following joins.

FILENAME=bv_starts_terms, SUFFIX=SQLMSS , $
SEGMENT=FACT_STARTS_TERMS, SEGTYPE=S0, $
FIELDNAME=OP_CO_GK, ALIAS=OP_CO_GK, USAGE=P13, ACTUAL=P7, $
FIELDNAME=COMPANY_GK, ALIAS=COMPANY_GK, USAGE=P13, ACTUAL=P7, $
FIELDNAME=BUSINESS_UNIT_GK, ALIAS=BUSINESS_UNIT_GK, USAGE=P13, ACTUAL=P7, $
FIELDNAME=PRODUCT_GK, ALIAS=PRODUCT_GK, USAGE=P13, ACTUAL=P7, $
FIELDNAME=SEGMENT_GK, ALIAS=SEGMENT_GK, USAGE=P13, ACTUAL=P7, $
FIELDNAME=OPR_UNT_GK, ALIAS=OPR_UNT_GK, USAGE=P13, ACTUAL=P7, $
FIELDNAME=CUST_GK, ALIAS=CUST_GK, USAGE=P13, ACTUAL=P7, $
FIELDNAME=REQ_POS_GK, ALIAS=REQ_POS_GK, USAGE=P13, ACTUAL=P7, $
FIELDNAME=CONTR_GK, ALIAS=CONTR_GK, USAGE=P13, ACTUAL=P7, $
FIELDNAME=ACTUAL_START_DATE_GK, ALIAS=ACTUAL_START_DATE_GK, USAGE=P13, ACTUAL=P7, $
FIELDNAME=START_TERM_IND_GK, ALIAS=START_TERM_IND_GK, USAGE=P13, ACTUAL=P7, $
FIELDNAME=PROJ_END_DATE_GK, ALIAS=PROJ_END_DATE_GK, USAGE=P13, ACTUAL=P7, $
FIELDNAME=REQ_ADJ_FLAG, ALIAS=REQ_ADJ_FLAG, USAGE=A1, ACTUAL=A1,
DESCRIPTION='Indicates whether the Start is due to a requisition adjustment in PeopleSoft and should not be counted as a true Start', $
FIELDNAME=LATE_START_FLAG, ALIAS=LATE_START_FLAG, USAGE=A1, ACTUAL=A1,
DESCRIPTION='Indicates whether the Start was entered into PeopleSoft late, after the contractor actually started working on the position', $
FIELDNAME=LATE_FINISH_FLAG, ALIAS=LATE_FINISH_FLAG, USAGE=A1, ACTUAL=A1,
DESCRIPTION='Indicates whether the Fnish/Termination was entered into PeopleSoft late, after the contractor actually stopped working on the position', $
FIELDNAME=INSERT_DTTM, ALIAS=INSERT_DTTM, USAGE=HYYMDs, ACTUAL=HYYMDs,
TITLE='Date/Time ?', DESCRIPTION='The timestamp when this row was inserted into the table', $
FIELDNAME=INSERT_BY, ALIAS=INSERT_BY, USAGE=A30V, ACTUAL=A30V,
TITLE='Inserted By', DESCRIPTION='The identifier of the process or user who inserted this row into the table', $
FIELDNAME=LAST_MOD_DTTM, ALIAS=LAST_MOD_DTTM, USAGE=HYYMDs, ACTUAL=HYYMDs,
MISSING=ON,
TITLE='Last Modified Date/Time', DESCRIPTION='The timestamp when this row was modified', $
FIELDNAME=LAST_MOD_BY, ALIAS=LAST_MOD_BY, USAGE=A30V, ACTUAL=A30V,
MISSING=ON,
TITLE='Last Modified By', DESCRIPTION='The identifier of the process or user who last modified this row in the table', $
FIELDNAME=BURDEN_PCT_SUM, ALIAS=BURDEN_PCT_SUM, USAGE=P7.2, ACTUAL=P8,
MISSING=ON, $
FIELDNAME=ACTUAL_END_DATE_GK, ALIAS=ACTUAL_END_DATE_GK, USAGE=P13, ACTUAL=P8,
MISSING=ON, $
FIELDNAME=START_TERM_LINK_GK, ALIAS=START_TERM_LINK_GK, USAGE=P13, ACTUAL=P8,
MISSING=ON, $
SEGMENT=DIM_COMPANY, SEGTYPE=KU, PARENT=FACT_STARTS_TERMS, CRFILE=ERA_IA/DIM_COMPANY, CRINCLUDE=ALL,
JOIN_WHERE=FACT_STARTS_TERMS.OP_CO_GK EQ DIM_COMPANY.COMPANY_GK;, $
SEGMENT=DIM_BUSINESS_UNIT, SEGTYPE=KU, PARENT=FACT_STARTS_TERMS, CRFILE=ERA_IA/DIM_BUSINESS_UNIT, CRINCLUDE=ALL,
JOIN_WHERE=FACT_STARTS_TERMS.BUSINESS_UNIT_GK EQ DIM_BUSINESS_UNIT.BUSINESS_UNIT_GK;, $
SEGMENT=DIM_PRODUCT, SEGTYPE=KU, PARENT=FACT_STARTS_TERMS, CRFILE=ERA_IA/DIM_PRODUCT, CRINCLUDE=ALL,
JOIN_WHERE=FACT_STARTS_TERMS.PRODUCT_GK EQ DIM_PRODUCT.PRODUCT_GK;, $
SEGMENT=DIM_SEGMENT, SEGTYPE=KU, PARENT=FACT_STARTS_TERMS, CRFILE=ERA_IA/DIM_SEGMENT, CRINCLUDE=ALL,
JOIN_WHERE=FACT_STARTS_TERMS.SEGMENT_GK EQ DIM_SEGMENT.SEGMENT_GK;, $
SEGMENT=DIM_OPERATING_UNIT, SEGTYPE=KU, PARENT=FACT_STARTS_TERMS, CRFILE=ERA_IA/DIM_OPERATING_UNIT, CRINCLUDE=ALL,
JOIN_WHERE=FACT_STARTS_TERMS.OPR_UNT_GK EQ DIM_OPERATING_UNIT.OPR_UNT_GK;, $
SEGMENT=DIM_CUSTOMER, SEGTYPE=KU, PARENT=FACT_STARTS_TERMS, CRFILE=ERA_IA/DIM_CUSTOMER, CRINCLUDE=ALL,
JOIN_WHERE=FACT_STARTS_TERMS.CUST_GK EQ DIM_CUSTOMER.CUST_GK;, $
SEGMENT=DIM_REQUISITION_POS, SEGTYPE=KU, PARENT=FACT_STARTS_TERMS, CRFILE=ERA_IA/DIM_REQUISITION_POS, CRINCLUDE=ALL,
JOIN_WHERE=FACT_STARTS_TERMS.REQ_POS_GK EQ DIM_REQUISITION_POS.REQ_POS_GK;, $
SEGMENT=DIM_CONTRACTOR, SEGTYPE=KU, PARENT=FACT_STARTS_TERMS, CRFILE=ERA_IA/DIM_CONTRACTOR, CRINCLUDE=ALL,
JOIN_WHERE=FACT_STARTS_TERMS.CONTR_GK EQ DIM_CONTRACTOR.CONTR_GK;, $
SEGMENT=FACT_STARTS_HISTORY, SEGTYPE=KU, PARENT=FACT_STARTS_TERMS, CRFILE=ERA_IA/FACT_STARTS_HISTORY, CRINCLUDE=ALL,
JOIN_WHERE=FACT_STARTS_TERMS.REQ_POS_GK EQ FACT_STARTS_HISTORY.REQ_POS_GK;, $
SEGMENT=DIM_CALENDAR_ACTUAL_START, SEGTYPE=KU, PARENT=FACT_STARTS_TERMS, CRFILE=ERA_IA/DIM_CALENDAR, CRSEGMENT=DIM_CALENDAR, CRINCLUDE=ALL,
JOIN_WHERE=ACTUAL_START_DATE_GK EQ DIM_CALENDAR_ACTUAL_START.DATE_GK;, $
SEGMENT=DIM_CALENDAR_ACTUAL_END, SEGTYPE=KU, PARENT=FACT_STARTS_TERMS, CRFILE=ERA_IA/DIM_CALENDAR, CRSEGMENT=DIM_CALENDAR, CRINCLUDE=ALL,
JOIN_WHERE=ACTUAL_END_DATE_GK EQ DIM_CALENDAR_ACTUAL_END.DATE_GK;, $
SEGMENT=DIM_CALENDAR_PROJECTED_END, SEGTYPE=KU, PARENT=FACT_STARTS_HISTORY, CRFILE=ERA_IA/DIM_CALENDAR, CRSEGMENT=DIM_CALENDAR, CRINCLUDE=ALL,
JOIN_WHERE=FACT_STARTS_HISTORY.PROJ_END_DATE_GK EQ DIM_CALENDAR_PROJECTED_END.DATE_GK;, $
SEGMENT=DIM_CALENDAR_EFF_END, SEGTYPE=KU, PARENT=FACT_STARTS_HISTORY, CRFILE=ERA_IA/DIM_CALENDAR, CRSEGMENT=DIM_CALENDAR, CRINCLUDE=ALL,
JOIN_WHERE=EFF_DATE_GK EQ DIM_CALENDAR_EFF_END.DATE_GK;, $
SEGMENT=DIM_STATUS_ST_IND, SEGTYPE=KU, PARENT=FACT_STARTS_TERMS, CRFILE=ERA_IA/DIM_STATUS, CRSEGMENT=DIM_STATUS, CRINCLUDE=ALL,
JOIN_WHERE=FACT_STARTS_TERMS.START_TERM_IND_GK EQ STATUS_GK;, $