Copyright © Cloud Software Group, Inc. All Rights Reserved

OLDNULL Option (Batch Unloads S6BBRULB and S6BBRULH Only)

If this EXEC parameter is specified, the unload utilities unload null values as zeroes. The parameter setting OLDNULL=Y allows for compatibility with earlier TIBCO Object Service Broker releases and for tables being unloaded but not intended for reloading.

Example

The following illustrates the usage of the oldnull option:

---

 

EXEC PGM=S6BBRULB,PARM=’SEGMENT=segment#,OLDNULL=Y’

EXEC PGM=S6BBRULH,PARM=’U=userid,P=password,T=DOBname,M=modelname,OLDNULL=Y’

EXEC PGM=S6BBRULH,PARM=’TTTTTTTTMMMMMMMMOLDNULL’

---

 

where:

 

TTTTTTTT	Is an 8 character DOBname (add blanks to the right of a shorter DOBname if necessary)
MMMMMMMM	Is an 8 character modelname (add blanks to the right of a shorter modelname if necessary)

Floating Point Nulls

You cannot represent a floating point null in fixed format. When a floating point null is unloaded using S6BBRULB or S6BBRULH, it is unloaded as true zero. Therefore, when floating point nulls are reloaded using S6BBRTBL, they are loaded as a zero.

Copyright © Cloud Software Group, Inc. All Rights Reserved