Field1 of the 1st hold file : Format 'P4' Filed2 of the 2nd hold file : Format 'A2V'This message has been edited. Last edited by: Abdess,
WebFOCUS 8.0
January 19, 2015, 01:20 PM
Francis Mariani
If you're creating two HOLD files why not create columns with a common format? For the first HOLD file, use the PTOA function to convert your P4 column. For the second HOLD file, reformat the column to A4, COLUMN2/A4.
Francis
Give me code, or give me retirement. In FOCUS since 1991
Production: WF 7.7.05M, Dev Studio, BID, MRE, WebSphere, DB2 / Test: WF 8.1.05M, App Studio, BI Portal, Report Caster, jQuery, HighCharts, Apache Tomcat, MS SQL Server
January 19, 2015, 01:40 PM
Abdess
Ok i will try and i will let you know of the result.
Thanks
WebFOCUS 8.0
January 19, 2015, 02:36 PM
Waz
The one othere thing needed when joining hold files is to sort both files by the join keys, unless they are FOCUS files with the join key indexed.
Waz...
Prod:
WebFOCUS 7.6.10/8.1.04
Upgrade:
WebFOCUS 8.2.07
OS:
Linux
Outputs:
HTML, PDF, Excel, PPT
In Focus since 1984
Pity the lost knowledge of an old programmer!
January 20, 2015, 05:17 AM
Abdess
When i run the report i have this error message :
"WebFOCUS was called with an invalid request."
Any idea ??
WebFOCUS 8.0
January 20, 2015, 07:33 AM
MartinY
Share you whole code, it help us helping you...
WF versions : Prod 8.2.04M gen 33, Dev 8.2.04M gen 33, OS : Windows, DB : MSSQL, Outputs : HTML, Excel, PDF In Focus since 2007
January 22, 2015, 08:49 AM
MartinY
If this is solved, what I think is according to your other post, please provide the solution and edit your first post to add [SOLVED] at the beginning of the subject.
WF versions : Prod 8.2.04M gen 33, Dev 8.2.04M gen 33, OS : Windows, DB : MSSQL, Outputs : HTML, Excel, PDF In Focus since 2007
January 22, 2015, 09:10 AM
Abdess
Yes it's solved , thank you Martin.
The solution is to convert the Filed2 of the 2nd hold file to Decimal "D4" and after and then i converted to Packed "P4" .