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


Appendix C Null Handling : Alternative Null Equivalents

Alternative Null Equivalents
Alternatives to the default null-handling behavior are applicable only for syntax B and P. Possible alternatives include:
For packed decimal the alternate positive sign (X’A’) is used.
Enter HIGHVALUE in columns 64-74.
For packed decimal the standard signs—X’C’ for positive and X’D’ are used.
You must enter the null equivalent selected in the Null-Equivalent field (columns 64-79) of the appropriate control record.
Enter NOVALUE in columns 64-79.
When unloading TIBCO Object Service Broker tables, if the null equivalent value is discovered in the table, it is considered to be an error. Similarly, if a null is discovered in a NOVALUE field in the table being unloaded, this error causes the unload utility to abort.

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