Q
Evaluate Weigh the pros and cons of technologies, products and projects you are considering.

Working around the internal failure error message

I am using the following OPNQRYF statement:

 
OPNQRYF FILE((*LIBL/INPOP30H) (*LIBL/MSVMP100)) FORMAT(G#MHP001)
QRYSLT('poiglCS *EQ + "0000030" *AND RQ3DT *GE "' *CAT &FRYMDL + *CAT '"
*AND RQ3DT *LE "' *CAT &TOYMDL + *CAT '" ') KEYFLD(*FILE) JFLD((1/VNDNO +
2/VNDNO)) MAPFLD((VNDNO '1/vndno') + (POIGLC '%digits(poigl)' *CHAR 15) +
(POIGLCS '%sst(poiglc 1 7)' *CHAR 7)) + OPNID(G#MHP001)
OPTIMIZE(*MINWAIT)OPTALLAP(*YES) TYPE(*PERM) 

The above statement has been working and only recently began failing with the following error message: Pointer no set for location referenced. Internal failure occurred in query processor. CPF4204

I do not know how to resolve. Any ideas?


An internal failure error message usually means you have hit a defect in the operating system. I would verify that you have the latest Database Group PTF installed and if you do, then report the problem to IBM Support.

==================================
MORE INFORMATION ON THIS TOPIC
==================================

Search400.com's targeted search engine: Get relevant information on DB2/400.

The Best Web Links: tips, tutorials and more.

Check out this online event, Getting the Most out of SQL & DB2 UDB for the iSeries.


This was last published in June 2003

Dig Deeper on DB2 UDB (universal databases)

Have a question for an expert?

Please add a title for your question

Get answers from a TechTarget expert on whatever's puzzling you.

You will be able to add details on the next page.

Start the conversation

Send me notifications when other members comment.

Please create a username to comment.

-ADS BY GOOGLE

SearchDataCenter

Close