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


Chapter 3 Tools : SETNLSBIT

SETNLSBIT
Sets the NLS bit for the specified table, in the RESERVED field of the TABLES table. (C)
Invocation
CALL SETNLSBIT(table, flag)
 
A character string specifying the name of the table. Its syntax is C (fixed-length character string) with length 16.
Usage Notes
Setting the NLS bit on for a specified table indicates that the table uses the system code page, rather than the TDS code page. For example, you must turn the NLS bit on when storing binary data in a table. In this case, you must use type S and syntax V, and setting the NLS bit on insulates your table from NLS translation, because the translation could render your binary data unintelligible.
Example
This rule sets the NLS bit on for the table whose name is passed to the rule:

 
SET_NLS_BIT(TABLENAME);
_ LOCAL TABLENAME;
_ ------------------------------------------------------------------------
_ ------------------------------------------------------------+-----------
_ CALL SETNLSBIT(TABLENAME, 'Y'); | 1
_ ------------------------------------------------------------------------

 
See Also
TIBCO Object Service Broker National Language Support for information about using the NLS bit.

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