Fields included in ProIV SELECT statement
Posted 14 January 2003 - 03:57 AM
I have ran a ProIV trace for a function and it seems that ProIV is SELECTing all the fields from a paticular filedef.
This is causing us a problem because there are more than 255 fields and we are then getting a BUS error.
Has anyone encountered this before? (and found a solution).
Posted 14 January 2003 - 10:36 AM
SELECT FIELD1, FIELD2.... FIELDN FROM TABLENAME
to substitute the following
SELECT FROM TABLENAME
or SEL-ONLY(), SEL-PARTIAL(), SEL-RANGE()
it should work
Posted 14 January 2003 - 11:55 AM
I believe ProIV V3 may have done what you suggest. In V3 the Oracle driver was implemented using 'embedded SQL' (Pro*C).
I think this behaviour may have stopped in V4.0 when the driver was rewritten using the Oracle Call Interface (OCI).
I suspect it was not a good 'optimisation' for tables with a 'moderate' number of columns as it probably gave rise to too many different SQL statements (thus defeating some important optimisations within Oracle).
Would it be practical for you to set up some suitable views containing subsets of the columns from your many-column table?
Posted 14 January 2003 - 09:53 PM
Looks like we'll have to split the filedefs.
Thanks for your help.
Reply to this topic
0 user(s) are reading this topic
0 members, 0 guests, 0 anonymous users