Problems Powerhouse WEB and CONNX

[Joe Boyle]

I'm pretty sure that connx maps to RMS btree type index files, so I'm
surprised that this SQL form of select syntax works at all. 

The only performance level equivalent would be where field NAME was an index
segment and using syntax - access via name using "CONNX@".

If it isn't an index you would have to use SELECT IF syntax, but this will
not be as efficient as the SQL equivalent.


Regards, Joe.

This e-mail and all information contained in it is confidential and may be
legally privileged. If you are not the intended recipient, your access to
this e-mail is unauthorized. Any use, dissemination, distribution,
publication or copying by you of this e-mail or any of the information
contained within it is prohibited and may be unlawful. Do not open any
attachments, delete it immediately from your system and notify the sender
promptly by e-mail that you have done so. The content of this 
e-mail and any attachments sent with it may have been altered without the
consent or knowledge of the author.

-----Original Message-----
From: powerh-l-admin@lists.sowder.com
[mailto:powerh-l-admin@lists.sowder.com] On Behalf Of VAN DE MEERSSCHE Marc
Sent: 03 December 2004 07:28
To: 'powerh-l@lists.sowder.com'
Subject: Problems Powerhouse WEB and CONNX

>Hi, 
>
>Since we made an upgrade from ODBC CONNX 6.5 to CONNX 9, we encountered
>problems with SELECT's containing generic characters. 
>
>Our application is written in Cognos POWERHOUSE 8.23 and rurns with
>PowerHouse Web 2.21 on a IIS server. 
>An ODBC-connection to an ALPHA OpenVMS 6.2.1.H.3 is made with CONNX9.
>
>Unfortunatly, on a search containing a wildcard character (ex: SELECT NAME
>FROM TABLENAME WHERE NAME like "CONNX%"), we got all the lines where the
>name begins with CONNX, but not the lines where the names are exactly equal
>to CONNX.
>
>After the attempts which we carried out: 
>- in CONNX 6.5 and PHWeb: the problem does not occur.
>- in CONNX 9 and PHWeb: the problem occurs. 
>- IN CONNX 9 with CONNX Infonaut: the problem does not occur.
>
>Does anyone has already the same problem ?
>
>Regards,
>Marc Van de Meerssche
>Nationale Suisse Insurances, Belgium
>
>PS: We have verified if the problem also occurs with PowerHouse 8.41, and
>the problem is identical with the old version. 
>
>  
>
= = = = = = = = = = = = = = = = = = = = = = = = = = = =
Mailing list: powerh-l@lists.sowder.com
Subscribe: "subscribe" in message body to powerh-l-request@lists.sowder.com
Unsubscribe: "unsubscribe <password>" in message body to
powerh-l-request@lists.sowder.com
http://lists.sowder.com/mailman/listinfo/powerh-l
This list is closed, thus to post to the list you must be a subscriber.