![]() |
Copyright © TIBCO Software Inc. All Rights Reserved |
The S6BBRNLS member of the JCL data set distributed with TIBCO Object Service Broker contains sample JCL required to run this utility.
If you want to overwrite the input file, the INFILE and OUTFILE statements can be replaced with an INPLACE statement:The code page parameters INCP and OUTCP are optional. If you do not specify code pages, these values default to 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 (CNTRL DD statement). This file is identical to the control file used by S6BBRTBL (offline batch load utility) and can be created using BATCHLOAD_CARDS or manually with the editor of your choice. For complete information, refer to the documentation for BATCHLOAD_CARDS in TIBCO Object Service Broker Shareable Tools.
• S6BBRNLS is designed to translate table data unloaded from a TIBCO Object Service Broker table using one of the offline batch unloads (S6BBRULB, S6BBRULH, S6BBRULA).
• S6BBRNLS is designed to translate unloaded table data before it is loaded to a TIBCO Object Service Broker table using the offline batch load (S6BBRTBL).
• The S6BBRNLS input file (CNTRL DD statement) 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.
• S6BBRNLS 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. This could yield an unacceptable result.
• If a field is eligible for translation and is also a parameter or primary key field, consider sorting the output file after translation.This unload file must be in the correct sequence (ascending parameter 1 through n and primary key 1 through n).The output file must be allocated with the same characteristics as those of the input file (DCB=*.INFILE). The 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 therefore requires sorting prior to the load, a message is issued in the audit file.S6BBRNLS is designed to translate table data unloaded from a TIBCO Object Service Broker table using one of the offline batch unloads (S6BBRULB, S6BBRULH, S6BBRULA). 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 changed with translation, and therefore requires sorting prior to the load, a message is issued on the audit file.
For Translate In Place (INPLACE), if a problem occurs during the S6BBRNLS 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. If you encounter problems about which you need to contact TIBCO Support, have this file available.
Sample Audit Log
•
•
•
• TIBCO Object Service Broker National Language Support for a list of supported code pages.
![]() |
Copyright © TIBCO Software Inc. All Rights Reserved |