Rounding the value

vinomails · #1 (**permalink**) 07-02-08, 06:32

Hi,

I am new to Informix. Can any one tell me, how can i round the value in informix.

Regards,
Vinothkumar S.

ceinma · #2 (**permalink**) 07-02-08, 11:10

http://publib.boulder.ibm.com/infoce...75%6e%64%22%20

sohel2 · #3 (**permalink**) 07-03-08, 06:06

Here is the sample data

memno|acct_num|routno|enrolldt|totalpaid|rpt_date
100|2222|3245|2/2/2002|10|Mar
120|4444|5678|3/2/2003|2|April
543|6666|7676|4/4/2005|20|May
999|8888|6900|6/7/2004|40|June

I need the data in the format below

memno|acct_num|routno|enrolldt|Mar|April|May|June
100|2222|3245|2/2/2002|10|0|0|0
120|4444|5678|3/2/2003|0|2|0|0
543|6666|7676|4/4/2005|0|0|20|0
999|8888|6900|6/7/2004|0|0|0|40

Internet Services

Web Development

Digital Marketing

Consumer Tech