Re: RPT7998 - Errors may invalidate your report

[Avis Ramuk <as400_techmails@xxxxxxxxx>]

The command REPORT seems to be supplied by the utility SEQUEL and is not an 
AS/400 command.
   
  This is command , the program executing
   
  REPORT     REPORT(REPORT1) SQL(&SQLSTATMNT) +   
             TITLE(&TITLE1) OPTIMIZE(*FIRSTIO) 
   REPORT1 -> report name this matches the SQLRPT data area created via the 
Design Report (DSNREPORT)
  SQLSTATMNT -> SQL Queury
  TITLE1 -> Tile for the report.
   
  I know the problem should be with the SQL statement. But couldnt figure out 
:(.
  The SQL statement is a simple join query on two files with a WHERE, GROUP BY 
and HAVING conditions. Any help?
   
  

Jerry Adams <jerry@xxxxxxxxxxxxxxx> wrote:
  RPTxxxx messages were/are found on Auto Report compiles. But this 
doesn't sound like one of those.


Personally I don't have a REPORT command on my v5r3 520. Doesn't mean 
anything, though, as I don't have every utility loaded. But for kicks 
and grins, where does this command reside? DSPCMD Report. Or do you 
already know the utility or package that uses it? 


* Jerry C. Adams
*iSeries Programmer/Analyst
B&W Wholesale Distributors, Inc.* *
voice
615.995.7024
fax
615.995.1201
email
jerry@xxxxxxxxxxxxxxx 



Avis Ramuk wrote:

>Hi,
> 
> I am getting an error "RPT7998 - Errors may invalidate your report" in one of 
> my CLP program. This was an old code and I am getting this error when it 
> tries to create a report using the command REPORT. It happens once in a 
> while. I could not be able to track this so far. Can any please enlighten 
> what causes this error? and what could be the impact of this one, if I 
> ingnore this error?.
> Thanks,
> Avis Ramuk.
>
> 
>---------------------------------
>Yahoo! Mail
>Bring photos to life! New PhotoMail makes sharing a breeze. 
> 
>