may contain an infinite loop.   SQLSTATE=01605

values bitand(10,8);

1           

          8 

values bitand(14,3);

1           

          2 

values bitand(1038,78);

1           

         14 

A.2  Sample code for FORMAT function

This section provides UDF for FORMAT function. Example A 3 shows the code 

for a user defined function emulating FORMAT.

Example: A 3   FORMAT user defined function

   DB2 UDB UDF(User Defined Function) Samples for Migration

   Created: 2004/02/29

   Name of UDF: FORMAT (X Decimal(31,10), D Integer)

   Used UDF: None

   Description: Returns truncated to the precision specified by D and a "," for 

each 3 digits as a separator.

   Author: TOKUNAGA, Takashi

 Appendix A. Sample code for user defined functions 

337