Powerhouse + Oracle-9i + AIX - Response issues

[Joe Boyle]

Just out of interest, how does the select below compare when run in sqlplus,
with the cursor as executed in Quiz, I

select * from imp_conn_files 
 where extracted in ('N','  ')  and 
 date_available >= 0 and date_available <= 20050901


I realize that you find choose/viaindex faster than the cursor in quiz, but
if sqlplus is equally slow, it must be down to the optimizer.

Regards, Joe.



-----Original Message-----
From: powerh-l-bounces+atla38=dsl.pipex.com at lists.sowder.com
[mailto:powerh-l-bounces+atla38=dsl.pipex.com at lists.sowder.com] On Behalf Of
Goparaju, Vidyasagar
Sent: 01 September 2005 15:49
To: Robert Edis
Cc: powerh-l at lists.sowder.com
Subject: RE: Powerhouse + Oracle-9i + AIX - Response issues

My SQL query thru SqlPlus works fine. But gives the following error in Quiz:

$ quiz auto=cur2.qzs
Q U I Z   (PowerHouse  8.43.D1)
Copyright 2005 COGNOS INCORPORATED
Licensed PH8-UNIX-RUNTIME-W-REPORTING for customer: 0007140001 GENERAL
MOTORS IU

> declare imp_conn cursor for &
> select /*+ index(imp_conn_files MASTER_CUST_EXTRACTED) */ * from
imp_conn_files &
> where extracted in ('N','  ')  and &
> date_available >= 0 and date_available <= 20050901
> access imp_conn
*E* Error parsing SQL statement.
DMS-E-GENERAL, A general exception has occurred during operation 'prepare
request'.
DMS-E-SS_SYNTAX, A syntax error was detected near '/'.


What is wrong with my cursor syntax? My intension is to use Index Hint.

Without the index hint, my query works fine. But it is taking longer than
simple quiz request with a choose viaindex.

Thanks very much
Sagar Goparaju


-----Original Message-----
From: powerh-l-bounces+vgoparaju=tradepointsystems.com at lists.sowder.com
[mailto:powerh-l-bounces+vgoparaju=tradepointsystems.com at lists.sowder.com]On
Behalf Of Robert Edis
Sent: Wednesday, August 31, 2005 8:20 PM
To: PH List
Subject: RE: Powerhouse + Oracle-9i + AIX - Response issues

You may have to do some logic recoding and push more of the work to the
database.  What I mean is writing cursors to use in the access statements.

Robert J Edis
Principal Consultant
Robert Edis Consulting
P.O. Box 676
Deerfield  IL  60015
USA
1 (847) 612-3863 - USA
61 (41) 549-1680 - Australia
RobEConsult at sbcglobal.net


  -----Original Message-----
  From: powerh-l-bounces+robeconsult=sbcglobal.net at lists.sowder.com
[mailto:powerh-l-bounces+robeconsult=sbcglobal.net at lists.sowder.com]On
Behalf Of Goparaju, Vidyasagar
  Sent: Wednesday, August 31, 2005 4:11 PM
  To: powerh-l at lists.sowder.com
  Subject: Powerhouse + Oracle-9i + AIX - Response issues


  We are in the process of migration from AS400 Powerhouse to Powerhouse on
AIX under Oracle environment.



  We have successfully converted our application and almost ready for the
production move. But we have been experiencing response issues. Powerhouse
under Oracle environment is relatively very slow.



  Any of you have gone thru similar issues when migrated to Oracle
environment? What steps have you taken to improve the response? We have a
huge Cobol routine that runs off of our quick screens using DO EXTERNAL.
That is also taking longer time and a big concern to our clients.



   Please let me know if you have any suggestions or information.



  Thanks very much

  Sagar Goparaju
  TradePoint Systems



  STATEMENT OF CONFIDENTIALITY:
  The information contained in this electronic message is intended for the
exclusive use of the addressee(s) and may contain confidential information.
If you are not the intended recipient of this email, be advised you have
received this message in error and that any use, dissemination, forwarding,
printing, or copying is strictly prohibited.  Please notify TradePoint
Systems LLC immediately at (603) 889-3200 and destroy all copies of this
message and any attachments.


--
= = = = = = = = = = = = = = = = = = = = = = = = = = = =
Mailing list: powerh-l at lists.sowder.com
Subscribe: "subscribe" in message body to powerh-l-request at lists.sowder.com
Unsubscribe: "unsubscribe &lt;password&gt;" in message body to
powerh-l-request at 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.

-- 
= = = = = = = = = = = = = = = = = = = = = = = = = = = =
Mailing list: powerh-l at lists.sowder.com
Subscribe: "subscribe" in message body to powerh-l-request at lists.sowder.com
Unsubscribe: "unsubscribe &lt;password&gt;" in message body to
powerh-l-request at 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.