.PL63 .PN1 L..........................................R...L.....................A .FO2 AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA>@@ [[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[ UNOTE 064 Page # of 3 Ref: UNOTE 064~ L....T..T..................................R...L.....................A From‰:‰ Customer Services 05 Dec 89~ L....T..T............................................................R L....T..T...................................................................R Re‰ :‰ Configuring the Report Writer to use the European Decimal separator L..............................................................R.L...A AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA>@@ [[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[ L.......T.......T.......T.......T.......T.......T.......T.......T....J QUESTION@@ EEEEEEEE How can the Report Writer be configured to employ the European Decimal comma separator "," ? ANSWER@@ EEEEEE Several changes are required to the configuration files in order that the European decimal comma separator can be employed by the Report Writer in Uniplex Version 6.10. The template@@ EEEEEEEEEEEE When the decimal separator is modified, the Report Writer templates must also be modified. ....L...T.......T.......T.......T.......T.......T.......T.......T....J Keyword separators@@ CCCCCCCCCCCCCCCCCC Keyword separators are semi-colons ";" when the decimal separator is the comma "," . Therefore, all labels and options defined in the ":LABEL" section of the report template must be separated by semi-colons. For example: name; float; strip;@@ RRRRRRRRRRRRRRRRRRR Formats@@ CCCCCCC The format patterns must also be modified to reflect the changes to the decimal separator. Therefore, with the comma as the decimal separator, and the dot as the thousand separator, a typical format pattern could be for example: format = Z.ZZZ.ZZ9,99;@@ RRRRRRRRRRRRRRRRRRRRRR L.......T.......T.......T.......T.......T.......T.......T.......T....J File: UAP/uniplex.sys@@ EEEEEEEEEEEEEEEEEEEEE ....L...T.......T.......T.......T.......T.......T.......T.......T....J In the file "UAP/uniplex.sys" change the entry for "DECTAB" to:@@ RRRRRRRRRRRRRRR RRRRRR DECTAB=','@@ RRRRRRRRRR Recompile the file using the command: syscomp  -s@@ RRRRRRRRRRR .PA L.......T.......T.......T.......T.......T.......T.......T.......T....J File: UAP/ureport/ureport.rc@@ EEEEEEEEEEEEEEEEEEEEEEEEEEEE ....L...T.......T.......T.......T.......T.......T.......T.......T....J The decimal separator symbol and the thousand separator symbol need to be specified in the Report Writer initialization file "UAP/ureport/ureport.rc" for display and formatting purposes.@@ RRRRRRRRRRRRRRRRRRRRRR The order of the comma (decimal symbol) and the dot (thousand symbol) in this file is important. The following is a section from ureport.rc taken from an English language version of Uniplex. .FN FX-SMALL .............L..T.......T.......T.......T.......T.......T.......T....J 9~ U~ L~ .~ ,~ +~ -~ ....L...T.......T.......T.......T.......T.......T.......T.......T....J .FN NORMAL For European versions, the . and , should be swapped:@@ Q Q .............L..T.......T.......T.......T.......T.......T.......T....J .FN FX-SMALL 9~ U~ L~ ,~ .~ +~ -~ ....L...T.......T.......T.......T.......T.......T.......T.......T....J .FN NORMAL These symbols will generally be employed when formatting and displaying Report Writer "Z.ZZ9,99" fields. L.......T.......T.......T.......T.......T.......T.......T.......T....J File: UAP/wp/ureport.fn@@ EEEEEEEEEEEEEEEEEEEEEEE ....L...T.......T.......T.......T.......T.......T.......T.......T....J The file "UAP/wp/ureport.fn" is configured to insert Report Writer@@ RRRRRRRRRRRRRRRRR commands and formatting definitions via the softkeys. Modify the various sections to reflect the changes required for the European decimal separator. In the section "#URLABEL2" .JN .FN FX-SMALL 1='; strip; float; extend':M(#URLABEL3) 2='; left':M(#URLABEL3) 3='; right':M(#URLABEL3) .JY .FN PS-NORMAL ....H.....L.....T.......T.......T.......T.......T.......T.......T....J Note: The comma field separators must be changed to semi-colons @@ IIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIII ";" .@@ IIIII ....L...T.......T.......T.......T.......T.......T.......T.......T....J In the section "#URLABEL3" .JN .FN FX-SMALL 1=';':F21:'\r':F9:D201:T(\r):M(#URLABEL2) 2=' ;format = -ZZ.ZZZ.ZZ9,99;':F21:'\r':F9:D201:T(\r):M(#URLABEL2) 3=' ;format = (£ZZ.ZZZ.ZZ9.99);':F21:'\r':F9:D201:T(\r):M(#URLABEL2) .JY .FNPS-NORMAL ....H.....L.....T.......T.......T.......T.......T.......T.......T....J Note: The comma field separators have been changed to semi-colons @@ IIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIII ";". In the format specification, the thousand separator is @@ IIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIII the dot "." and the decimal separator is the comma ",".@@ IIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIII ..........L.....T.......T.......T.......T.......T.......T.......T....J The currency symbol may also be changed in the format @@ IIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIII specification if required.@@ IIIIIIIIIIIIIIIIIIIIIIIIII ....L...T.......T.......T.......T.......T.......T.......T.......T....J .PM5 In the section "#URLOCAL3" .JN .FN FX-SMALL 1='; strip; float; extend':M(#URLOCAL4) 2='; left':M(#URLOCAL4) 3='; right':M(#URLOCAL4) .FN PS-NORMAL .JY ....H.....L.....T.......T.......T.......T.......T.......T.......T....J Note: The comma field separators must be changed to semi-colons @@ IIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIII ";" .@@ IIIII ....L...T.......T.......T.......T.......T.......T.......T.......T....J In the section "#URLOCAL4" .JN .FN FX-SMALL 1=';':F21:'\r':F9:D206:T(\r):' = ':M(#URLOCAL2) 2=' ;format = -ZZ.ZZZ.ZZ9,99;':F21:'\r':F9:D206:T(\r):' = ':M(#URLOCAL2) 3=' ;format = (£ZZ.ZZZ.ZZ9,99);':F21:'\r':F9:D206:T(\r):' = ':M(#URLOCAL2) .JY .FNPS-NORMAL ....H.....L.....T.......T.......T.......T.......T.......T.......T....J Note: The comma field separators have been changed to semi-colons @@ IIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIII ";". In the format specification, the thousand separator is @@ IIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIII the dot "." and the decimal separator is the comma ",".@@ IIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIII ..........L.....T.......T.......T.......T.......T.......T.......T....J The currency symbol may also be changed in the format @@ IIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIII specification if required.@@ IIIIIIIIIIIIIIIIIIIIIIIIII ....L...T.......T.......T.......T.......T.......T.......T.......T....J Before the modifications can take effect, the softkey file needs to be recompiled using the command: skcomp  ureport.fn@@ RRRRRRRRRRRRRRRRRR ....H.....L.....T.......T.......T.......T.......T.......T.......T....J Note: The database applications "uform" and "usql" do not respect@@ IIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIII DECTAB in Uniplex version 6.10. This means that arithmetic@@ IIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIII operations must be performed on the data extracted from the@@ IIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIII database, before using the Report Writer.@@ IIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIII