Linking problem in 7.10G

[arthur kogan]

Hi Alex,

I have another suggestion. Since you are using a relational database, why not
use its features. Why not create another column of type long for each column of
type short that gives you problems. Create triggers that would update these
columns at the same time that the "short" column changes and create extra
indexes to use the long instead of short. Yes, this will increase the size of
the database, and yes you will still need to make some changes to your code,
however these changes should be quite minor, as you will then be able to link
either using "short" OR "long", so no temps/defines need changing.

Regards,

Arthur Kogan
Westpac Financial Services
Sydney, Australia

alex ling wrote:

> Thanks for the two-pass/subfile workaround suggestion for an OPTIONAL
> link. It would be nice and easy if the "LONG-ITEM to SHORT-ITEM"
> linkage is the first linkage in the ACCESS statement like in your
> example. What if the linkage is the some 10th linkage in the ACCESS
> statement? What if there are more than one such linkage in one ACCESS
> statement? This will give us nightmare in handing it with a subfile in
> the two-pass/subfile approach. Then there is performance issue to
> consider. With the number of QTP/QUIZ programs we have here it is
> going to be hell for us.
>
> Bob, we prefer to change the SHORT-ITEM to LONG-ITEM so that the
> linkage will become "LONG-ITEM to LONG-ITEM". What do you think? Any
> advice on the implication as a result of the change from a 2-byte to a
> 4-byte?
>
> Thanks,
> A Ling.
>
> ---"Deskin, Bob" <Bob.Deskin@Cognos.COM> wrote:
> >
> > I don't know if this has been suggested as a workaround, but Allison
> > suggested using a SELECT file IF so select out values that are too
> high. In
> > other words:
> >
> > access A link LONG-ITEM to SHORT-ITEM of B
> > select A if long-item < 32768
> >
> > If the test fails, the link won't even be attempted.
> >
> > If LONG-ITEM is an index/segment, you could also use a CHOOSE. If
> you needed
> > an OPTIONAL link such that you want A even if the link won't work,
> then you
> > need two passes. Do one like the above and write the results to a
> subfile.
> > Then do another pass reversing the select and without the LINK TO
> like this:
> >
> > access A
> > select A if long-item > 32767
> >
> > and append the results to the subfile with appropriate defined default
> > values for the missing items. Then access the subfile and report or
> > whatever.
> >
> > Bob Deskin
> > Senior Product Advisor  bob.deskin@cognos.com
> > Cognos Inc.             (613) 738-1338 ext 4205 FAX: (613) 228-3149
> > 3755 Riverside Drive P.O. Box 9707 Stn. T, Ottawa ON K1G 4K9 CANADA
> >
> _________________________________________________________
> DO YOU YAHOO!?
> Get your free @yahoo.com address at http://mail.yahoo.com
>
> = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = =
> Subscribe: "subscribe powerh-l" in message body to majordomo@lists.swau.edu
> Unsubscribe: "unsubscribe powerh-l" in message to majordomo@lists.swau.edu
> powerh-l@lists.swau.edu is gatewayed one-way to bit.listserv.powerh-l
> This list is closed, thus to post to the list, you must be a subscriber.



= = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = =
Subscribe: "subscribe powerh-l" in message body to majordomo@lists.swau.edu
Unsubscribe: "unsubscribe powerh-l" in message to majordomo@lists.swau.edu
powerh-l@lists.swau.edu is gatewayed one-way to bit.listserv.powerh-l
This list is closed, thus to post to the list, you must be a subscriber.