Conference orarep::nomahs::dbstars

791.0. "-NSDS-E-APGENERROR -NSDS-F-INTERRIDFN errors" by BROKE::GREEN () Thu Jun 05 1997 14:51

Copyright (c) 1997 by Oracle Corporation.  All Rights Reserved.

KEYWORDS: -NSDS-E-APGENERROR -NSDS-F-INTERRIDFN 

TITLE:    -NSDS-E-APGENERROR -NSDS-F-INTERRIDFN errors with Rdb gateway to RMS


PRODUCT:  Rdb Transparent Gateway for RMS V3.1E

OP/SYS:   OpenVMS VAX or AXP

SOURCE:   Oracle Worldwide Customer Support


SYMPTOM: A SQL query results in these errors:

%RDB-F-SYS_REQUEST, error from system services request
-NSDS-E-APGENERROR, QO failed to generate a Access Plan for the request
-NSDS-F-INTERRIDFN, Internal error detected (code 70223060) - please submit an S
PR
-NSDS-F-INTERRIDFN, Internal error detected (code 3) - please submit an SPR


RESPONSE:  This is bug number 502116.


WORKAROUND: The problem is that Rdb TG/RMS V3.1E and earlier cannot handle
            this type of a SQL query:

            SELECT COUNT(some_column_name)

            COUNT(*) works fine.  If you are doing a join the only way to
            capture the cardinality of one of the tables is to use a column
            name from that table in the COUNT parenthesis.  If the table is
            an indexed table with a single segmented primary key then 
            specifying the primary key column will give you the cardinality
            if you also use the DISTINCT reserved word:

            SELECT COUNT(DISTINCT primary_key_name) 



\
\ CONTRIBUTORS:
\
\	Technical: Don Green
\	Editorial: 
\
\