fetch ... into ... (mismatched # of fields)

Question: When we do a "FETCH ... INTO ...", and the # of fields listed on the FETCH side is greater the the # of fields listed on the INTO side, where in memory do the extra fields go? What are the consequences, if any, of doing that with a 5.x and/or a 7.x engine? In the latest documentation I've seen (Informix Guide to SQL Syntax, Version 7.2, Volume 1), it is explicitly stated that "Each value from the select list of the query ... must be returned into a memory location." (page 1-301) -- ______________________________________________________________________ | Colin McGrath cmm@trac3000.ueci.com | | Raytheon Engineers & Constructors, Inc. (215) 422-4144 | | Phila, PA, USA | | Any opinions I state are my own and not necessarily of my employer | |____________________________________________________________________|