Home > Cannot Use > Cannot Use Keyset Driven Cursor On Join With Distinct Clause

Cannot Use Keyset Driven Cursor On Join With Distinct Clause

Regards Vasu Post Reply Bookmark Topic Watch Topic New Topic Similar Threads Count query in oracle cursors SQL Error :Too few parameters. Index Register Login You are not logged in. Use aggregate function - eg sum() to show fact data for the same dimension range in BO. Using a slightly complicated SQL statement with an ORACLE ODBC connection, I am getting the following error message: SQL error: [Microsoft][ODBC driver for Oracle]Cannot use Keyset-driven cursor on join, with distinct http://homeshareware.com/cannot-use/cannot-use-keyset-driven-cursor-on-join.html

Microsoft-Supplied ODBC Drivers ODBC Driver for Oracle ODBC Driver for Oracle Programmer's Reference ODBC Driver for Oracle Programmer's Reference Limitations of Using Keyset-Driven Cursors Limitations of Using Keyset-Driven Cursors Limitations of Submit feedback to IBM Support 1-800-IBM-7378 (USA) Directory of worldwide contacts Contact Privacy Terms of use Accessibility Login with LinkedIN Or Log In Locally Email Password Remember Me Forgot Password?Register See ASP.NET Ajax CDN Terms of Use – http://www.asp.net/ajaxlibrary/CDN.ashx. ]]> FAQs Search RecentTopics FlaggedTopics HotTopics Best Topics Register / Other option is summing up the values in the database - in query time._________________Peter Csillag starschema.net ------------------------------ May the B B be with you!

The report layout: lawyer, holiday, training, worked hours, billed hours I created a dimension called "holiday" with the synatax as: CASE WHEN informix.matter.mmatter = '981001' THEN informix.timecard.tworkhrs ELSE 0 END 981001 Thank you in advance for your assistance. ---------------------------------------------------------------------- >Comment By: Chris Johnson (chaska) Date: 2003-09-09 22:37 Message: Logged In: YES user_id=279065 I am not sure where the problem lies, but it's Instead use the SQL statement CASE WHEN... Registration on or use of this site constitutes acceptance of our Privacy Policy.

select phase_id,0 work_package_id,0 activity_id,0 sub_activity_id,0 template_id,seq_no,phase_name name,1 level_id,null mandatory from phase_master union select phase_id,work_package_id,0,0,0,seq_no,work_package_name,2,mandatory from work_package_master union select wm.phase_id,am.work_package_id,am.activity_id,0,0,am.seq_no,am.activity_name,3 ,am.mandatory from activity_master am,work_package_master wm where am.work_package_id= wm.work_package_id union select wm.phase_id,wm.work_package_id,am.activity_id,sm.sub_activity_id,0,sm.seq_no,sm.sub_activity_name,4,sm.mandatory from Thank you in advance for your assistance. ---------------------------------------------------------------------- >Comment By: Chris Johnson (chaska) Date: 2002-09-06 10:40 Message: Logged In: YES user_id=279065 This is not a PHP or PHPLIB limitation, as far No, thanks CodeIgniter Forums CodeIgniter Forums > CodeIgniter Archived (from EllisLab) > Archived Development & Programming > cursor type in missing in ODBC driver Full Version: cursor type in missing in Thank you in advance for your assistance. ---------------------------------------------------------------------- Comment By: Nobody/Anonymous (nobody) Date: 2002-09-09 06:06 Message: Logged In: NO Thanks for your help !!

The error message looks like it was generated by a Microsoft ODBC driver, so I would suspect the ODBC driver as the most likely culprit. ---------------------------------------------------------------------- You can respond by visiting: Using the keyset cursor type with table aliases will cause the following error: "[Microsoft][ODBC driver for Oracle]Cannot use Keyset-driven cursor on join, with union, intersect or minus or on read only Resolving the problem Use an Oracle ODBC driver instead of the Microsoft ODBC for Oracle driver. read review The error message looks like it was generated by a Microsoft ODBC driver, so I would suspect the ODBC driver as the most likely culprit. ---------------------------------------------------------------------- You can respond by visiting:

I have changed the object to be a measure and to sum, and re-tried - this didn't work. The error message looks like it was generated by a Microsoft ODBC driver, so I would suspect the ODBC driver as the most likely culprit. ---------------------------------------------------------------------- You can respond by visiting: There can be a reason in a condition?Not so it in php I make out? 4 Reply by v zender 2012-07-01 08:09:04 v zender Member Offline Registered: 2012-06-30 Posts: 26 Re: Just wondering if it's a limitation in PHP or PHPLIB.

Close Reply To This Thread Posting in the Tek-Tips forums is a member-only feature. http://www.ibm.com/support/docview.wss?uid=swg21554392 You’ll be auto redirected in 1 second. Cannot use key-set driven cursor on join, with distinct clause, union, intersect, or minus on read only result set. In my odbc_connect i havent used cursor_type parameter.

James Back to top PeterCPrincipal MemberJoined: 14 Feb 2005Posts: 124Location: Hungary - or on the way Posted: Tue Aug 09, 2005 7:18 amPost subject: Re: Data error for dimensions Hi James, http://homeshareware.com/cannot-use/cannot-use-keyset.html Using a slightly complicated SQL statement with an ORACLE ODBC connection, I am getting the following error message: SQL error: [Microsoft][ODBC driver for Oracle]Cannot use Keyset-driven cursor on join, with distinct Please login or register. (PHP&SQL) SQL request through ODBC to an Oracle DB Programmer's Town »Web Programming »(PHP&SQL) SQL request through ODBC to an Oracle DB Pages 1 You must Can provide screen shots if that will help.

PHP Developers NetworkA community of PHP developers offering assistance, advice, discussion, and friendship. El Forum09-29-2010, 03:52 AM [eluser]umefarooq[/eluser] Hi today i try to connect oracle with CI using odbc driver it connected successfully but when i try to query from database i got the Close this window and log in. http://homeshareware.com/cannot-use/cannot-use-keyset-driven-cursor.html Top []InTeR[] Post subject: Posted: Wed May 07, 2003 2:18 am Forum Regular Joined: Thu Apr 24, 2003 6:51 amPosts: 416Location: The Netherlands Is the ODCB driver in

i am using aggregate(min,max,ceil,nvl) function in my sql query. Just wondering if it's a limitation in PHP or PHPLIB. Cannot use key-set driven cursor on join, with distinct clause... - Sterling Gentran:Server for Microsoft Windows STERLINGNFX Technote (troubleshooting) Problem(Abstract) Error 20732 Header query : ODBC Execution error.

It is necessary to see request to tell something defined.

Post Reply Bookmark Topic Watch Topic New Topic programming forums Java Java JSRs Mobile Certification Databases Caching Books Engineering Languages Frameworks Products This Site Careers Other all forums Forum: JDBC and Back to top jimbomedPrincipal MemberJoined: 09 Aug 2005Posts: 166Location: London, UK Posted: Tue Aug 09, 2005 10:08 amPost subject: Re: Data error for dimensions Thanks worked a treat ....Thank you. Do I need to change the object systax as well? Add Stickiness To Your Site By Linking To This Professionally Managed Technical Forum.Just copy and paste the BBCode HTML Markdown MediaWiki reStructuredText code below into your site. Business Objects solutions

Cannot use key-set driven cursor on join, with distinct clause, union, intersect, or minus on read only result set." Error Message Error 20732 Header query : ODBC Execution error. Please don't fill out this field. What am I doing wrong? this contact form Thank you in advance for your assistance. ---------------------------------------------------------------------- You can respond by visiting: https://sourceforge.net/tracker/?func=detail&atid=403612&aid=605267&group_id=31885 [Phplib-trackers] [ phplib-Support Requests-605267 ] ODBC error From: - 2002-09-06 15:40:53 Support Requests item #605267, was

Resources Join | Indeed Jobs | Advertise Copyright © 1998-2016 ENGINEERING.com, Inc. Create user object (in reporter level) holiday: sum(hours) where dimension = 'holiday' work: sum(hours) where dimension='work' drag and dropp to the report objects: lawyer, holiday, work Using aggregate function will cheat Dev centers Windows Office Visual Studio Microsoft Azure More... Watson Product Search Search None of the above, continue with my search Error 20732 Header query : ODBC Execution error.

One Search Engline 3 million Tech Posts, 15 Million Tech Replies Follow Us On Subscribe Email Submit 2016 © cornbio.com. Thank you in advance for your assistance. ---------------------------------------------------------------------- Comment By: Nobody/Anonymous (nobody) Date: 2002-09-09 06:06 Message: Logged In: NO Thanks for your help !! now go through the help and found that better to use SQL_CUR_USE_ODBC below one is correct and works fine for all my queries. Please don't fill out this field.

Warning: SQL error: [Microsoft][ODBC driver for Oracle]Cannot use Keyset-driven cursor on join, with distinct clause, union, intersect or minus or on read only result set, SQL state S1C00 in SQLExecDirect in THe troubling thing for me though is the same ODBC DSN works fine when used with ORACLE and other DB apps (Crystal Reports, etc.) ---------------------------------------------------------------------- Comment By: Chris Johnson (chaska) Date: Please don't fill out this field. Close Box Join Tek-Tips Today!

Moderator: General Moderators Page 1 of 1 [ 4 posts ] Print view Previous topic | Next topic Author Message saleemkhan Post subject: cannot use keyset-driven cursor join?Posted: Tue WHERE clauses of universe objects will always be logically ANDed. A keyset-driven cursor cannot be used on joins, queries, or statements that contain DISTINCT, GROUP BY, UNION, INTERSECT, or MINUS clauses.Also, if your application uses table aliases, keyset-driven cursors will not

Back to Top