Hello,
we have just upgraded to a new version of DB2 (V.9 Conversion Mode) and we get an error in this part of program (before the migration this code was ok):

  
JOIN CLEAR *                               
DEFINE FILE TABLE1                        
VALUE1   /P11L  = PERCENTAGE1 * 100000000;     
DATA1    /YYMD  = &&DATASK;                
END                                        
-*                                         
TABLE FILE TABLE1
SUM  MAX.VALUE1
BY FIELD1
BY FILED2
WHERE XXXX1 EQ '1' 
WHERE DATAX LE DATA1    
ON TABLE HOLD AS 'XXXXXXX1'                    
END                                        

Error:

quote:

> (FOC1425) OVERFLOW, ZERODIVIDE OR CONVERSION ERROR ON ITEM £ :
3/MAX((T1."PERCENTAGE1" * 100000000))
(FOC1400) SQLCODE IS 802 (HEX: 00000322)
(FOC1407) SQL FETCH CURSOR ERROR. : TABLE1
ERROR AT OR NEAR LINE 43 IN PROCEDURE XXXXX98FOCEXEC

The format of the field PERCENTAGE1 in the table is DECIMAL (11,8) and it is converted in the Master file as P13.8. The max value for the field is 100.

We have solved the problem in this way:

JOIN CLEAR *                               
DEFINE FILE TABLE1                        
VALUE1   /P13.8L  = PERCENTAGE1;     
DATA1    /YYMD    = &&DATASK;                
END                                        
-*                                         
TABLE FILE TABLE1
SUM  MAX.VALUE1
BY FIELD1
BY FILED2
WHERE XXXX1 EQ '1' 
WHERE DATAX LE DATA1    
ON TABLE HOLD AS 'XXXXXXX1'                    
END   
-*
DEFINE FILE XXXXXXX1
VALUE2   /P11L  = VALUE1 * 100000000; 
...................
...................
END

Should we check something in the Focus settings after the migration? We could have this error in other programs and we are wondering how we can fix this problem.

Thanks for any help!


Focus version: FOCUS 7.2.0S1
DB2 version for mainframe: V.9
OS: ibm mvs 390

This message has been edited. Last edited by: Kerry,

A couple of things.

1. Does your version FOCUS support this version of DB2 ?
2. Have you tried recreating the master ?

Hello,
thanks for the replay.

quote:

1. Does your version FOCUS support this version of DB2 ?

I was not involved in the DB2 migration, but I think the system administrator has verified the compatibility.
The Focus version for mainframe is 7.2.0S1 and the DB2 version is 9.0.
At this moment,after the migration, we got only that problem and all the others focex run correctly.

quote:

2. Have you tried recreating the master ?

Not yet, I am not authorized.
But after a migration, is it a best practice? There are a lot of master file to be recreated.

Another posibility is that there may be some bad data in a table, do you know if other report would have used this reports information ?

You may have to put a case in with Techsupport.