Looks like it's blowing up when creating an intermediate object. The size of the result set affects it. I would make sure I'm on the current DB2 Group PTF; if that doesn't fix it, report it to IBM. A workaround might be to rework the query so you don't use DISTINCT. DISTINCT can result in inefficient processing, and programmers sometimes slap a DISTINCT on a query without understanding the underlying DB relationships. DB2 Group PTF info: http://www-912.ibm.com/s_dir/slkbase...e?OpenDocument
Unconfigured Ad Widget
Collapse
Announcement
Collapse
No announcement yet.
SQL Error: Field 0 in mapping template not valid when creating.
Collapse
X
-
SQL Error: Field 0 in mapping template not valid when creating.
Hi Folks, I am using imbedded SQL over a very large file (over 10,000,000 records) in an ILE program. The sql SELECT statement I am using should yield a distinct list over just a few thousand appropriate records (due to the WHERE clause filtration) I have found that, when the file grew larger, I received the following message (See below) Does anybody know if there is an upper limit to the size of a file when using imbedded SQL? Has anybody seen this error before? Thanks for your help, johnT.
Code
Comment