Focal Point Banner


As of December 1, 2020, Focal Point is retired and repurposed as a reference repository. We value the wealth of knowledge that's been shared here over the years. You'll continue to have access to this treasure trove of knowledge, for search purposes only. Moving forward, myibi is our community platform to learn, share, and collaborate. We have the same Focal Point forum categories in myibi, so you can continue to have all new conversations there. If you need access to myibi, contact us at myibi@ibi.com and provide your corporate email address, company, and name.


Connect to myibi
Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     [CLOSED] Focus on mainframe - problem after migration to DB2 v 9.0

Read-Only Read-Only Topic
Go
Search
Notify
Tools
[CLOSED] Focus on mainframe - problem after migration to DB2 v 9.0
 Login/Join
 
Member
posted
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,
 
Posts: 25 | Registered: June 23, 2009Report This Post
Expert
posted Hide Post
A couple of things.

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


Waz...

Prod:WebFOCUS 7.6.10/8.1.04Upgrade:WebFOCUS 8.2.07OS:LinuxOutputs:HTML, PDF, Excel, PPT
In Focus since 1984
Pity the lost knowledge of an old programmer!

 
Posts: 6349 | Location: 33°49'23.0"S, 151°11'41.0"E | Registered: October 31, 2006Report This Post
Member
posted Hide Post
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.
 
Posts: 25 | Registered: June 23, 2009Report This Post
Expert
posted Hide Post
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.


Waz...

Prod:WebFOCUS 7.6.10/8.1.04Upgrade:WebFOCUS 8.2.07OS:LinuxOutputs:HTML, PDF, Excel, PPT
In Focus since 1984
Pity the lost knowledge of an old programmer!

 
Posts: 6349 | Location: 33°49'23.0"S, 151°11'41.0"E | Registered: October 31, 2006Report This Post
  Powered by Social Strata  

Read-Only Read-Only Topic

Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     [CLOSED] Focus on mainframe - problem after migration to DB2 v 9.0

Copyright © 1996-2020 Information Builders