Re: SQL pre compiler error CPF956A

[darren@xxxxxxxxx]

I compile almost all my "fancy" SQLRPGLE programs with DBGVIEW(*SOURCE) and
have not seen that error with V5R2.  I've pasted the full description of
the error you received below.  I was looking at an API that would issue
this type of error Add View Text (QteAddViewText) API, and it talks about
debug views so I think this may be the actual API the compile is bombing
on.  When you're running debugger on an SQL program, you don't actually see
the underlying database calls, but rather, you see the SQL statements that
were in your source.  I'm guessing something is going wrong creating these
SQL source views.  Do you know which area of the source the error is being
issued against?


 Message . . . . :   No such text in previous view.
 Cause . . . . . :   A text descriptor indicated that text from line &1 in
the
   previous view was to be used.  However, this text does not exist.
 Recovery  . . . :   Before text in a previous view can be specified in a
text
   descriptor, the text descriptors for the previous view must be added.
The
   text specified which comes from the previous view must exist in the text
   descriptors. Refer to the System Programmer's Interface Reference
   (SC41-8223) for a discussion of using the source debug programming
   interfaces.



                      "Westdorp, Tom"
                      <Tom.Westdorp@StationC        To:       
rpg400-l@midrange.com
                      asinos.com>                   cc:
                      Sent by:                      Fax to:
                      rpg400-l-admin@midrang        Subject:  SQL pre compiler 
error CPF956A
                      e.com


                      10/29/2002 05:34 PM
                      Please respond to
                      rpg400-l







[ Picked text/plain from multipart/alternative ]
We're on v5r2, and one of my colleagues that uses that 'fancy SQL stuff' is
trying to compile a module (CRTSQLRPGI) with DBGVIEW(*SOURCE) instead of
the
default *NONE and the SQL precompiler throws out:

SQL8009  30          Debug view creation failed: message CPF956A, No such
                     text in previous view..

and quits.

Info Center offers nothing for the SQL8009, and just a ref to the
QteAddViewText API for the CPF956A.  She's not using that API.

The module compiles fine with DBGVIEW(*NONE).