[Search for users] [Overall Top Noters] [List of all Conferences] [Download this site]

Conference orarep::nomahs::dbstars

Title:	DBSTARS Conference

Moderator:	BROKE::BASTINE

Created:	Wed Feb 02 1994
Last Modified:	Thu Jun 05 1997
Last Successful Update:	Fri Jun 06 1997
Number of topics:	791
Total number of notes:	1521

782.0. "SQS only supports 500 columns" by BROKE::BITHER () Tue May 13 1997 12:45

From:	BROKE::GREEN        13-MAY-1997 11:00:46.73
To:	GREEN,DIANE
CC:	GREEN
Subj:	SQL/Services only supports up to 500 columns

From:	BROKE::BASTINE      "please reply to [email protected]" 13-MAY-1997 10:52:20.10
To:	green
CC:	BASTINE
Subj:	Did you see this?  


         <<< NOMAHS::DISK$NOMAHS1:[NOTES$LIBRARY]SQL_SERVICES.NOTE;1 >>>
                            -< SQL/Services Forum >-
================================================================================
Note 2201.4                 ACCVIO during large query                     4 of 4
SQLSRV::MAVRIS "Sue Mavris - [email protected]"   5 lines  13-MAY-1997 09:35
                           -< limit of 500 columns >-
--------------------------------------------------------------------------------
This shouldn't cause an accvio, but SQL/Services can only handle 500 columns. 
I'm not sure if this is documented anywhere... but it has always been the 
case.

Sue

T.R Title User Personal
Name Date Lines

782.1 Final - sent to Mem 5/21/97 BROKE::BITHER Wed May 21 1997 08:49 38

T.R	Title	User	Personal Name	Date	Lines
782.1	Final - sent to Mem 5/21/97	BROKE::BITHER		`Wed May 21 1997 08:49`	38
	From: BROKE::BITHER "Please reply to [email protected]" 21-MAY-1997 07:48:47.81 To: MEMORMAN CC: BITHER Subj: New Stars Article TITLE: SQL/Services Supports up to 500 Columns in a Query PRODUCT: SQL/Services (all versions) OP/SYS: OpenVMS VAX, OpenVMS AXP SOURCE: Oracle Worldwide Customer Support PROBLEM: You are using a PC query tool and SQL/Services to access an Oracle Rdb database or an Oracle Rdb Distributed Option database. Accessing the database results in a SYSTEM-F-ACCVIO access violation. PROBLEM CAUSE: This problem is caused by the number of columns being queried. If the number of columns is greater than 500, then the access violation occurs. If the number of columns is 500 or less, then the query works. SOLUTION: SQL/Services can only handle up to 500 columns in a query. Redesign your queries to request no more than 500 columns at a time. \ \ CONTRIBUTORS: \ \ Technical: Diane Bither

From:	BROKE::BITHER       "Please reply to [email protected]" 21-MAY-1997 07:48:47.81
To:	MEMORMAN
CC:	BITHER
Subj:	New Stars Article

TITLE:      SQL/Services Supports up to 500 Columns in a Query

PRODUCT:    SQL/Services (all versions)

OP/SYS:     OpenVMS VAX, OpenVMS AXP

SOURCE:     Oracle Worldwide Customer Support

PROBLEM:

You are using a PC query tool and SQL/Services to access an Oracle Rdb 
database or an Oracle Rdb Distributed Option database.  

Accessing the database results in a SYSTEM-F-ACCVIO access violation.

PROBLEM CAUSE:

This problem is caused by the number of columns being queried.  If the
number of columns is greater than 500, then the access violation occurs.
If the number of columns is 500 or less, then the query works.

SOLUTION:

SQL/Services can only handle up to 500 columns in a query.  Redesign your
queries to request no more than 500 columns at a time. 

\
\ CONTRIBUTORS:
\
\       Technical: Diane Bither