Copyright © TIBCO Software Inc. All Rights Reserved
Copyright © TIBCO Software Inc. All Rights Reserved


Chapter 1 Using TIBCO Object Service Broker Utilities : hrnbrnls (Translate File Between Different Code Pages)

hrnbrnls (Translate File Between Different Code Pages)
Syntax
hrnbrnls -A auditfile -C controlfile [arguments] -L inputfile -U outputfile
Platforms
Windows, Solaris
Description
The hrnbrnls utility is used to translate files between different code pages.
See Also
TIBCO Object Service Broker National Language Support for a list of supported code pages.
Arguments
 
-A auditfile
The file to which the audit report is written. If this argument is omitted, the report is written to stdout.
-C controlfile
Indicates that the input file is in z/OS Variable Block format. If the input file (refer to the -L argument) was created using one of the offline batch unload utilities– hrnbrula (Batch Unload from Archive), hrnbrulb (Batch Unload (Offline)), or hrnbrulh (Batch Unload (Online))–the -m argument must be specified on the command line. If the input file was created on z/OS and ported to Windows or Solaris, do not include the -m argument.
Indicates you want to overwrite the previously existing input file. This argument is optional.
-L inputfile
-U outputfile
The full path and name of the output file. This argument is mandatory unless -w is specified, in which case the input filename is also the output filename.
-y inputcodepage
-z outputcodepage
Constraints
The following sections describe constraints associated with each of the files used in the translation process.
Control File
You must prepare a correctly formatted control file (-C). This file is identical to the control file used by the hrnbrtbl (Batch Load) offline utility and can be created using either the BATCHLOAD_CARDS shareable tool, or created manually with the editor of your choice. For complete information on the use of BATCHLOAD_CARDS, refer to TIBCO Object Service Broker Shareable Tools.
Eligible Fields
All file fields that have all the following characteristics are eligible for translation:
Creating the Control File
When creating the control file, consider the following factors:
The hrnbrnls utility is designed to translate unloaded table data prior to it being loaded to a TIBCO Object Service Broker table using the hrnbrtbl (Batch Load) offline utility.
The input file (-L) for the hrnbrnls utility must be completely defined and every file (input) field must have an associated table (output) field. File fields that have no target table field definition are not eligible for translation.
The hrnbrnls utility has no way of recognizing bit-strings. A field defined as character input that is effectively a bit-string is eligible for translation if its target table field is also defined as character.
If a field is eligible for translation and is also a parameter or a primary key field, consider sorting the output file (-U) after translation. If any such fields exist in the input file, it is recommended that translation and sorting be done on z/OS prior to a port to Windows or Solaris if the file is to be ported in this way.
If the file to be translated was created by one of the offline batch unload utilities—hrnbrula (Batch Unload from Archive), hrnbrulb (Batch Unload (Offline)), or hrnbrulh (Batch Unload (Online))—it is a variable format file, in which case you must ensure that the V (variable) flag is specified on the Input File definition screen of the BATCHLOAD_CARDS tool.
Input File (-L)
The hrnbrnls utility is designed to translate table data that is unloaded from a TIBCO Object Service Broker table using one of the batch unload utilities: hrnbrula (Batch Unload from Archive), hrnbrulb (Batch Unload (Offline)), or hrnbrulh (Batch Unload (Online)). The unloaded file must be in TIBCO Object Service Broker data format (EBCDIC) and must be in the correct sequence (ascending: parameter 1 through n, and primary key 1 through n).
Output File (-U)
The translation creates an output file with the same characteristics as those of the input file. This file must be in the correct sequence for the table to which it is to be loaded (ascending: parameter 1 through n, and primary key 1 through n). If the sequence of the file changed with translation, and thus requires sorting prior to the load, a message indicating this is issued in the audit file.
Translate In Place (-w)
The hrnbrnls utility is designed to translate table data that is unloaded from a TIBCO Object Service Broker table using one of the offline batch unload utilities: hrnbrula (Batch Unload from Archive), hrnbrulb (Batch Unload (Offline)), or hrnbrulh (Batch Unload (Online)). This unload file must be in the correct sequence (ascending: parameter 1 through n, and primary key 1 through n). If the sequence of the file is changed by translation, and thus requires sorting prior to the load, a message indicating this is issued on the audit file.
Audit File (-A)
This file is an activity report containing information, warning and error messages as well as run statistics. This report should always be inspected before using the output file in another process. This file is required if you encounter a problem that requires the assistance of a TIBCO Support representative.
Return Codes
 
Example
Windows
hrnbrnls -A d:\audit\TBL234.aud -C c:\cntl\TBL234.ctl -m
         -L TBL234.in -U TBL234.out -y IBM-037 -z IBM-278
Solaris
hrnbrnls -A /usr1/audit/TBL234.aud -C /usr1/cntl/TBL234.ctl -m
         -L TBL234.in -U TBL234.out -y IBM-037 -z IBM-278
These examples show:
Related Utilities

Copyright © TIBCO Software Inc. All Rights Reserved
Copyright © TIBCO Software Inc. All Rights Reserved