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


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

S6BBRNLS (Translate File Between Code Pages)
The S6BBRNLS utility is used to translate files between different code pages.
Invocation
The S6BBRNLS member of the JCL data set distributed with TIBCO Object Service Broker contains sample JCL required to run this utility.
This sample is provided as a reference only; modify the JCL for your needs.
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 (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.
When creating the control file, consider the following:
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.
Eligible File Fields
File fields that have all the following characteristics are eligible for translation:
Input File (INFILE)
This unload file must be in the correct sequence (ascending parameter 1 through n and primary key 1 through n).
Output File (OUTFILE)
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.
Translate In Place (INPLACE)
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.
Audit File (AUDIT)
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.
Return Codes
 
Sample Audit Log
The following illustrates a sample translation audit log for the S6BBRNLS utility:

 
*S6BBRNLS NLS CODE PAGE TRANSLATION UTILITY 0 DATE 2009 Apr 11 TIME 08:59
-------------------- TABLE -----------------------
CONTROL - file: S6B.TST.NLS.CNTL (TC006001)
INPUT - file: S6B.TST.NLS.IBM278 (IN1 );
Data type: Huron; Record format: Variable
HURON TDS Table: SVEN_1, Character Set: SVEN
OUTPUT - file: SYS07101.T085856.RA000.1234T.NLS.H03 ;
Data type: Huron; Record format: Variable
#fields - 650; #records - 100000; #parameters - 0; #secondaries - 0
Input/Output sizes: Record - 34; Minimum Record - 34 Buffer - 65536
FIELD: FIELD1 ---> FIELD1 (PRIMARY KEY)
IN: type= ; syn= C; len= 30; dec= 0; offset=0
OUT: type= S; syn= C; len= 30; dec= 0; fld= 1; key= 1; prm= 0
END OF TABLE
IBM-278 -> IBM-277 S6BBC205I Translation requested
2 S6BBC224I Records Translated
0 S6BBC225I Records Copied
2 S6BBC207E Total Records Processed
2 S6BBC226I Values Changed
2 S6BBC227I Records Changed
*******************************************************************

 
Related Utilities
See Also
TIBCO Object Service Broker National Language Support for a list of supported code pages.

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