Re: SQL RPGLE program compilation issue

Hi
It is a select statement, i guess i cannot run using RUNSQLSTM command on 
AS400, 
here is the error i am getting in spool file
SQL0901  50     348  SQL system error.                                     
SQL8009  30          Debug view creation failed: message CPF956A, No such  
                     text in previous view..        

There is one more spool file call QPSRVDMP
 and the error in this file is 
 DUMP TAKEN FOR UNMONITORED ESCAPE MESSAGE                                      
         
 .MESSAGE ID-                   MCH1210                                         
         
 .MESSAGE FILE-                 QCPFMSG                LIBRARY-          *LIBL  
         
 .SEVERITY-                     40                                              
         
 .MSGTYPE-                      0F                                              
         
 .SENDING-                                                                      
         
 ..PROGRAM-                     cblabranch                                      
         
 LIBRARY-                                                                       
         
 ..INSTRUCTION-                 000030                                          
         
 .RECEIVING-                                                                    
         
 ..PROGRAM-                     QSQPLIST               LIBRARY-          QSYS   
         
 ..INSTRUCTION-                 00B0                                            
         
 .MESSAGE-                                                                      
         
   Receiver value too small to hold result.                                     
         
 .MESSAGE DATA-                                                                 
         
 END OF DUMP                                                                    
         

Any help will be apprecitated                       

 
A$HI$H

----- Original Message ----
From: Kenneth McMenamy <onedble0@xxxxxxxxx>
To: Java Programming on and around the iSeries / AS400 <java400-l@xxxxxxxxxxxx>
Sent: Friday, January 12, 2007 1:17:24 PM
Subject: RE: SQL RPGLE program compilation issue

Does your query run in Run Sql Scripts?
  Please provide more information.

Dan Feather <DFeather@xxxxxxxxxxxxx> wrote:
  Is there any other error information? SQL0901 is a general error that
can be caused by a lot of things.

Dan Feather
-----Original Message-----
From: java400-l-bounces@xxxxxxxxxxxx
[mailto:java400-l-bounces@xxxxxxxxxxxx] On Behalf Of Ashish Kulkarni
Sent: Friday, January 12, 2007 11:32 AM
To: java400-l@xxxxxxxxxxxx
Subject: SQL RPGLE program compilation issue

Hi
I have a SQL statement which is about 315 lines, when i write in
PreparedStatement it works fine, but when i copy it in SQLRPGLE program
it does not compile, gives some error with SQL0901 
Is there is a possibility that there is a limitation in number of lines
of SQL in SQLRPGLE program

A$HI$H
NOTICE: This electronic mail message and any files transmitted with it are 
intended exclusively
for the individual or entity to which it is addressed. The message, together 
with any attachment, may contain confidential and/or privileged
information. Any unauthorized review, use, printing, saving, copying, 
disclosure 
or distribution is strictly prohibited. If you have received this message in 
error, please immediately
advise the sender by reply email and delete all copies.