![]() |
Copyright © TIBCO Software Inc. All Rights Reserved |
TIBCO Object Service Broker National Language Support for a list of supported code pages.
-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 The code page used to read the input file. This optional argument has a default of IBM-037. -z outputcodepage The code page used to write the output file. This optional argument has a default of IBM-037.The following sections describe constraints associated with each of the files used in the translation process.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.
•
• 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)).
• 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.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).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.
For Translate In Place (-w), if a problem occurs during the hrnbrnls process, it is possible that your file is no longer usable.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.
• The audit log is written to the file TBL234.aud in the directory d:\audit (Windows) or in /usr1/audit (Solaris).
• The control file is located in c:\cntl\TBL234.ctl (Windows) or in /usr1/cntl/TBL234.ctl (Solaris).
• The input file is written in Variable Blocked format (was unloaded on Windows or Solaris).
![]() |
Copyright © TIBCO Software Inc. All Rights Reserved |