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


Chapter 3 Tools : EXPOCC_SIZE

EXPOCC_SIZE
Returns the minimum record size required to hold the occurrences of the table being unloaded. (F)
Invocation
MAXSIZE = EXPOCC_SIZE(table)
 
Usage Notes
Use this function to help determine the record length needed in an output data set when using UNLOAD.
Example
The following rule, when executed, determines the record size needed to store data unloaded from a given UNIT and returns the size to the end message:

 
RULE EDITOR ===> SCROLL: P
EXPOCC_SIZE_1(UNIT_TO_UNLOAD);
_ LOCAL MAXSIZE;
_ ---------------------------------------------------------------------------
_ ------------------------------------------------------------+--------------
_ MAXSIZE = 0; | 1
_ FORALL TABLES WHERE UNIT = UNIT_TO_UNLOAD & TYPE = 'TDS' : | 2
_ MAXSIZE = MAX(MAXSIZE, EXPOCC_SIZE(TABLES.NAME)); |
_ END; |
_ CALL ENDMSG('MINIMUM DATA SET RELOAD SIZE TO UNLOAD' || | 3
_ ' TABLES IN ' || UNIT_TO_UNLOAD || ' IS ' || MAXSIZE); |
_ ---------------------------------------------------------------------------

 

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