[Date Prev][Date Next][Thread Prev][Thread Next]
[Author Index] [Date Index] [Thread Index]
[SQR-USERS Info] [SQRUG Home Page]

Re: [sqr-users] [Microsoft][ODBC driver for Oracle]Cannotuse Keyset-driven cursor on join, with distinct clause, union,intersect or minus or on read only result set

Hi Harvinder,

The SQL looks good.  However, you need to remove the word "SELECT" and 
place within a begin-select procedure per SQR standards.

Don

> Hi 
> 
> 
> 
> I am running a following query 
> 
> 
> 
> SELECT DISTINCT AL1.SUB_ACCT_NO_WOC,AL1.LS_CHG_DTE_WOC FROM 
> 
> WOC_BASE_COMP AL1, WOS_SERV_CODE AL2
> 
> WHERE AL1.SYS_WOC=AL2.SYS_WOS  AND 
> 
> AL2.SERV_NET_CHG_WOS=1 AND 
> 
> AL2.SERV_CDE_WOS='RT' AND 
> 
> AL1.LS_CHG_DTE_WOC between sysdate-8 and sysdate-2;
> 
> 
> 
> 
> 
> Through SQR which is Giving the following 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
> 
> My SQR Version is 8.3
> 
> My Oracle version is 9.2
> 
> I am using ODBC Driver version 5.75.1117.00 for connecting to Oracle.
> 
> 
> 
> Can any one provide me a solution for this?
> 
> 
> 
> 
> 
> Regards,
> 
> Harvinder Singh Narang

_______________________________________________
sqr-users mailing list
sqr-users@sqrug.org
http://www.sqrug.org/mailman/listinfo/sqr-users