Hi Folks,
I was trying to give outer join between two tables, but the outer join box was grayed out. I looked at the PRM files, it says OUTERJOIN_GENERATION=DB2 I am working on DB2
______________________________________________________ Get Your Private, Free Email at http://www.hotmail.com
Listserv Archives (BOB member since 2002-06-25)
Hi Folks,
I was trying to give outer join between two tables, but the outer join box was grayed out. I looked at the PRM files, it says OUTERJOIN_GENERATION=DB2. I am working on DB2 and BO 5.0. Any Ideas folks?
Thanks
Ravi.
______________________________________________________ Get Your Private, Free Email at http://www.hotmail.com
Listserv Archives (BOB member since 2002-06-25)
Ravi,
Check the driver you are using. does it support Outer joins?
Vasan
businessobject@HOTMAIL.COM on 03/23/2000 01:08:52 PM
Hi Folks,
I was trying to give outer join between two tables, but the outer join box was grayed out. I looked at the PRM files, it says OUTERJOIN_GENERATION=DB2. I am working on DB2 and BO 5.0. Any Ideas folks?
Thanks
Ravi.
******************************************************************************* Note: The information contained in this message may be privileged and confidential and protected from disclosure. If the reader of this message is not the intended recipient, or an employee or agent responsible for delivering this message to the intended recipient, you are hereby notified that any dissemination, distribution or copying of this communication is strictly prohibited. If you have received this communication in error, please notify us immediately by replying to the message and deleting it from your computer. Thank you. Ernst & Young LLP
Listserv Archives (BOB member since 2002-06-25)
If you are attempting to modify an existing complex join (join on multiple columns) try deleting the join and recreating it from scratch. I find the outer join option is not greyed out when creating a join, but it is always greyed once I have saved a complex join. It doesn’t get greyed out when attempting to modify a simple join.
We are using CAE 5.2 BO 4.1.4
John.
Listserv Archives (BOB member since 2002-06-25)
Is this a complex join (i.e. joining on more than one column)? To identify, check the Cardinality box located between the two table list boxes (not the same as the Cardinality check box). If your join is complex this box will read “Complex”.
We’ve experience this on joins which are complex in nature. To get around it, manually edit your join (double-click on join) and remove all but one of the column joins within the Edit Join Expressions box (do not save your join yet). The outer join check boxes should now be visible. Click the appropriate outer join box for the specified table. After doing this, the fields you removed previously will magically reappear in the expressions box and the outer join check box options will be greyed out once again. If you’ve chosen the wrong table to outer join (verify by reviewing the Cardinality options area, which is under the “Detect” button located in the center of the Edit Join window), simply repeat the process.
Hope this helps.
Russ Coble
Information Technology Analyst
John Deere Credit - Des Moines
Phone: (515) 267-3794
E-Mail: CobleRussell@JDCorp.deere.com
From: Business Objects [SMTP:businessobject@HOTMAIL.COM] Sent: Thursday, March 23, 2000 12:03 PM
Hi Folks,
I was trying to give outer join between two tables, but the outer join box was grayed out. I looked at the PRM files, it says OUTERJOIN_GENERATION=DB2. I am working on DB2 and BO 5.0. Any Ideas folks?
Thanks
Ravi.
______________________________________________________ Get Your Private, Free Email at http://www.hotmail.com
Pls report bounces in response to postings to BUSOB-L-Request@listserv.aol.com
Web archives (24 hrs. a day now!): listserv.aol.com/archives/busob-l.html
OR search: Mail to listserv@listserv.aol.com, ‘search a_phrase in BUSOB-L’
Unsubscribe: Mail to listserv@listserv.aol.com, ‘unsubscribe BUSOB-L’
Listserv Archives (BOB member since 2002-06-25)
On Wed, 29 Mar 2000 16:52:10 -0600, Coble Russell CobleRussell@JDCORP.DEERE.COM wrote:
We’ve experience this on joins which are complex in nature. To get
around it, manually edit your join (double-click on join) and remove all but one of the column joins within the Edit Join Expressions box (do not save your join yet). The outer join check boxes should now be visible. Click the appropriate outer join box for the specified table. After doing this, the fields you removed previously will magically reappear in the expressions box and the outer join check box options will be greyed out once again. If you’ve chosen the wrong table to outer join (verify by reviewing the Cardinality options area, which is under the “Detect” button located in the center of the Edit Join window), simply repeat the process.
We also had to go through these gyrations with complex outer joins with other RDBMS engines (MS SQL SERVER 7 & PROGRESS), and found that adding EXT_JOIN=YES and OUTERJOINS_COMPLEX to the .prm solved the problem. The oj check box is now always available even for subsequent editting of the join, all of the fields participating in the complex join are retained properly, and everything works as one would expect.
You may want to try this for DB2 to see if this might help.
Incidently, for MS SQL SERVER 7 we found that putting OUTERJOINS_GENERATION=DB2 in the .prm generates “better” SQL for complex joins by moving conditions to the “FROM” clause instead of the “WHERE” clause … and at least on BusObj 4.1.4 (which doesn’t have native BusObj SQL 7 Support) this gave us the best solution.
…rick
Listserv Archives (BOB member since 2002-06-25)
On Thu, 30 Mar 2000 09:17:55 -0500, Rick Kurzawa rickk@BOARTLONGYEAR.COM wrote:
and found that adding EXT_JOIN=YES and OUTERJOINS_COMPLEX to the .prm
Whoops! I had a typo on this message.
I meant to say OUTERJOINS_COMPLEX=Y.
Sorry 'bout that.
…rick
Listserv Archives (BOB member since 2002-06-25)
Where can I find a list of the .prm file add-ins?
Kathy Vazquez
Listserv Archives (BOB member since 2002-06-25)
On Thu, 30 Mar 2000 10:19:40 -0600, Vazquez, Kathy A kathy.vazquez@EDS.COM wrote:
Where can I find a list of the .prm file add-ins?
Tucked away in the APPENDIX in the RDBMS documentation.
On BusObj 4.1.4 CD, go to \manuals\english\english.pdf which is the launcher for the English Documentation in ADOBE ACROBAT format. Select RDBMS, then your DB engine. For DB2, go to APPENDIX A and you’ll see some .prm files where the parameters are explained.
Very educational to review the parameters available for ALL RDBMS.
…be careful though. These parameters carry a lot of weight and setting (and MISSETTING) them can result in “surprising” effects.
…rick
Listserv Archives (BOB member since 2002-06-25)